[OAK-3574] Query engine: support p=lowercase('x') and other function-based indexes

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.11, 1.6.0
• Component/s: core, lucene, query
• Assignee: Thomas Mueller
• Reporter: Thomas Mueller
• Created: 30/Oct/15 15:27
• Updated: 17/Apr/23 14:05
• Resolved: 16/Sep/16 12:03

Description

Currently, the query engine and indexes don't support function-based indexes for conditions of the form lowercase(property) = 'x'. This needs to be supported, specially for the Lucene property index.

Also important is lowercase(name()).

Issue Links

• is related to: OAK-8166 Index definition with orderable property definitions with and without functions breaks index
• is related to: OAK-6905 Query engine: support coalesce function as in-built method
• is related to: OAK-9625 Support ordered index for first value of a multi-valued property, node name, and path
• is required by: OAK-6905 Query engine: support coalesce function as in-built method
• relates to: OAK-9388 QueryImply#canSortByIndex() explicitly returns false for function based indexes though it's actually supported.