You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Chetan Mehrotra (JIRA)" <ji...@apache.org> on 2015/03/15 06:38:39 UTC
[jira] [Resolved] (OAK-2338) LuceneIndex should support queries
involving joins
[ https://issues.apache.org/jira/browse/OAK-2338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chetan Mehrotra resolved OAK-2338.
----------------------------------
Resolution: Won't Fix
Resolving this as Wont Fix as supporting this would be tricky and support for join is not a design goal for now
> 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)