Message-ID: <cac43a3baf43cec6138dcc1d3eaf7b572b7b1f4c.camel@j-davis.com>
Subject: Re: Collation version tracking for macOS
From: Jeff Davis <pgsql@j-davis.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Jeremy Schneider <schneider@ardentperf.com>, Peter Eisentraut
 <peter.eisentraut@enterprisedb.com>, Peter Geoghegan <pg@bowt.ie>, "Nasby,
 Jim" <nasbyj@amazon.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers
 <pgsql-hackers@postgresql.org>
Date: Tue, 29 Nov 2022 16:32:52 -0800
In-Reply-To: 
 <CA+hUKGLGSnjJAniFvFi=-ZaCNSh2R1k1SrRYPpXVyjOTQbPG=g@mail.gmail.com>
References: <b37c2acd-24f4-07c9-da6e-6fec66137f69@enterprisedb.com>
	 <D9EBBA4F-C92C-4B26-AB4D-6038BC52793D@ardentperf.com>
	 <398aabd1-ad95-ba2d-d70a-dd5d90bf6e07@enterprisedb.com>
	 <CA+hUKGL36vXMfcaDq+U1ZkoSsdfFnNx7GxhGM7aYzEbKs1W0=Q@mail.gmail.com>
	 <CA+hUKGKq=iLH3bY+nK7v8b2zBCuKOk-fe0cP0it2RxNaWFVxYA@mail.gmail.com>
	 <606bd2baa6d65b38fee6eb23bba40c5da210255b.camel@j-davis.com>
	 <CA+hUKG+OSQtrRAk-bHwMJmuvqp-b-LGuxsF2PoDBVyQcT+VEAQ@mail.gmail.com>
	 <9f8e9b5a3352478d4cf7d6c0a5dd7e82496be4b6.camel@j-davis.com>
	 <CA+hUKGJxg6AbKC9RJ7r1ByVLtvVkThQV+RZO6BKVWYESPCp3Ug@mail.gmail.com>
	 <346f836208a39009c1998ed5a41c7f1a0be36911.camel@j-davis.com>
	 <CA+hUKGJhPeW3iRqO3XQB=+BTMx7O6zTCFKTfeSV9TXBtdyMqbQ@mail.gmail.com>
	 <CA+hUKGLr=9d+-k8PVv8e__TOxuq=n0SKNDpqCzbGrK5EbDyxAg@mail.gmail.com>
	 <0f7922d4f411376f420ec9139febeae4cdc748a6.camel@j-davis.com>
	 <331d8ffd-0bfa-9f5a-e1d1-23a242f44a27@ardentperf.com>
	 <CA+hUKG+g-AFta22P0NjuFTbi3jywWTqR+dyExQwu5Vr=mSeXUw@mail.gmail.com>
	 <f1c3819692354d92520d8afb46624c435e0da4d3.camel@j-davis.com>
	 <CA+hUKGLRKKd2knzx-Y=-M6acogqZZ=LwdPUwWo007or3np7wyQ@mail.gmail.com>
	 <12a7c9ddd5c44003869a114d0b5326fec27b2477.camel@j-davis.com>
	 <CA+hUKGLGSnjJAniFvFi=-ZaCNSh2R1k1SrRYPpXVyjOTQbPG=g@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4-0ubuntu1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/cac43a3baf43cec6138dcc1d3eaf7b572b7b1f4c.camel%40j-davis.com>
Precedence: bulk

On Wed, 2022-11-30 at 10:29 +1300, Thomas Munro wrote:
> On Wed, Nov 30, 2022 at 9:59 AM Jeff Davis <pgsql@j-davis.com> wrote:
> > Here's what I found for the 'ar' locale (firstminor/lastminor are
> > the
> > icu library versions, firstcollversion/lastcollversion are their
> > respective collation versions for the given locale):
> >=20
> > =C2=A0firstminor | lastminor | firstcollversion | lastcollversion
> > ------------+-----------+------------------+-----------------
> > =C2=A060.1=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | 60.3=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 | 153.80.32=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | 153.80=
.32.1
> > =C2=A064.1=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | 64.2=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 | 153.96.35=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | 153.97=
.35.8
> > =C2=A068.1=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | 68.2=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 | 153.14.38=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | 153.14=
.38.8
> > (3 rows)
>=20
> Right, this fits with what I said earlier: the third component is
> CLDR
> major, fourth component is CLDR minor except from ICU 61 on the CLDR
> minor is << 3'd (X.X.38.8 means CLDR 38.1).

What about 64.1 -> 64.2? That changed the *second* component from 96 ->
97. Are we agreed that collations can materially change in minor ICU
releases?


--=20
Jeff Davis
PostgreSQL Contributor Team - AWS