jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cédric Damioli (JIRA) <j...@apache.org>
Subject [jira] [Commented] (JCR-3443) Normalize String properties when ordering query results
Date Fri, 15 Feb 2013 10:21:14 GMT

    [ https://issues.apache.org/jira/browse/JCR-3443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13579073#comment-13579073
] 

Cédric Damioli commented on JCR-3443:
-------------------------------------

Please open another issue for this.

The problem is that Xpath and SQL1 is based on an extensible grammar : is was quite easy to
extend it to add a new function.
SQL2 is technically based on the QueryObjectModelFactory, which offer one method per function.
We then have to extend the Java API to add a new function.
We may add a JackrabbitQueryObjectModelFactory extending the JCR one with new methods...
                
> Normalize String properties when ordering query results
> -------------------------------------------------------
>
>                 Key: JCR-3443
>                 URL: https://issues.apache.org/jira/browse/JCR-3443
>             Project: Jackrabbit Content Repository
>          Issue Type: New Feature
>          Components: jackrabbit-core, query
>            Reporter: Cédric Damioli
>            Assignee: Jukka Zitting
>             Fix For: 2.5.3
>
>         Attachments: normalize.patch
>
>
> Properties containing non-ASCII characters are not well collated in query results
> There's only two allowed functions so far in XPath (fn:lower-case and fn:upper-case).
There exists the equivalent LOWER and UPPER in SQL
> I propose to add a fn:normalize (resp NORMALIZE) function giving expected results

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

Mime
View raw message