[
https://issues.apache.org/jira/browse/OAK-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas Mueller updated OAK-2427:
--------------------------------
Description:
The problem is that the comment is not properly escaped (a C-style comment), so
that "*/" in the XPath query accidentally ends the comment in the SQL-2 query.
The following query can't be converted to SQL-2, because it contains "*/":
{noformat}
/jcr:root/etc//*[@type = 'product'
and ((@size = 'M' or */@size= 'M' or */*/@size = 'M'
or */*/*/@size = 'M' or */*/*/*/@size = 'M' or */*/*/*/*/@size = 'M'))]
{noformat}
I think this was introduced by OAK-2354
http://svn.apache.org/viewvc?view=revision&revision=1645616
was:
The problem is that the comment is not properly escaped (a C-style comment), so
that "*/" in the XPath query accidentally ends the comment in the SQL-2 query.
The following query can't be converted to SQL-2, because it contains "*/":
{noformat}
/jcr:root/etc//*[@type = 'product'
and ((@size = 'M' or */@size= 'M' or */*/@size = 'M'
or */*/*/@size = 'M' or */*/*/*/@size = 'M' or */*/*/*/*/@size = 'M'))]
{noformat}
For the trunk (1.1), this was fixed in OAK-2354
http://svn.apache.org/viewvc?view=revision&revision=1645616
The easiest solution might be to backport the changes in OAK-2354 to the 1.0
branch.
> XPath to SQL-2 conversion fails due to escaping error
> -----------------------------------------------------
>
> Key: OAK-2427
> URL: https://issues.apache.org/jira/browse/OAK-2427
> Project: Jackrabbit Oak
> Issue Type: Bug
> Components: query
> Affects Versions: 1.1.4
> Reporter: Thomas Mueller
> Assignee: Thomas Mueller
> Fix For: 1.1.6
>
>
> The problem is that the comment is not properly escaped (a C-style comment),
> so that "*/" in the XPath query accidentally ends the comment in the SQL-2
> query.
> The following query can't be converted to SQL-2, because it contains "*/":
> {noformat}
> /jcr:root/etc//*[@type = 'product'
> and ((@size = 'M' or */@size= 'M' or */*/@size = 'M'
> or */*/*/@size = 'M' or */*/*/*/@size = 'M' or */*/*/*/*/@size = 'M'))]
> {noformat}
> I think this was introduced by OAK-2354
> http://svn.apache.org/viewvc?view=revision&revision=1645616
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
