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 2014/04/08 10:23:15 UTC

[jira] [Resolved] (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 ]

Thomas Mueller resolved OAK-1693.
---------------------------------

    Resolution: Fixed

Fixed in revision 1585661 (trunk)

> "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
>
>
> 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.2#6252)