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

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.3.9, 1.4
    • query
    • None

    Description

      XPath queries that contain "or" conditions are automatically converted to "union" SQL-2 queries. However, SQL-2 queries that contain "or" conditions are not (yet).

      Attachments

        1. OAK-1617-3.patch
          98 kB
          Davide Giannella
        2. OAK-1617-2.patch
          77 kB
          Davide Giannella
        3. OAK-1617-1.patch
          61 kB
          Davide Giannella

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. OAK-955 Query: Filter doesn't contain fulltext constraints from joins

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

          Bug - A problem which impairs or prevents the functions of the product. OAK-3437 Regression in org.apache.jackrabbit.core.query.JoinTest#testJoinWithOR5 when enabling OAK-1617

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. OAK-2660 Wrong result when using multiple OR conditions, with a Lucene full-text index

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. OAK-904 Query: support "union" and "union all"

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

          Improvement - An improvement or enhancement to an existing feature or task. OAK-3622 Expose sql2optimisation prop name as static final

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. OAK-3647 enable OAK-1617 by default in trunk

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. OAK-2539 SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. OAK-4681 Automatically convert *all* "or" queries to "union" for SQL-2

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. OAK-1965 Support for constraints like: foo = 'X' OR bar = 'Y'

          • Major - Major loss of function.
          • Closed

          Activity

            People

              edivad Davide Giannella
              thomasm Thomas Mueller
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: