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 "Julian Reschke (JIRA)" <ji...@apache.org> on 2016/11/10 09:58:58 UTC

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

     [ https://issues.apache.org/jira/browse/OAK-4776?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Reschke updated OAK-4776:
--------------------------------
    Fix Version/s: 1.6

> 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, 1.5.10
>
>
> 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)