You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Rachit Kumar (JIRA)" <ji...@apache.org> on 2016/11/09 09:04:58 UTC

[jira] [Created] (JCR-4055) Have AuthorizableQueryManager Support Named search with ignorecase

Rachit Kumar created JCR-4055:
---------------------------------

             Summary:  Have AuthorizableQueryManager Support Named search with ignorecase
                 Key: JCR-4055
                 URL: https://issues.apache.org/jira/browse/JCR-4055
             Project: Jackrabbit Content Repository
          Issue Type: Improvement
          Components: jackrabbit-jcr-commons
    Affects Versions: 2.8
            Reporter: Rachit Kumar
            Assignee: angela
             Fix For: 2.9.1


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)