Details
-
Improvement
-
Status: Open
-
Trivial
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Right now, all XPath queries that contain "or" of the form "@a=1 or @b=2" are converted to SQL-2 "union". In some cases, this is a problem, specially in combination with "order by @jcr:score desc".
Now that SQL-2 "or" conditions can be converted to union (depending if union has a lower cost), it is no longer strictly needed to do the union conversion in the XPath conversion. Or at least emit different SQL-2 queries and take the one with the lowest cost.