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

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows
Дата
Msg-id CAH2-Wz=dN99ptML=DYnNt+byRBA8cnbHiHh=Ei7a0NPRQ89CYw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15285: Query used index over field with ICU collation insome cases wrongly return 0 rows  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
Ответы 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 Fri, Jun 12, 2020 at 3:43 PM Jehan-Guillaume de Rorthais
<jgdr@dalibo.com> wrote:
> Please, find in attachment the second version of the patch, with a
> regression test.

Is it possible to fix this by making the existing
HAVE_UCOL_STRCOLLUTF8 test more conservative about ICU version? IOW,
by making it only use ucol_strcollUTF8() on versions that are known to
not be affected by this bug?

This related ICU bug describes an issue affecting only versions 53/54:

https://unicode-org.atlassian.net/browse/ICU-11388

Why not just broaden the existing HAVE_UCOL_STRCOLLUTF8 workaround to
recognize that the related functionality is broken on my versions of
ICU than initially suspected?

-- 
Peter Geoghegan



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: posgres 12 bug (partitioned table)
Следующее
От: Amit Langote
Дата:
Сообщение: Re: posgres 12 bug (partitioned table)