diff options
| author | Noah Misch <noah@leadboat.com> | 2014-03-29 00:31:44 -0400 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2014-03-29 00:31:44 -0400 |
| commit | 7ed908be41fbca1635d34f97138abb13beab8b24 (patch) | |
| tree | 707c3f70280c0e8ddd02bb34efd9c100bc5656fd | |
| parent | 9613a1d98e5f940d8124850e61b0a950157c8863 (diff) | |
| download | postgresql-7ed908be41fbca1635d34f97138abb13beab8b24.tar.gz postgresql-7ed908be41fbca1635d34f97138abb13beab8b24.zip | |
Force consistent row order in contrib/test_decoding regression test.
| -rw-r--r-- | contrib/test_decoding/expected/ddl.out | 4 | ||||
| -rw-r--r-- | 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 4d25a28b933..3369f2771d3 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 f412d40b15d..555a59c5adf 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 |