You are viewing a plain text version of this content. The canonical link for it is here.

Posted to oak-issues@jackrabbit.apache.org by "Thomas Mueller (JIRA)" <ji...@apache.org> on 2016/09/08 08:50:20 UTC

[jira] [Created] (OAK-4776) Query engine: "like" conditions with only escaped wildcards

Thomas Mueller created OAK-4776:
-----------------------------------

             Summary: Query engine: "like" conditions with only escaped wildcards
                 Key: OAK-4776
                 URL: https://issues.apache.org/jira/browse/OAK-4776
             Project: Jackrabbit Oak
          Issue Type: Bug
          Components: query
            Reporter: Thomas Mueller
            Assignee: Thomas Mueller
             Fix For: 1.6


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)