Thomas Mueller created OAK-4681:
-----------------------------------

             Summary: Automatically convert *all* "or" queries to "union" for 
SQL-2
                 Key: OAK-4681
                 URL: https://issues.apache.org/jira/browse/OAK-4681
             Project: Jackrabbit Oak
          Issue Type: New Feature
            Reporter: Thomas Mueller


Currently, in OAK-1617, simple SQL-2 queries that contain "or" are converted to 
"union" if the cost is lower. However, more complex queries are not converted, 
see AndImpl.java, convertToUnion(), "in this case prefer to be conservative and 
don't optimize. This could happen when for example: WHERE (a OR b) AND (c OR 
d)." 

It is implemented for XPath, and works fine there, so I think it is reasonable 
to do that for SQL-2 as well for trunk.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to