Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Jehan-Guillaume de Rorthais" <jgdr(at)dalibo(dot)com>
Cc: "Peter Geoghegan" <pg(at)bowt(dot)ie>,"Thomas Munro" <thomas(dot)munro(at)gmail(dot)com>,"Роман Литовченко" <roman(dot)lytovchenko(at)gmail(dot)com>,"PostgreSQL mailing lists" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows
Date: 2020-08-20 11:43:22
Message-ID: 8110ca15-24c6-437f-9b87-67f1e53421e4@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jehan-Guillaume de Rorthais wrote:

> I might be missing something, but according to my tests back in
> June, the bug exists in both ucol_strcollUTF8()/ucol_strcoll() and
> is still affecting the very last version of ICU (67.1).

Yes. This what I've seen as well when investigating bug #16570
a couple weeks ago, before you pointed out it was the same bug:

https://www.postgresql.org/message-id/16570-58cc04e1a6ef3c3f%40postgresql.org

In that thread I've tried with ICU-60.2-3ubuntu but the results are identical
with 67.1.

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: https://www.manitou-mail.org
Twitter: @DanielVerite

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-08-20 11:48:48 BUG #16586: deduplicate_items=true can be configured for numeric indexes
Previous Message Jiří Fejfar 2020-08-20 05:30:45 Re: Query Tool does not show in PGADMIN 4.24