Feedback-ID: id4a34324:Fastmail
Date: Sat, 11 Mar 2023 14:05:15 -0800
From: Andres Freund <andres@anarazel.de>
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
Message-ID: <20230311220515.x45vln6ogzyd57p7@awork3.anarazel.de>
References: <E1pac4x-002qVH-Ce@gemulon.postgresql.org>
 <582e43d0a814e09c62ea662dd851f43bfc137a16.camel@j-davis.com>
 <c05d7d71-e869-f6ae-b83c-2d5cab0a0dc4@dunslane.net>
 <231acf388c37597a9f0f8a3af9a899df99c28e1d.camel@j-davis.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <231acf388c37597a9f0f8a3af9a899df99c28e1d.camel@j-davis.com>
Archived-At: 
 <https://www.postgresql.org/message-id/20230311220515.x45vln6ogzyd57p7%40awork3.anarazel.de>
Precedence: bulk

Hi,

On 2023-03-11 10:20:33 -0800, Jeff Davis wrote:
> 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.

On one my hacking-on-meson-build trees ([1]) I saw the problem in CI, on
centos-7. In case you want a way to reproduce the issue. You can merge that
tree into a throway tree, none of the changes should affect your work. You can
even log into the machine if it's on your repo ("re-run with terminal
access"), if you want to figure out the details.

https://cirrus-ci.com/task/6015098225950720
https://api.cirrus-ci.com/v1/artifact/task/6015098225950720/testrun/build/testrun/regress/regress/regression.diffs

Centos 8, fedora rawhide, suse tumbleweed are all OK though.

Greetings,

Andres Freund

[1] https://github.com/anarazel/postgres/tree/meson-ci-debug