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:31:04 UTC
[jira] [Updated] (OAK-3445) RDBDocumentStore: when generating SQL
for queries, leave out unneeded constraints
[ https://issues.apache.org/jira/browse/OAK-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Reschke updated OAK-3445:
--------------------------------
Affects Version/s: 1.0.21
1.3.6
1.2.6
> 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
> Affects Versions: 1.0.21, 1.3.6, 1.2.6
> Reporter: Julian Reschke
> Assignee: 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)