[OAK-5120] Automatically convert *all* "or" queries to "union" for SQL-2, take 2

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.14, 1.6.0
• Component/s: query
• Assignee: Thomas Mueller
• Reporter: Thomas Mueller
• Created: 16/Nov/16 17:58
• Updated: 30/Jan/17 23:20
• Resolved: 17/Nov/16 12:41

Description

OAK-4681 is trying to convert "or" SQL-2 queries to union (if that's faster). However, the following nested case is not yet converted fully to a union (one "or" is converted, but the other one is not):

select * from [nt:unstructured] as [c] 
where isdescendantnode('/tmp') 
and ([a]=1 or [b]=2) and ([c]=3 or [d]=4)

Issue Links

• relates to: OAK-4681 Automatically convert *all* "or" queries to "union" for SQL-2