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

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

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.5.13, 1.6.0
    • query
    • 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

          is related to

          Bug - A problem which impairs or prevents the functions of the product. OAK-5120 Automatically convert *all* "or" queries to "union" for SQL-2, take 2

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. OAK-1617 Automatically convert "or" queries to "union" for SQL-2

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: