From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Peter Eisentraut <peter@eisentraut.org>
Cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add standard collation UNICODE
Date: Sun, 12 Mar 2023 16:04:55 -0400
Message-ID: <98810acf-c2ea-ed90-2b5f-c8cfa6c1654f@dunslane.net> (raw)
In-Reply-To: <1253026.1678567661@sss.pgh.pa.us>
References: <E1pac4x-002qVH-Ce@gemulon.postgresql.org>
<582e43d0a814e09c62ea662dd851f43bfc137a16.camel@j-davis.com>
<c05d7d71-e869-f6ae-b83c-2d5cab0a0dc4@dunslane.net>
<231acf388c37597a9f0f8a3af9a899df99c28e1d.camel@j-davis.com>
<1253026.1678567661@sss.pgh.pa.us>
On 2023-03-11 Sa 15:47, Tom Lane wrote:
> Jeff Davis<pgsql@j-davis.com> writes:
>> On Sat, 2023-03-11 at 08:31 -0500, Andrew Dunstan wrote:
>>> It's fairly old:
>>> $ rpm -q -a | grep icu
>>> libicu-50.2-4.0.amzn1.x86_64
>>> libicu-devel-50.2-4.0.amzn1.x86_64
>> FWIW I tried ICU 50.2 (built from sources) and the root locale still
>> sorts lowercase first.
> snapper is showing this failure too [1], which makes me wonder if it's
> a locally-customizable option.
>
> In general, I see no good reason for our regression tests to be making
> assumptions about exactly how ICU's root locale behaves, so I'd suggest
> just lobotomizing this test case so it doesn't depend on upper/lower
> sort order.
>
>
Yeah, I think we've found enough cases in old still not dead distros to
make this reasonable.
cheers
andrew
--
Andrew Dunstan
EDB:https://www.enterprisedb.com
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-committers@postgresql.org
Cc: andrew@dunslane.net, tgl@sss.pgh.pa.us, pgsql@j-davis.com, peter@eisentraut.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add standard collation UNICODE
In-Reply-To: <98810acf-c2ea-ed90-2b5f-c8cfa6c1654f@dunslane.net>
* 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