Re: Inconsistent string comparison using modified ICU collations

2025-01-24 Thread Jeff Davis
On Thu, 2025-01-23 at 13:29 -0800, Jeff Davis wrote: > I had previously proposed[1] a GUC to control abbreviated keys, and > it > was rejected. Now that we've seen both a performance problem and a > bug > in the underlying dependency, perhaps we should reconsider. Users may: * trust libc strxfrm,

Re: Inconsistent string comparison using modified ICU collations

2025-01-23 Thread Daniel Verite
Oleg Tselebrovskiy wrote: > I've discovered a bug with string comparison using modified ICU > collations > Using a direct comparison and sorting values gives different results > > The easiest way to reproduce is the following: > > postgres=# create collation "en-US-u-kr-latn-dig

Re: Inconsistent string comparison using modified ICU collations

2025-01-23 Thread Jeff Davis
On Wed, 2025-01-22 at 12:03 +0300, Oleg Tselebrovskiy wrote: > In the second example of sorting values, function > varstr_abbrev_convert Thank you for the report! I had previously proposed[1] a GUC to control abbreviated keys, and it was rejected. Now that we've seen both a performance problem a

Inconsistent string comparison using modified ICU collations

2025-01-22 Thread Oleg Tselebrovskiy
Greetings, everyone! I've discovered a bug with string comparison using modified ICU collations Using a direct comparison and sorting values gives different results The easiest way to reproduce is the following: postgres=# create collation "en-US-u-kr-latn-digit-x-icu" (provider = icu, loca