pgsql: Fix UUID sortability tests in base32hex encoding.

From: Masahiko Sawada <msawada(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix UUID sortability tests in base32hex encoding.
Date: 2026-03-26 03:12:43
Message-ID: E1w5b9H-001Tiq-02@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/682417.1774482047@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/89210037a0ab1f5e1375484edcfb8bbb4d9e7970

Modified Files
--------------
src/test/regress/expected/uuid.out | 7 +++++--
src/test/regress/sql/uuid.sql | 7 +++++--
2 files changed, 10 insertions(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2026-03-26 03:51:59 pgsql: Refactor replorigin_session_setup() for better readability.
Previous Message Michael Paquier 2026-03-26 01:41:09 pgsql: Improve timeout handling of pg_promote()