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

Commit7ed908b

Browse files
committed
Force consistent row order in contrib/test_decoding regression test.
1 parent9613a1d commit7ed908b

File tree

2 files changed

+3
-3
lines changed

2 files changed

+3
-3
lines changed

‎contrib/test_decoding/expected/ddl.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -196,11 +196,11 @@ COMMIT;
196196
SELECT count(*), min(data), max(data)
197197
FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0')
198198
GROUP BY substring(data, 1, 24)
199-
ORDER BY 1;
199+
ORDER BY 1,2;
200200
count | min | max
201201
-------+-------------------------------------------------+------------------------------------------------------------------------
202-
1 | COMMIT | COMMIT
203202
1 | BEGIN | BEGIN
203+
1 | COMMIT | COMMIT
204204
20467 | table public.tr_etoomuch: DELETE: id[integer]:1 | table public.tr_etoomuch: UPDATE: id[integer]:9999 data[integer]:-9999
205205
(3 rows)
206206

‎contrib/test_decoding/sql/ddl.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -112,7 +112,7 @@ COMMIT;
112112
SELECTcount(*),min(data),max(data)
113113
FROM pg_logical_slot_get_changes('regression_slot',NULL,NULL,'include-xids','0')
114114
GROUP BYsubstring(data,1,24)
115-
ORDER BY1;
115+
ORDER BY1,2;
116116

117117
/*
118118
* check whether we decode subtransactions correctly in relation with each

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp