Re: Problem in 'ORDER BY' of a column using a created collation?

    Nishant Sharma wrote:

> Testing sort order for '1' & 'a' using ICU library with collation =
> 'ja-u-kr-latn-digit'
>
> With Method ucol_strcollUTF8():
> SORT ORDER ASC : '1', 'a'
>
> With Method ucol_nextSortKeyPart() (i.e transform and memcmp):
> SORT ORDER ASC : 'a', '1'

Yes, ucol_strcoll() with kr-latn-digit has been flawed for a
long time [1] and still is in the development branch of ICU.

There's a recent ticket about this [2] with a reproducer similar
to yours.


[1]
https://www.postgresql.org/message-id/flat/153201618542.1404.3611626898935613264%40wrigleys.postgresql.org
[2] https://unicode-org.atlassian.net/browse/ICU-23016


Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/