[
https://issues.apache.org/jira/browse/OAK-2338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chetan Mehrotra updated OAK-2338:
---------------------------------
Fix Version/s: (was: 1.2)
> 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
>
> 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)
