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

QueryEngine 'like' interpretation error for paths

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.6
    • core
    • None

    Description

      This is not a parsing error, it affects the Query string -> Query transformation mechanism.
      Currently there is no 'like' support in the FilterImpl [0] and the conditions get turned into invalid string range conditions [1].

      It would appear that
      {{ WHERE jcr:path LIKE 'testroot/%'}}
      gets transformed into the following query filter condition:
      {{ jcr:path has to be between /testroot/ and /testroot0 inclusive }}
      which has no way of working
      (except for the internal LikePattern implementation which apparently knows all the tricks).

      The failing test case is FulltextQueryTest#testFulltextSimpleSQL1

      [0] http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-core/src/main/java/org/apache/jackrabbit/oak/query/index/FilterImpl.java?view=markup#l220
      [1] http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-core/src/main/java/org/apache/jackrabbit/oak/query/ast/ComparisonImpl.java?view=markup#l131

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: