Make regression tests less dependent on hash table order. Upcoming changes to the hash table code used, among others, for grouping and set operations will change the output order for a few queries. To make it less likely that actual bugs are hidden between regression test ordering changes, and to make the tests robust against platform dependant ordering, add ORDER BYs guaranteeing the output order.
As it's possible that some of the changes expose platform dependant ordering, push this earlier, to let the buildfarm shake out potentially unstable results. Discussion: <[email protected]> Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/0137caf273f4297c4d36df3a542d7c0c853e75be Modified Files -------------- src/test/regress/expected/matview.out | 6 +- src/test/regress/expected/psql.out | 2 +- src/test/regress/expected/tsrf.out | 8 +-- src/test/regress/expected/union.out | 129 ++++++++++++++++++---------------- src/test/regress/expected/with.out | 8 +-- src/test/regress/sql/matview.sql | 4 +- src/test/regress/sql/psql.sql | 2 +- src/test/regress/sql/tsrf.sql | 2 +- src/test/regress/sql/union.sql | 63 +++++++++-------- src/test/regress/sql/with.sql | 8 +-- 10 files changed, 123 insertions(+), 109 deletions(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
