[OAK-1617] Automatically convert "or" queries to "union" for SQL-2

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.3.9, 1.4
• Component/s: query
• Assignee: Davide Giannella
• Reporter: Thomas Mueller
• Created: 26/Mar/14 12:32
• Updated: 08/Oct/19 15:22
• Resolved: 21/Oct/15 15:19

Description

XPath queries that contain "or" conditions are automatically converted to "union" SQL-2 queries. However, SQL-2 queries that contain "or" conditions are not (yet).

Issue Links

• blocks: OAK-955 Query: Filter doesn't contain fulltext constraints from joins
• is related to: OAK-3437 Regression in org.apache.jackrabbit.core.query.JoinTest#testJoinWithOR5 when enabling OAK-1617
• is related to: OAK-2660 Wrong result when using multiple OR conditions, with a Lucene full-text index
• is related to: OAK-904 Query: support "union" and "union all"
• is required by: OAK-3622 Expose sql2optimisation prop name as static final
• is required by: OAK-3647 enable OAK-1617 by default in trunk
• relates to: OAK-2539 SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
• relates to: OAK-4681 Automatically convert *all* "or" queries to "union" for SQL-2
• relates to: OAK-1965 Support for constraints like: foo = 'X' OR bar = 'Y'