[jira] [Comment Edited] (JCR-3845) Have AuthorizableQueryManager Support Specifying Sort Ignore Case Mode

["Julian Reschke (JIRA)" <ji...@apache.org>]

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

Julian Reschke edited comment on JCR-3845 at 11/22/16 2:56 PM:
---------------------------------------------------------------

trunk: [r1653275|http://svn.apache.org/r1653275]
2.8: [r1770849|http://svn.apache.org/r1770849]



was (Author: reschke):
trunk: [r1653275|http://svn.apache.org/r1653275]


> Have AuthorizableQueryManager Support Specifying Sort Ignore Case Mode
> ----------------------------------------------------------------------
>
>                 Key: JCR-3845
>                 URL: https://issues.apache.org/jira/browse/JCR-3845
>             Project: Jackrabbit Content Repository
>          Issue Type: Improvement
>          Components: jackrabbit-jcr-commons
>    Affects Versions: 2.8.3
>            Reporter: Dominique Jäggi
>            Assignee: angela
>             Fix For: 2.9.1, 2.8.4
>
>         Attachments: JCR-3845_-_Have_AuthorizableQueryManager_Support_Specifying_Sort_Ignore_Case_Mode.patch
>
>
> Currently the _AuthorizableQueryManager_ hard-sets to ignore the case for any specified sort property, resulting in a query that sorts like this:
> {noformat} ... order by fn:lower-case(@myProperty) {noformat}
> this may lead to performance impact, as the lowercasing cannot be covered by a respective index.
> i therefore suggest to allow users of the _AuthorizableQueryManager_ to specify whether lowercasing is desired or not, as an additional flag _ignoreCase: true | false_ in the _ order | sort:_ section.
> [~anchela], kindly review attached patch.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)