From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Davis <pgsql@j-davis.com>
cc: Andrew Dunstan <andrew@dunslane.net>,
        Peter Eisentraut <peter@eisentraut.org>,
        pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add standard collation UNICODE
In-reply-to: <231acf388c37597a9f0f8a3af9a899df99c28e1d.camel@j-davis.com>
References: <E1pac4x-002qVH-Ce@gemulon.postgresql.org>
 <582e43d0a814e09c62ea662dd851f43bfc137a16.camel@j-davis.com>
 <c05d7d71-e869-f6ae-b83c-2d5cab0a0dc4@dunslane.net>
 <231acf388c37597a9f0f8a3af9a899df99c28e1d.camel@j-davis.com>
Comments: In-reply-to Jeff Davis <pgsql@j-davis.com>
	message dated "Sat, 11 Mar 2023 10:20:33 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <1253025.1678567661.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sat, 11 Mar 2023 15:47:41 -0500
Message-ID: <1253026.1678567661@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1253026.1678567661%40sss.pgh.pa.us>
Precedence: bulk

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
>> =C2=A0libicu-50.2-4.0.amzn1.x86_64
>> =C2=A0libicu-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.

			regards, tom lane

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dsnapper&dt=3D=
2023-03-11%2016%3A50%3A13