wrong sorting when using lucene fields

[eduarddrenth]

In exist-db 5.0.0, when using an xpath in the form:

...//tei:cit[ft:query(tei:quote,(),map{"fields": ("xmlid")})]/tei:quote

and sorting in the form:

           let $hits := for $o in teidict:queryText($searchin,$searchterm)
                       order by ft:field($o,"xmlid")
                       return $o

The sorting is wrong.

A complete reproducer can be found here:

https://bitbucket.org/fryske-akademy/online-dictionaries/src/field_wrong_sorting/readme.md

[eduarddrenth]

included link to source code in readme of reproducer

[dizzzz]

Hi @eduarddrenth please could you provide

1. (parts of) the actual result
2. (parts of) the expected result ?

[eduarddrenth]

I already prepared and tested a complete reproducer with readme, isn't that enough?

[dizzzz]

Hi @eduarddrenth, we ask ppl to fill in the template (as well) because it helps to make a 1st order assessment: Can I pick this up? The template really helps. For me, personally, As I need to be picky time wise [we are all volunteers!] on the work I can pick up, for this 1st order estimation I will and can not do these kind of investigations. In the end it is often 'a waste of time' as most of the time the user has different expectations on results than I have. It results in frustrations and time late on two sides. SO filling up the template helps, you and us.

[eduarddrenth]

I'll see, I already spend considerable amount of time in the reproducers, this feels a bit like administrative overhead. But it shouldn't be too hard for me to add expected and actual, so I'll find some time. A product like exist-db should be funded somehow I think, it is worth it.

[duncdrum]

A product like exist-db should be funded somehow I think, it is worth it.

working on it, more news soon(™)

[duncdrum]

https://opencollective.com/existdb

[eduarddrenth]

ok, it took me a while to reproduce, but I succeeded.

Following https://bitbucket.org/fryske-akademy/online-dictionaries/src/field_wrong_sorting/readme.md

Actual results are (starting from e on page 1):

Expected results (changed [ft:query(tei:quote,(),map{"fields": ("xmlid")})]/tei:quote into /tei:quote[ft:query(.,(),map{"fields": ("xmlid")})]):

[eduarddrenth]

I seem to remember that with a smaller testset the problem does not occur

[eduarddrenth]

https://opencollective.com/existdb

Nice, pitty paypal is only supported for non recurring

[eduarddrenth]

just tested with 5.1.1, still reproducable