Message-ID: <f1c3819692354d92520d8afb46624c435e0da4d3.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>, Jeremy Schneider
	 <schneider@ardentperf.com>
Cc: 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 11:03:39 -0800
In-Reply-To: 
 <CA+hUKG+g-AFta22P0NjuFTbi3jywWTqR+dyExQwu5Vr=mSeXUw@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>
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/f1c3819692354d92520d8afb46624c435e0da4d3.camel%40j-davis.com>
Precedence: bulk

On Wed, 2022-11-30 at 07:18 +1300, Thomas Munro wrote:
> On Wed, Nov 30, 2022 at 7:03 AM Jeremy Schneider
> <schneider@ardentperf.com> wrote:
> > It seems to me that the collator_version field is not a good
> > version
> > identifier to use.
> >=20
> > Just taking a quick glance at the ICU home page right now, it shows
> > that
> > all of the last 5 versions of ICU have included "additions and
> > corrections" to locale data itself, including 68 to 69 where the
> > collator version did not change.
> >=20
> > Is it possible that this "collator_version" only reflects the code
> > that
> > processes collation data to do comparisons/sorts, but it does not
> > reflect updates to the locale data itself?
>=20
> I think it also includes the CLDR version for *some* locales.=C2=A0 From =
a
> quick look, that includes 'ar', 'ru', 'tr', 'zh'.=C2=A0 Jeff, would you
> mind sharing the same table for one of those?=C2=A0 Perhaps 'en' really
> does depend only on the UCA?

=3D# select * from pg_icu_collation_versions('ar') order by icu_version;
 icu_version | uca_version | collator_version                        =20
-------------+-------------+------------------                       =20
 50.2        | 6.2         | 58.0.0.50                               =20
 51.3        | 6.2         | 58.0.0.50                               =20
 52.2        | 6.2         | 58.0.0.50                               =20
 53.2        | 6.3         | 137.51.25
 54.2        | 7.0         | 137.56.26
 55.2        | 7.0         | 153.56.27.1
 56.2        | 8.0         | 153.64.28
 57.2        | 8.0         | 153.64.29
 58.3        | 9.0         | 153.72.30.3
 59.2        | 9.0         | 153.72.31.1
 60.3        | 10.0        | 153.80.32.1
 61.2        | 10.0        | 153.80.33
 62.2        | 11.0        | 153.88.33.8
 63.2        | 11.0        | 153.88.34
 64.2        | 12.1        | 153.97.35.8
 65.1        | 12.1        | 153.97.36
 66.1        | 13.0        | 153.14.36.8
 67.1        | 13.0        | 153.14.37
 68.2        | 13.0        | 153.14.38.8
 69.1        | 13.0        | 153.14.39
 70.1        | 14.0        | 153.112.40
(21 rows)


=3D# select * from pg_icu_collation_versions('zh') order by icu_version;
 icu_version | uca_version | collator_version=20
-------------+-------------+------------------
 50.2        | 6.2         | 58.0.0.50
 51.3        | 6.2         | 58.0.0.50
 52.2        | 6.2         | 58.0.0.50
 53.2        | 6.3         | 137.51.25
 54.2        | 7.0         | 137.56.26
 55.2        | 7.0         | 153.56.27.1
 56.2        | 8.0         | 153.64.28
 57.2        | 8.0         | 153.64.29
 58.3        | 9.0         | 153.72.30.3
 59.2        | 9.0         | 153.72.31.1
 60.3        | 10.0        | 153.80.32.1
 61.2        | 10.0        | 153.80.33
 62.2        | 11.0        | 153.88.33.8
 63.2        | 11.0        | 153.88.34
 64.2        | 12.1        | 153.97.35.8
 65.1        | 12.1        | 153.97.36
 66.1        | 13.0        | 153.14.36.8
 67.1        | 13.0        | 153.14.37
 68.2        | 13.0        | 153.14.38.8
 69.1        | 13.0        | 153.14.39
 70.1        | 14.0        | 153.112.40
(21 rows)


--=20
Jeff Davis
PostgreSQL Contributor Team - AWS