[jira] [Created] (OAK-830) XPathToSQL2Converter fails to wrap or clauses

["Alex Parvulescu (JIRA)" <ji...@apache.org>]

Alex Parvulescu created OAK-830:
-----------------------------------

             Summary: XPathToSQL2Converter fails to wrap or clauses
                 Key: OAK-830
                 URL: https://issues.apache.org/jira/browse/OAK-830
             Project: Jackrabbit Oak
          Issue Type: Bug
          Components: core
            Reporter: Alex Parvulescu
            Assignee: Alex Parvulescu


There are some xpath queries that contain some 'or' clauses which are not properly converted to sql2:

For example
{code}
/jcr:root/home//test/* [@type='t1' or @type='t2' or @type='t3']
{code}

turns into 
{code}
select b.[jcr:path] as [jcr:path], b.[jcr:score] as [jcr:score], b.* from [nt:base] as a inner join [nt:base] as b on ischildnode(b, a) where (name(a) = 'test' and isdescendantnode(a, '/home')) and b.[type] = 't1' or b.[type] = 't2') or b.[type] = 't3' /* xpath: /jcr:root/home//test/* [@type='t1' or @type='t2' or @type='t3'] */
{code}

Notice how the 3 'or's should be wrapped into parenthesis, otherwise the resulting query is simply wrong.




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