[jira] [Commented] (OAK-515) PropertyIndex should be used for "[indexedProperty] is not null"

["Thomas Mueller (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13531018#comment-13531018 ] 

Thomas Mueller commented on OAK-515:
------------------------------------

Revision 1421301 illustrates the issue:

For the query
{code}
select * from [nt:base] where [jcr:uuid] is not null
{code}

the index on jcr:uuid is not used currently. However, the index is used for the query

{code}
select * from [nt:base] where [jcr:uuid] = '123'
{code}

                
> PropertyIndex should be used for "[indexedProperty] is not null"
> ----------------------------------------------------------------
>
>                 Key: OAK-515
>                 URL: https://issues.apache.org/jira/browse/OAK-515
>             Project: Jackrabbit Oak
>          Issue Type: Improvement
>          Components: query
>            Reporter: Thomas Mueller
>            Assignee: Thomas Mueller
>
> Currently, the PropertyIndex (as well as P2) are not used for queries with conditions of the type "[indexedProperty] is not null". 
> The indexes can be used, and should be used in this case. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira