jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe Satriani (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (JCR-3159) LOWER operand with nested LOCALNAME operand not work with SQL2
Date Sat, 26 Nov 2011 16:23:39 GMT

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

Joe Satriani updated JCR-3159:

    Component/s: jackrabbit-core
> LOWER operand with nested LOCALNAME operand not work with SQL2
> --------------------------------------------------------------
>                 Key: JCR-3159
>                 URL: https://issues.apache.org/jira/browse/JCR-3159
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: jackrabbit-core, JCR 2.0
>    Affects Versions: 2.2.8
>         Environment: Java 6
>            Reporter: Joe Satriani
> Below query was running successful using Query.SQL languange:
> SELECT * FROM nt:file WHERE (CONTAINS(*, 'Jon') OR  LOWER(fn:name()) LIKE '%jon%') AND
jcr:path LIKE '/Resources/%' ORDER BY jcr:score()
> But equivalent next query in Query.JCR_SQL2 will fail with exception UnsupportedRepositoryOperationException():
> SELECT * FROM [nt:file] WHERE (CONTAINS([nt:file].*, 'Jon') OR  LOWER(LOCALNAME()) LIKE
> From my investigation seems LOWER function will not work with nested function LOCALNAME.
According to section "6.7.32 LowerCase" JCR 2.0 Specs, LOWER operand able to work on DynamicOperand

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message