[ 
https://issues.apache.org/jira/browse/OAK-2282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14241065#comment-14241065
 ] 

Chetan Mehrotra edited comment on OAK-2282 at 12/10/14 1:25 PM:
----------------------------------------------------------------

Current test failure stands at 13. With following 3 broad categories

*A - Queries using Joins*

IndexPlanner and LucenePropertyIndex do not know how to handle such queries. 
(OAK-2338)

{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}

*B - jcr:path based queries*

Following queries are not handled because Lucene index only looks for explicit 
path restrictions and does not handle {{jcr:path}} based property restrictions 
(OAK-2339)

{noformat}
  testOrderByScore(org.apache.jackrabbit.core.query.OrderByTest): No plan found 
for filter [Filter(query=SELECT value FROM nt:unstructured WHERE jcr:path LIKE 
'/testroot/%' ORDER BY jcr:score, value, path=*)] while using definition 
[IndexDefinition : /oak:index/luceneGlobal] and testMode is found to be enabled
  testOrderByMVP(org.apache.jackrabbit.core.query.OrderByTest): No plan found 
for filter [Filter(query=SELECT value FROM nt:unstructured WHERE jcr:path LIKE 
'/testroot/%' ORDER BY text, path=*)] while using definition [IndexDefinition : 
/oak:index/luceneGlobal] and testMode is found to be enabled
  testSimpleQuerySQL4(org.apache.jackrabbit.core.query.SimpleQueryTest): No 
plan found for filter [Filter(query=SELECT * FROM nt:unstructured WHERE 
jcr:path LIKE '/testroot/%', path=*)] while using definition [IndexDefinition : 
/oak:index/luceneGlobal] and testMode is found to be enabled
  testIsNull(org.apache.jackrabbit.core.query.SimpleQueryTest): No plan found 
for filter [Filter(query=SELECT * FROM nt:unstructured WHERE mytext is null and 
jcr:path LIKE '/testroot/%', path=*)] while using definition [IndexDefinition : 
/oak:index/luceneGlobal] and testMode is found to be enabled
{noformat}

*C - NodeType based query*

Following query is purely a nodeType based query and Lucene index currently 
does not return a MatchAllDocsQuery in any case (OAK-2340)

{noformat}
  testSQL2SelectColums(org.apache.jackrabbit.core.query.SQL2QueryResultTest): 
No plan found for filter [Filter(query=select * from [test:RTypeTest], path=*)] 
while using definition [IndexDefinition : /oak:index/luceneGlobal] and testMode 
is found to be enabled
{noformat}

After discussing with [~alex.parvulescu] we came to conclusion that we create 3 
issue for above 3 category and mark those test to be ignored and enable all the 
test to run against the newer index and later on fix those issues


was (Author: chetanm):
Current test failure stands at 13. With following 3 broad categories

*A - Queries using Joins*

IndexPlanner and LucenePropertyIndex do not know how to handle such queries.

{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}

*B - jcr:path based queries*

Following queries are not handled because Lucene index only looks for explicit 
path restrictions and does not handle {{jcr:path}} based property restrictions

{noformat}
  testOrderByScore(org.apache.jackrabbit.core.query.OrderByTest): No plan found 
for filter [Filter(query=SELECT value FROM nt:unstructured WHERE jcr:path LIKE 
'/testroot/%' ORDER BY jcr:score, value, path=*)] while using definition 
[IndexDefinition : /oak:index/luceneGlobal] and testMode is found to be enabled
  testOrderByMVP(org.apache.jackrabbit.core.query.OrderByTest): No plan found 
for filter [Filter(query=SELECT value FROM nt:unstructured WHERE jcr:path LIKE 
'/testroot/%' ORDER BY text, path=*)] while using definition [IndexDefinition : 
/oak:index/luceneGlobal] and testMode is found to be enabled
  testSimpleQuerySQL4(org.apache.jackrabbit.core.query.SimpleQueryTest): No 
plan found for filter [Filter(query=SELECT * FROM nt:unstructured WHERE 
jcr:path LIKE '/testroot/%', path=*)] while using definition [IndexDefinition : 
/oak:index/luceneGlobal] and testMode is found to be enabled
  testIsNull(org.apache.jackrabbit.core.query.SimpleQueryTest): No plan found 
for filter [Filter(query=SELECT * FROM nt:unstructured WHERE mytext is null and 
jcr:path LIKE '/testroot/%', path=*)] while using definition [IndexDefinition : 
/oak:index/luceneGlobal] and testMode is found to be enabled
{noformat}

*C - NodeType based query*

Following query is purely a nodeType based query and Lucene index currently 
does not return a MatchAllDocsQuery in any case

{noformat}
  testSQL2SelectColums(org.apache.jackrabbit.core.query.SQL2QueryResultTest): 
No plan found for filter [Filter(query=select * from [test:RTypeTest], path=*)] 
while using definition [IndexDefinition : /oak:index/luceneGlobal] and testMode 
is found to be enabled
{noformat}

After discussing with [~alex.parvulescu] we came to conclusion that we create 3 
issue for above 3 category and mark those test to be ignored and enable all the 
test to run against the newer index and later on fix those issues

> Make current testcases pass with new index implementation
> ---------------------------------------------------------
>
>                 Key: OAK-2282
>                 URL: https://issues.apache.org/jira/browse/OAK-2282
>             Project: Jackrabbit Oak
>          Issue Type: Sub-task
>          Components: oak-lucene
>            Reporter: Chetan Mehrotra
>            Assignee: Chetan Mehrotra
>             Fix For: 1.2
>
>
> Current testcases in oak-lucene should be run against the newer index and all 
> such testcases should pass



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to