Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-4681

Automatically convert *all* "or" queries to "union" for SQL-2

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.13, 1.6.0
    • Component/s: query
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                thomasm Thomas Mueller
                Reporter:
                thomasm Thomas Mueller
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: