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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows
Дата
Msg-id 0df88ec9-90c6-54cb-ca63-7aafa5903b0c@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows  ("Daniel Verite" <daniel@manitou-mail.org>)
Ответы Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
Список pgsql-bugs
On 2020-09-03 09:41, Daniel Verite wrote:
>     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.

In this case I'm tempted to just leave it alone and write it off as a 
bug in ICU.  We could potentially inspect the collator object at CREATE 
COLLATION time and issues warnings if we find something we know to be buggy.

I don't think we want to make our code uglier and slower for normal uses 
to work around a bug in some niche feature in ICU.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Vibhor Mark Steele
Дата:
Сообщение: Download page of Postgres not working
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16606: V 4.25: unable to drop database