From 17bcf4f5450430f67b744c225566c9e0e6413e95 Mon Sep 17 00:00:00 2001 From: =?utf8?q?=C3=81lvaro=20Herrera?= Date: Mon, 7 Apr 2025 21:58:06 +0200 Subject: [PATCH] Use specific collation where needed in new test Oversight in commit a379061a22a8. Per Czech buildfarm members jay and hippopotamus. --- src/test/regress/expected/constraints.out | 2 +- src/test/regress/sql/constraints.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/test/regress/expected/constraints.out b/src/test/regress/expected/constraints.out index 1346134e23c..a8c6495ae01 100644 --- a/src/test/regress/expected/constraints.out +++ b/src/test/regress/expected/constraints.out @@ -1367,7 +1367,7 @@ PREPARE get_nnconstraint_info(regclass[]) AS SELECT conrelid::regclass as tabname, conname, convalidated, conislocal, coninhcount FROM pg_constraint WHERE conrelid = ANY($1) -ORDER BY conrelid::regclass::text, conname; +ORDER BY conrelid::regclass::text COLLATE "C", conname; CREATE TABLE notnull_tbl1 (a int, b int); INSERT INTO notnull_tbl1 VALUES (NULL, 1), (300, 3); ALTER TABLE notnull_tbl1 ADD CONSTRAINT nn NOT NULL a; -- error diff --git a/src/test/regress/sql/constraints.sql b/src/test/regress/sql/constraints.sql index 0f2fe3e6e2d..bf8f0aa181d 100644 --- a/src/test/regress/sql/constraints.sql +++ b/src/test/regress/sql/constraints.sql @@ -812,7 +812,7 @@ PREPARE get_nnconstraint_info(regclass[]) AS SELECT conrelid::regclass as tabname, conname, convalidated, conislocal, coninhcount FROM pg_constraint WHERE conrelid = ANY($1) -ORDER BY conrelid::regclass::text, conname; +ORDER BY conrelid::regclass::text COLLATE "C", conname; CREATE TABLE notnull_tbl1 (a int, b int); INSERT INTO notnull_tbl1 VALUES (NULL, 1), (300, 3); -- 2.30.2