Re: pgsql: Add standard collation UNICODE - Mailing list pgsql-committers

From Andrew Dunstan
Subject Re: pgsql: Add standard collation UNICODE
Date
Msg-id e4c2229f-939d-1c4f-dabf-c2780cb1d743@dunslane.net
Whole thread Raw
In response to Re: pgsql: Add standard collation UNICODE  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: pgsql: Add standard collation UNICODE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers


On 2023-03-12 Su 18:47, Thomas Munro wrote:
On Mon, Mar 13, 2023 at 9:10 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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.
Most odd, and a bit worrying for the multi-lib concept we were
discussing (now for 17), though not fatal if it's something like
"there was one historical screwup back in 50.whatever, but now we are
more careful", or "it was a packaging error that was fixed but old
systems that aren't getting updated don't have the fix", so not even
ICU's fault (which would fit with Jeff's observation that he can't
repro the issue by building from ICU source at the 50.2 tag, as if
what is in the package is not what was tagged?!).  It'd be nice to
understand what happened here...  What do these disagreeing systems
report for the various version meta-data (Unicode version, CLDR
version, the opaque collator version, etc)?


How would I discover that? Or if it's quicker I can give you access to one or two machines which exhibit the issue.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix failure to detect some cases of improperly-nested aggregates
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Add standard collation UNICODE