[JCR-3845] Have AuthorizableQueryManager Support Specifying Sort Ignore Case Mode

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.8.3
• Fix Version/s: 2.9.1, 2.8.4
• Component/s: jackrabbit-jcr-commons
• Assignee: Angela Schreiber
• Reporter: Dominique Jäggi
• Created: 20/Jan/15 12:59
• Updated: 22/Nov/16 14:56
• Resolved: 20/Jan/15 15:52

Description

Currently the AuthorizableQueryManager hard-sets to ignore the case for any specified sort property, resulting in a query that sorts like this:

 ... order by fn:lower-case(@myProperty) 

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.