Details
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()).
Attachments
Attachments
Issue Links
- is related to
-
OAK-8166 Index definition with orderable property definitions with and without functions breaks index
- Closed
-
OAK-6905 Query engine: support coalesce function as in-built method
- Closed
-
OAK-9625 Support ordered index for first value of a multi-valued property, node name, and path
- Closed
- is required by
-
OAK-6905 Query engine: support coalesce function as in-built method
- Closed
- relates to
-
OAK-9388 QueryImply#canSortByIndex() explicitly returns false for function based indexes though it's actually supported.
- Resolved
length(property) = 10 can be supported as well. Also, other comparison types, such as upper(property) > 'abc', length(property) < 10.
In theory, combined functions can be supported (upper(lower(property)), but the grammar doesn't support that, and such combinations rarely make sense. The condition length(name()) = 10 is not supported by the grammar.