You are viewing a plain text version of this content. The canonical link for it is here.

Posted to oak-issues@jackrabbit.apache.org by "Julian Reschke (JIRA)" <ji...@apache.org> on 2015/09/24 12:21:04 UTC

[jira] [Created] (OAK-3445) RDBDocumentStore: when generating SQL for queries, leave out unneeded constraints

Julian Reschke created OAK-3445:
-----------------------------------

             Summary: RDBDocumentStore: when generating SQL for queries, leave out unneeded constraints
                 Key: OAK-3445
                 URL: https://issues.apache.org/jira/browse/OAK-3445
             Project: Jackrabbit Oak
          Issue Type: Technical task
          Components: rdbmk
            Reporter: Julian Reschke


The WHERE clauses are currently generated in a generic fashion, thus including constraints on IDs that are known to evaluate to TRUE. This causes confusion when people look at SQL traces. It would help to skip constrains for {{ID > NodeDocument.MIN_ID_VALUE}} and {{ID < NodeDocument.MAX_ID_VALUE}}.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)