Subject: Re: BUG #15285: Query used index over field with ICU collation in
 some cases wrongly return 0 rows
To: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>,
 pgsql-bugs@lists.postgresql.org
References: <20200903105727.064665ce@firost>
 <c00a63d3-f9c3-4222-a659-637232523b30@manitou-mail.org>
 <20200907152739.0fd6a12a@firost>
Cc: Daniel Verite <daniel@manitou-mail.org>,
 Thomas Munro <thomas.munro@enterprisedb.com>, Peter Geoghegan <pg@bowt.ie>,
 Tom Lane <tgl@sss.pgh.pa.us>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <995dfda3-344c-8c1a-2397-1bdf54dcbb4f@2ndquadrant.com>
Date: Tue, 8 Sep 2020 16:36:23 +0200
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <20200907152739.0fd6a12a@firost>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

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?

> What about adding it as a "known bug"/"will not fix" in
> https://wiki.postgresql.org/wiki/Todo and link it from the doc in a note bloc? I
> strongly feel most user do not know where to find such list of bugs in
> PostgreSQL ecosystem.

If you feel more users will make use of the Todo list in the wiki, feel 
free to add something there.

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