[OAK-8845] Function-based indexing don't support ordering

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.24.0, 1.22.1
• Component/s: core, lucene, search, solr
• Assignee: Nitin Gupta
• Reporter: Nitin Gupta
• Created: 10/Jan/20 05:40
• Updated: 30/Aug/23 10:46
• Resolved: 24/Jan/20 05:02

Description

The documentation at http://jackrabbit.apache.org/oak/docs/query/lucene.html#function-based-indexing says "Function-based indexes can for example allow to search (or order by) the lower case version of a property."

While technically it's true, it leads to believe that "order by" uses the index efficiently. Unfortunately, it does not, as all entries are read.

Issue Links

• is duplicated by: OAK-9388 QueryImply#canSortByIndex() explicitly returns false for function based indexes though it's actually supported.
• links to: GitHub Pull Request #171