[
https://issues.apache.org/jira/browse/OAK-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14227533#comment-14227533
]
Chetan Mehrotra commented on OAK-1693:
--------------------------------------
Done in branch with http://svn.apache.org/r1642087
> "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, 1.0.9
>
>
> 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)
