pgsql: Fix UUID sortability tests in base32hex encoding. - Mailing list pgsql-committers

From Masahiko Sawada
Subject pgsql: Fix UUID sortability tests in base32hex encoding.
Date
Msg-id E1w5b9H-001Tiq-02@gemulon.postgresql.org
Whole thread Raw
List 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@sss.pgh.pa.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(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Improve timeout handling of pg_promote()
Next
From: Amit Kapila
Date:
Subject: pgsql: Refactor replorigin_session_setup() for better readability.