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

• Type: Technical task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.21, 1.2.6, 1.3.6
• Fix Version/s: 1.0.22, 1.2.7, 1.3.7, 1.4
• Component/s: rdbmk
• Assignee: Julian Reschke
• Reporter: Julian Reschke
• Created: 24/Sep/15 10:20
• Updated: 02/Mar/16 14:23
• Resolved: 24/Sep/15 11:34

Description

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.