Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit21f653c

Browse files
committed
Use stricter ordering in regression test query for pg_stat_io
The query introduced in8b53277 is proving to have ordering issuesunder at least the locale cs_CZ. This commit updates the query to use astricter ordering.Per reports from buildfarm members hippopotamus and jay.
1 parent8b53277 commit21f653c

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

‎src/test/regress/expected/stats.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@ SHOW track_counts; -- must be on
1414
-- List of backend types, contexts and objects tracked in pg_stat_io.
1515
\a
1616
SELECT backend_type, object, context FROM pg_stat_io
17-
ORDER BY backend_type, object, context COLLATE "C";
17+
ORDER BY backend_type COLLATE "C", object COLLATE "C", context COLLATE "C";
1818
backend_type|object|context
1919
autovacuum launcher|relation|bulkread
2020
autovacuum launcher|relation|init

‎src/test/regress/sql/stats.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,7 @@ SHOW track_counts; -- must be on
1111
-- List of backend types, contexts and objects tracked in pg_stat_io.
1212
\a
1313
SELECT backend_type, object, contextFROM pg_stat_io
14-
ORDER BY backend_type, object, context COLLATE"C";
14+
ORDER BY backend_type COLLATE"C", object COLLATE"C", context COLLATE"C";
1515
\a
1616

1717
-- ensure that both seqscan and indexscan plans are allowed

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp