[ https://issues.apache.org/jira/browse/OAK-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Reschke reassigned OAK-3445: ----------------------------------- Assignee: Julian Reschke > 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 > 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)