[
https://issues.apache.org/jira/browse/OAK-2660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas Mueller updated OAK-2660:
--------------------------------
Description:
The following query returns the wrong result:
{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}
There is a Lucene property index for the following properties: {{name, surname,
description, added}}.
was:
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.
> Wrong result when using multiple OR conditions, with a Lucene full-text index
> -----------------------------------------------------------------------------
>
> 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.3.8
>
>
> The following query returns the wrong result:
> {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}
> There is a Lucene property index for the following properties: {{name,
> surname, description, added}}.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
