Re: BUG #16570: Collation not working

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
Cc: "Arnaud Perrier" <arnaud(dot)perrier(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16570: Collation not working
Date: 2020-08-05 20:31:42
Message-ID: 20200805223142.5789792d@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On Wed, 05 Aug 2020 16:49:49 +0200
"Daniel Verite" <daniel(at)manitou-mail(dot)org> wrote:
[...]
> I'm wondering whether there is a discrepancy between the binary
> sort keys and results of direct comparisons by ucol_strcoll()
> for this collation.
[...]

This bug has been discussed back in 2018 and a customer hit it few weeks ago
as well. Here is my last analysis, various link to histories, a workaround and a
even an humble patch proposal to discuss:

https://www.postgresql.org/message-id/flat/20200610002933.6a6d482b%40firost#acba071ed158e0c03ea9a106d9b0fd6d

I even sent a patch to the ICU community to add a regression test exposing the
bug, but I had no answer.

Hopefully the workaround is good enough for you.

Regards,

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-08-05 21:30:59 Re: BUG #16570: Collation not working
Previous Message Jan Kort 2020-08-05 16:39:20 Re: Index not used without explicit typecast