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

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Daniel Verite <daniel(at)manitou-mail(dot)org>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows
Date: 2020-09-10 13:45:57
Message-ID: ac1b7620-cc8e-fc7e-59d3-2eec61042107@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2020-09-09 18:20, Jehan-Guillaume de Rorthais wrote:
> On Tue, 8 Sep 2020 16:36:23 +0200
> Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
>
>> On 2020-09-07 15:27, Jehan-Guillaume de Rorthais wrote:
>>> Please, find a patch in attachment. It removes the buggy collation from doc
>>> and adapt existing ones to keep an example of combination of rules.
>>
>> I agree with this patch in principle. But perhaps we could keep another
>> reordering example, maybe latin/greek?
>
> Please, find in attachment a patch implementing your suggestion.

Committed and backpatched.

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Steiner 2020-09-10 14:30:54 Re: BUG #15858: could not stat file - over 4GB
Previous Message PG Bug reporting form 2020-09-10 08:45:19 BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain