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 "Alex Parvulescu (JIRA)" <ji...@apache.org> on 2013/02/13 14:36:12 UTC

[jira] [Updated] (OAK-474) Query tck test SQLJoinTest failing with ParseException

     [ https://issues.apache.org/jira/browse/OAK-474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alex Parvulescu updated OAK-474:
--------------------------------

    Description: 
The {{SQLJoinTest}} is failing with the following parsing exception [0]

As this is not failing due to some missing feature, I think the parser should be fixed.
It looks like SQL joins are not supported yet.

Query:
{code}
SELECT * FROM nt:unstructured, mix:referenceable 
WHERE nt:unstructured.jcr:path = mix:referenceable.jcr:path 
AND jcr:path LIKE '/testroot/%'
{code}

[0]
{code}
Caused by: java.text.ParseException: Query: 
SELECT * FROM nt:unstructured,(*)mix:referenceable 
WHERE nt:unstructured.jcr:path = mix:referenceable.jcr:path 
AND jcr:path LIKE '/testroot/%'; expected: <end>
	at org.apache.jackrabbit.oak.query.SQL2Parser.getSyntaxError(SQL2Parser.java:1104)
	at org.apache.jackrabbit.oak.query.SQL2Parser.parse(SQL2Parser.java:135)
{code}

  was:
The {{SQLJoinTest}} is failing with the following parsing exception [0]

As this is not failing due to some missing feature, I think the test should be fixed.

Query:
{code}
SELECT * FROM nt:unstructured, mix:referenceable 
WHERE nt:unstructured.jcr:path = mix:referenceable.jcr:path 
AND jcr:path LIKE '/testroot/%'
{code}

[0]
{code}
Caused by: java.text.ParseException: Query: 
SELECT * FROM nt:unstructured,(*)mix:referenceable 
WHERE nt:unstructured.jcr:path = mix:referenceable.jcr:path 
AND jcr:path LIKE '/testroot/%'; expected: <end>
	at org.apache.jackrabbit.oak.query.SQL2Parser.getSyntaxError(SQL2Parser.java:1104)
	at org.apache.jackrabbit.oak.query.SQL2Parser.parse(SQL2Parser.java:135)
{code}

    
> Query tck test SQLJoinTest failing with ParseException
> ------------------------------------------------------
>
>                 Key: OAK-474
>                 URL: https://issues.apache.org/jira/browse/OAK-474
>             Project: Jackrabbit Oak
>          Issue Type: Sub-task
>          Components: jcr, query
>            Reporter: Alex Parvulescu
>
> The {{SQLJoinTest}} is failing with the following parsing exception [0]
> As this is not failing due to some missing feature, I think the parser should be fixed.
> It looks like SQL joins are not supported yet.
> Query:
> {code}
> SELECT * FROM nt:unstructured, mix:referenceable 
> WHERE nt:unstructured.jcr:path = mix:referenceable.jcr:path 
> AND jcr:path LIKE '/testroot/%'
> {code}
> [0]
> {code}
> Caused by: java.text.ParseException: Query: 
> SELECT * FROM nt:unstructured,(*)mix:referenceable 
> WHERE nt:unstructured.jcr:path = mix:referenceable.jcr:path 
> AND jcr:path LIKE '/testroot/%'; expected: <end>
> 	at org.apache.jackrabbit.oak.query.SQL2Parser.getSyntaxError(SQL2Parser.java:1104)
> 	at org.apache.jackrabbit.oak.query.SQL2Parser.parse(SQL2Parser.java:135)
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira