diff options
| author | Andres Freund | 2016-10-13 01:31:45 +0000 |
|---|---|---|
| committer | Andres Freund | 2016-10-13 01:31:45 +0000 |
| commit | ccbb852cd6101e93976111676a90f1e5d9268951 (patch) | |
| tree | a3d473c25715d1012161ea8ce0b554c6669bb3e8 /contrib | |
| parent | b4fc645787cc7c614c0c97fc9fffacf2bdc6a388 (diff) | |
Fix further hash table order dependent tests.
Similar to 0137caf273, this makes contrib and pl tests less dependant on
hash-table order. After this commit, at least some order affecting
changes to execGrouping.c don't result in regression test changes
anymore.
Diffstat (limited to 'contrib')
| -rw-r--r-- | contrib/test_decoding/expected/ddl.out | 4 | ||||
| -rw-r--r-- | contrib/test_decoding/sql/ddl.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/contrib/test_decoding/expected/ddl.out b/contrib/test_decoding/expected/ddl.out index bd9b42f4010..7fbeafdb392 100644 --- a/contrib/test_decoding/expected/ddl.out +++ b/contrib/test_decoding/expected/ddl.out @@ -274,9 +274,9 @@ INSERT INTO tr_etoomuch (id, data) SELECT g.i, -g.i FROM generate_series(8000, 12000) g(i) ON CONFLICT(id) DO UPDATE SET data = EXCLUDED.data; SELECT substring(data, 1, 29), count(*) -FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') +FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') WITH ORDINALITY GROUP BY 1 -ORDER BY min(location - '0/0'); +ORDER BY min(ordinality); substring | count -------------------------------+------- BEGIN | 1 diff --git a/contrib/test_decoding/sql/ddl.sql b/contrib/test_decoding/sql/ddl.sql index e99b2d37d9e..89b8b8f7800 100644 --- a/contrib/test_decoding/sql/ddl.sql +++ b/contrib/test_decoding/sql/ddl.sql @@ -146,9 +146,9 @@ SELECT g.i, -g.i FROM generate_series(8000, 12000) g(i) ON CONFLICT(id) DO UPDATE SET data = EXCLUDED.data; SELECT substring(data, 1, 29), count(*) -FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') +FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') WITH ORDINALITY GROUP BY 1 -ORDER BY min(location - '0/0'); +ORDER BY min(ordinality); /* * check whether we decode subtransactions correctly in relation with each |