Chetan Mehrotra created OAK-2338:
------------------------------------
Summary: LuceneIndex should support queries involving joins
Key: OAK-2338
URL: https://issues.apache.org/jira/browse/OAK-2338
Project: Jackrabbit Oak
Issue Type: Improvement
Components: oak-lucene
Reporter: Chetan Mehrotra
Assignee: Chetan Mehrotra
Priority: Minor
Fix For: 1.2
Following testcase fail for newer {{LucenePropertyIndex}} as it does not know
how to handle joins.
{noformat}
testMultiValuedReferenceJoin(org.apache.jackrabbit.core.query.JoinTest): No
plan found for filter [Filter(query=SELECT a.*, b.* FROM [nt:unstructured] AS a
INNER JOIN [nt:unstructured] AS b ON a.[jcr:uuid] = b.testref, path=*)] while
using definition [IndexDefinition : /oak:index/luceneGlobal] and testMode is
found to be enabled
testJoinWithOR(org.apache.jackrabbit.core.query.JoinTest): No plan found for
filter [Filter(query=SELECT a.*, b.* FROM [nt:unstructured] AS a INNER JOIN
[nt:unstructured] AS b ON a.[jcr:uuid] = b.testref WHERE a.[jcr:primaryType] IS
NOT NULL OR b.[jcr:primaryType] IS NOT NULL, path=*)] while using definition
[IndexDefinition : /oak:index/luceneGlobal] and testMode is found to be enabled
testJoinWithOR2(org.apache.jackrabbit.core.query.JoinTest): No plan found for
filter [Filter(query=SELECT a.* FROM [nt:unstructured] AS a INNER JOIN
[nt:unstructured] AS b ON ISCHILDNODE(b, a) WHERE a.[p] = 'abc' OR b.[p] =
'abc' , path=*)] while using definition [IndexDefinition :
/oak:index/luceneGlobal] and testMode is found to be enabled
testJoinWithOR3(org.apache.jackrabbit.core.query.JoinTest): No plan found for
filter [Filter(query=SELECT a.* FROM [nt:unstructured] AS a INNER JOIN
[nt:unstructured] AS b ON ISCHILDNODE(b, a) WHERE ( CONTAINS(b.*, 'abc' )
OR CONTAINS(a.*, 'abc') ) AND NAME(b) = 'p2n2' , path=*)] while using
definition [IndexDefinition : /oak:index/luceneGlobal] and testMode is found to
be enabled
testOuterJoin(org.apache.jackrabbit.core.query.SQL2OuterJoinTest): No plan
found for filter [Filter(query= Select * from [test:SamplePage] as page left
outer join [test:SampleContent] as content on ISDESCENDANTNODE(content,page),
path=*)] while using definition [IndexDefinition : /oak:index/luceneGlobal] and
testMode is found to be enabled
testLogicalExpression(org.apache.jackrabbit.core.query.SimpleQueryTest): No
plan found for filter [Filter(query=SELECT * FROM nt:unstructured WHERE a=1 and
b=2 or c=3, path=*)] while using definition [IndexDefinition :
/oak:index/luceneGlobal] and testMode is found to be enabled
testOuterJoinMissingNode(org.apache.jackrabbit.core.query.SQL2OuterJoinTest):
No plan found for filter [Filter(query= Select * from [test:SamplePage] as page
left outer join [test:SampleContent] as content on
ISDESCENDANTNODE(content,page), path=*)] while using definition
[IndexDefinition : /oak:index/luceneGlobal] and testMode is found to be enabled
testOuterJoinExtraNode(org.apache.jackrabbit.core.query.SQL2OuterJoinTest):
No plan found for filter [Filter(query= Select * from [test:SamplePage] as page
left outer join [test:SampleContent] as content on
ISDESCENDANTNODE(content,page), path=*)] while using definition
[IndexDefinition : /oak:index/luceneGlobal] and testMode is found to be enabled
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
