]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix UUID sortability tests in base32hex encoding.
authorMasahiko Sawada <msawada@postgresql.org>
Thu, 26 Mar 2026 03:12:26 +0000 (20:12 -0700)
committerMasahiko Sawada <msawada@postgresql.org>
Thu, 26 Mar 2026 03:12:26 +0000 (20:12 -0700)
commit89210037a0ab1f5e1375484edcfb8bbb4d9e7970
tree9ab8504a7d11265eb500c0c79581e88ab99a8e4f
parent4287c50fc21e6d1c7798955020f8438ae2327472
Fix UUID sortability tests in base32hex encoding.

Commit 497c1170cb1 added base32hex encoding support, but its
regression test for UUIDs failed on buildfarm members hippopotamus and
jay using natural language locales (such as cs_CZ). This happened
because those collations may sort characters differently, which breaks
the strict byte-wise lexicographical ordering expected by base32hex
encoding.

This commit fixes the regression tests by explicitly using the C
collation.

Per buildfarm members hippopotamus and jay.

Analyzed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/682417.1774482047@sss.pgh.pa.us
src/test/regress/expected/uuid.out
src/test/regress/sql/uuid.sql