From 7ed908be41fbca1635d34f97138abb13beab8b24 Mon Sep 17 00:00:00 2001 From: Noah Misch Date: Sat, 29 Mar 2014 00:31:44 -0400 Subject: [PATCH] Force consistent row order in contrib/test_decoding regression test. --- contrib/test_decoding/expected/ddl.out | 4 ++-- contrib/test_decoding/sql/ddl.sql | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/contrib/test_decoding/expected/ddl.out b/contrib/test_decoding/expected/ddl.out index 4d25a28b93..3369f2771d 100644 --- a/contrib/test_decoding/expected/ddl.out +++ b/contrib/test_decoding/expected/ddl.out @@ -196,11 +196,11 @@ COMMIT; SELECT count(*), min(data), max(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0') GROUP BY substring(data, 1, 24) -ORDER BY 1; +ORDER BY 1,2; count | min | max -------+-------------------------------------------------+------------------------------------------------------------------------ - 1 | COMMIT | COMMIT 1 | BEGIN | BEGIN + 1 | COMMIT | COMMIT 20467 | table public.tr_etoomuch: DELETE: id[integer]:1 | table public.tr_etoomuch: UPDATE: id[integer]:9999 data[integer]:-9999 (3 rows) diff --git a/contrib/test_decoding/sql/ddl.sql b/contrib/test_decoding/sql/ddl.sql index f412d40b15..555a59c5ad 100644 --- a/contrib/test_decoding/sql/ddl.sql +++ b/contrib/test_decoding/sql/ddl.sql @@ -112,7 +112,7 @@ COMMIT; SELECT count(*), min(data), max(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0') GROUP BY substring(data, 1, 24) -ORDER BY 1; +ORDER BY 1,2; /* * check whether we decode subtransactions correctly in relation with each -- 2.40.0