[ https://issues.apache.org/jira/browse/OAK-225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13527967#comment-13527967 ]
Thomas Mueller edited comment on OAK-225 at 12/10/12 2:52 PM: -------------------------------------------------------------- The query {code} //element(*,mix:language)[fn:lower-case(@jcr:language)='en'] //element(*,sling:Message)[@sling:message] /(@sling:key|@sling:message) {code} is now converted to the SQL-2 query {code} select b.[jcr:path] as [jcr:path], b.[jcr:score] as [jcr:score], b.[sling:key] as [sling:key], b.[sling:message] as [sling:message] from [mix:language] as a inner join [sling:Message] as b on isdescendantnode(b, a) where lower(a.[jcr:language]) = 'en' and b.[sling:message] is not null {code} was (Author: tmueller): The query {code} //element(*,mix:language)[fn:lower-case(@jcr:language)='en']//element(*,sling:Message)[@sling:message]/(@sling:key|@sling:message) {code} is now converted to the SQL-2 query {code} select b.[jcr:path] as [jcr:path], b.[jcr:score] as [jcr:score], b.[sling:key] as [sling:key], b.[sling:message] as [sling:message] from [mix:language] as a inner join [sling:Message] as b on isdescendantnode(b, a) where lower(a.[jcr:language]) = 'en' and b.[sling:message] is not null {code} > Sling I18N queries not supported by Oak > --------------------------------------- > > Key: OAK-225 > URL: https://issues.apache.org/jira/browse/OAK-225 > Project: Jackrabbit Oak > Issue Type: Bug > Components: core, query > Affects Versions: 0.3 > Reporter: Jukka Zitting > Priority: Minor > Labels: sling, xpath > > The Sling I18N component issues XPath queries like the following: > {code:none} > //element(*,mix:language)[fn:lower-case(@jcr:language)='en']//element(*,sling:Message)[@sling:message]/(@sling:key|@sling:message) > {code} > Such queries currently fail with the following exception: > {code:none} > javax.jcr.query.InvalidQueryException: java.text.ParseException: Query: > //element(*,mix:language)[fn:lower-(*)case(@jcr:language)='en']//element(*,sling:Message)[@sling:message]/(@sling:key|@sling:message); > expected: ( > at > org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:115) > at > org.apache.jackrabbit.oak.jcr.query.QueryImpl.execute(QueryImpl.java:85) > at > org.apache.sling.jcr.resource.JcrResourceUtil.query(JcrResourceUtil.java:52) > at > org.apache.sling.jcr.resource.internal.helper.jcr.JcrResourceProvider.queryResources(JcrResourceProvider.java:262) > ... 54 more > Caused by: java.text.ParseException: Query: > //element(*,mix:language)[fn:lower-(*)case(@jcr:language)='en']//element(*,sling:Message)[@sling:message]/(@sling:key|@sling:message); > expected: ( > at > org.apache.jackrabbit.oak.query.XPathToSQL2Converter.getSyntaxError(XPathToSQL2Converter.java:704) > at > org.apache.jackrabbit.oak.query.XPathToSQL2Converter.read(XPathToSQL2Converter.java:410) > at > org.apache.jackrabbit.oak.query.XPathToSQL2Converter.parseExpression(XPathToSQL2Converter.java:336) > at > org.apache.jackrabbit.oak.query.XPathToSQL2Converter.parseCondition(XPathToSQL2Converter.java:279) > at > org.apache.jackrabbit.oak.query.XPathToSQL2Converter.parseAnd(XPathToSQL2Converter.java:252) > at > org.apache.jackrabbit.oak.query.XPathToSQL2Converter.parseConstraint(XPathToSQL2Converter.java:244) > at > org.apache.jackrabbit.oak.query.XPathToSQL2Converter.convert(XPathToSQL2Converter.java:153) > at > org.apache.jackrabbit.oak.query.QueryEngineImpl.parseQuery(QueryEngineImpl.java:86) > at > org.apache.jackrabbit.oak.query.QueryEngineImpl.executeQuery(QueryEngineImpl.java:99) > at > org.apache.jackrabbit.oak.query.QueryEngineImpl.executeQuery(QueryEngineImpl.java:39) > at > org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:110) > {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