From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: Thomas Munro <thomas.munro@enterprisedb.com>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: Роман Литовченко <roman.lytovchenko@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows
Date: Wed, 2 Sep 2020 14:06:18 +0200
Message-ID: <4ea84116-4380-b12f-dcdf-7f2977ab2859@2ndquadrant.com> (raw)
In-Reply-To: <20200610002933.6a6d482b@firost>
References: <153201618542.1404.3611626898935613264@wrigleys.postgresql.org>
<CAH2-Wz=TGN_03qBmqgFXVhw6Kbfys-EBz4MJunzRq+RB5gL7WA@mail.gmail.com>
<CAH2-Wzkiue6PQzneBJsuDnYdUVMa5jnevVJXXkV3hR0oboOSbQ@mail.gmail.com>
<CAEepm=1-f3OuO_zA83C0x8dLFqMA+Q=RGUkyMRp4WXxjSrvbww@mail.gmail.com>
<20200610002933.6a6d482b@firost>
On 2020-06-10 00:29, Jehan-Guillaume de Rorthais wrote:
> In the meantime, I've been working on various workarounds. The only one I found
> is to use "fr-u-kr-latn-digit-kn" instead of "fr-u-kr-latn-digit".
> Unfortunately, the two collations are not equivalent, but I believe it might be
> useful in many case.
What precisely is broken in the ICU library? All the examples so far
refer to kr-latn-digit. Are all reorderings broken, or something
specifically related to latn and/or digit? Are any collation
customizations other than reorderings affected?
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, jgdr@dalibo.com, thomas.munro@enterprisedb.com, pg@bowt.ie, roman.lytovchenko@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows
In-Reply-To: <4ea84116-4380-b12f-dcdf-7f2977ab2859@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox