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

Query engine: "like" conditions with only escaped wildcards

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.5.10, 1.6.0
    • query
    • None

    Description

      If a query contains "like" conditions with escaped wildcards, but without unescaped wildcards, then the result does not include all rows in some cases. The reason is that such conditions are converted to "=", but the escaped wildcards are not unescaped. For example, the condition "[prop] like '10%'" is converted to "[prop] = '10%'" instead of "[prop] = '10%'". If there is an index for that property, the expected result is not found.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment