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 13:35:04 UTC
[jira] [Resolved] (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 resolved OAK-3445.
---------------------------------
Resolution: Fixed
trunk: http://svn.apache.org/r1705027
1.2: http://svn.apache.org/r1705030
1.0: http://svn.apache.org/r1705034
> 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
> Fix For: 1.3.7, 1.2.7, 1.0.22
>
>
> 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)