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

Query engine: "like" conditions with only escaped wildcards

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.10, 1.6.0
    • Component/s: query
    • Labels:
      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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: