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 "Amit Jain (JIRA)" <ji...@apache.org> on 2014/09/30 09:42:41 UTC

[jira] [Updated] (OAK-1693) "like '%'" does not use an index

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

Amit Jain updated OAK-1693:
---------------------------
    Fix Version/s:     (was: 1.1)
                   1.1.0

> "like '%'" does not use an index
> --------------------------------
>
>                 Key: OAK-1693
>                 URL: https://issues.apache.org/jira/browse/OAK-1693
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: query
>            Reporter: Thomas Mueller
>            Assignee: Thomas Mueller
>             Fix For: 1.1.0
>
>
> Conditions of the form imply "x is not null", therefore an index on "x" could be used. However, this is not currently the case, because the "x is not null" condition is not added in the query engine:
> {noformat}
> select * from [nt:base] where [jcr:uuid] like '%'
> {noformat}
> A workaround is to use an explicit "is not null" condition instead.



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