[
https://issues.apache.org/jira/browse/OAK-2660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14376056#comment-14376056
]
Davide Giannella commented on OAK-2660:
---------------------------------------
logs around the execution
{noformat}
o.a.j.oak.query.QueryEngineImpl - Parsing JCR-SQL2 statement: SELECT * FROM
[nt:unstructured] AS c WHERE ( c.[name] = 'yes' OR CONTAINS(c.[surname], 'yes')
OR CONTAINS(c.[description], 'yes') ) AND ISDESCENDANTNODE(c, '/content') ORDER
BY added DESC
o.a.jackrabbit.oak.query.QueryImpl - cost using filter Filter(query=SELECT *
FROM [nt:unstructured] AS c WHERE ( c.[name] = 'yes' OR CONTAINS(c.[surname],
'yes') OR CONTAINS(c.[description], 'yes') ) AND ISDESCENDANTNODE(c,
'/content') ORDER BY added DESC , path=/content//*)
o.a.jackrabbit.oak.query.QueryImpl - cost for aggregate lucene is Infinity
o.a.jackrabbit.oak.query.QueryImpl - cost for lucene-property is 0.002
o.a.jackrabbit.oak.query.QueryImpl - cost for traverse is 2000.0
o.a.jackrabbit.oak.query.QueryImpl - query execute SELECT * FROM
[nt:unstructured] AS c WHERE ( c.[name] = 'yes' OR CONTAINS(c.[surname], 'yes')
OR CONTAINS(c.[description], 'yes') ) AND ISDESCENDANTNODE(c, '/content') ORDER
BY added DESC
o.a.jackrabbit.oak.query.QueryImpl - query plan [nt:unstructured] as [c] /*
lucene:test-index(/oak:index/test-index) added:[* TO *] ordering:[{
propertyName : added, propertyType : UNDEFINED, order : DESCENDING }] where
isdescendantnode([c], [/content]) */
{noformat}
> wrong resultset multiple ORs, lucene index, full-text
> -----------------------------------------------------
>
> Key: OAK-2660
> URL: https://issues.apache.org/jira/browse/OAK-2660
> Project: Jackrabbit Oak
> Issue Type: Bug
> Components: query
> Affects Versions: 1.1.7
> Reporter: Davide Giannella
> Assignee: Davide Giannella
> Fix For: 1.1.8
>
>
> When executing a query like
> {code}
> SELECT *
> FROM [nt:unstructured] AS c
> WHERE ( c.[name] = 'yes'
> OR CONTAINS(c.[surname], 'yes')
> OR CONTAINS(c.[description], 'yes') )
> AND ISDESCENDANTNODE(c, '/content')
> ORDER BY added DESC
> {code}
> and a lucene property index is serving all the properties: {{name, surname,
> description, added}} the full index is returned and no extra condition is
> applied.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
