From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew@dunslane.net>
cc: Jeff Davis <pgsql@j-davis.com>, Peter Eisentraut <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>
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>
 <98810acf-c2ea-ed90-2b5f-c8cfa6c1654f@dunslane.net>
Comments: In-reply-to Andrew Dunstan <andrew@dunslane.net>
	message dated "Sun, 12 Mar 2023 16:04:55 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1605452.1678651802.1@sss.pgh.pa.us>
Date: Sun, 12 Mar 2023 16:10:02 -0400
Message-ID: <1605453.1678651802@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1605453.1678651802%40sss.pgh.pa.us>
Precedence: bulk

Andrew Dunstan <andrew@dunslane.net> writes:
> On 2023-03-11 Sa 15:47, Tom Lane wrote:
>> 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.

I see topminnow is showing the symptom too, so it's now pretty clear
that this was once a common behavior.  I dug in ICU's release notes
and couldn't find anything about it, but they must've changed something
somewhen.

			regards, tom lane