[jira] [Comment Edited] (OAK-8845) Function-based indexing don't support ordering

["Julian Reschke (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-8845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17027612#comment-17027612 ] 

Julian Reschke edited comment on OAK-8845 at 8/30/23 10:46 AM:
---------------------------------------------------------------

trunk: (1.24.0) [90b5033825|https://github.com/apache/jackrabbit-oak/commit/90b5033825c47a0f4b9f64bb58dcd741d5e8681f] [7605ca90db|https://github.com/apache/jackrabbit-oak/commit/7605ca90dba9b4b170387d66363a5d8d7dbd5232]
1.22: (1.22.1) [62bc28edfa|https://github.com/apache/jackrabbit-oak/commit/62bc28edfaf841267a8d7d34d2e9386d02e262c5]



was (Author: reschke):
trunk: (1.24.0) [r1873070|http://svn.apache.org/r1873070] [r1873010|http://svn.apache.org/r1873010]
1.22: [r1873427|http://svn.apache.org/r1873427]


> Function-based indexing don't support ordering
> ----------------------------------------------
>
>                 Key: OAK-8845
>                 URL: https://issues.apache.org/jira/browse/OAK-8845
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: core, lucene, search, solr
>            Reporter: Nitin Gupta
>            Assignee: Nitin Gupta
>            Priority: Major
>             Fix For: 1.24.0, 1.22.1
>
>         Attachments: OAK-8845_1.patch
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)