aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2025-03-08 13:39:57 +0900
committerMichael Paquier <michael@paquier.xyz>2025-03-08 13:39:57 +0900
commit21f653cc0024100f8ecc279162631f2b1ba8c46c (patch)
tree6e93c5c94e0c58e4b5ed94e35c2f88c462221233 /src
parent8b532771a09975f274b35823aa355d8ca90c77db (diff)
downloadpostgresql-21f653cc0024100f8ecc279162631f2b1ba8c46c.tar.gz
postgresql-21f653cc0024100f8ecc279162631f2b1ba8c46c.zip
Use stricter ordering in regression test query for pg_stat_io
The query introduced in 8b532771a099 is proving to have ordering issues under at least the locale cs_CZ. This commit updates the query to use a stricter ordering. Per reports from buildfarm members hippopotamus and jay.
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/stats.out2
-rw-r--r--src/test/regress/sql/stats.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/stats.out b/src/test/regress/expected/stats.out
index 2707f3400d9..30d763c4aee 100644
--- a/src/test/regress/expected/stats.out
+++ b/src/test/regress/expected/stats.out
@@ -14,7 +14,7 @@ SHOW track_counts; -- must be on
-- List of backend types, contexts and objects tracked in pg_stat_io.
\a
SELECT backend_type, object, context FROM pg_stat_io
- ORDER BY backend_type, object, context COLLATE "C";
+ ORDER BY backend_type COLLATE "C", object COLLATE "C", context COLLATE "C";
backend_type|object|context
autovacuum launcher|relation|bulkread
autovacuum launcher|relation|init
diff --git a/src/test/regress/sql/stats.sql b/src/test/regress/sql/stats.sql
index 7e03af93168..5e7ef20fef6 100644
--- a/src/test/regress/sql/stats.sql
+++ b/src/test/regress/sql/stats.sql
@@ -11,7 +11,7 @@ SHOW track_counts; -- must be on
-- List of backend types, contexts and objects tracked in pg_stat_io.
\a
SELECT backend_type, object, context FROM pg_stat_io
- ORDER BY backend_type, object, context COLLATE "C";
+ ORDER BY backend_type COLLATE "C", object COLLATE "C", context COLLATE "C";
\a
-- ensure that both seqscan and indexscan plans are allowed