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

Warn traversal queries: false positives for joins and SQL-2 queries using "or"

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.6.1, 1.8.0
    • query
    • None

    Description

      The following query logs that the query doesn't use an index:

      /jcr:root/content//*/jcr:content[@jcr:uuid = '03b6fd98-e5f1-4674-9bce-d02c9b17cecd']
      

      The query correctly uses the uuid index to locate the node, and then traverses the parent nodes to verify the path constraint matches. So, strictly speaking this is traversal, but only traversal to the parent nodes, and not traversal down the tree. Traversal to the parent nodes is not problematic, so no message should be logged.

      A workaround it to change the query by appending option(traversal ok).

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: