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 Eisentraut" <peter(dot)eisentraut(at)2ndquadrant(dot)com>,"Thomas Munro" <thomas(dot)munro(at)enterprisedb(dot)com>,"Peter Geoghegan" <pg(at)bowt(dot)ie>,"Роман Литовченко" <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-09-03 07:41:51
Message-ID: 8b6f61c4-eb21-484c-bdc6-e4b8e9f3ee62@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jehan-Guillaume de Rorthais wrote:

> Maybe Daniel has some more experience feedback with other customizations

No, I've just tried various other reorderings, and didn't find any other that
seems to have the same bug as latn-digit.
My tests consisted of indexing a large corpus of text and running the
index through amcheck.

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Vibhor Mark Steele 2020-09-03 07:48:17 Download page of Postgres not working
Previous Message Kyotaro Horiguchi 2020-09-03 03:22:25 Re: BUG #16605: PostgreSQL recovery startup process waiting and blocking to application queries