pgsql: Fix UUID sortability tests in base32hex encoding.

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема pgsql: Fix UUID sortability tests in base32hex encoding.
Дата
Msg-id E1w5b9H-001Tiq-02@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления: