Make regression tests less dependent on hash table order.
authorAndres Freund <andres@anarazel.de>
Mon, 10 Oct 2016 20:41:57 +0000 (13:41 -0700)
committerAndres Freund <andres@anarazel.de>
Mon, 10 Oct 2016 20:41:57 +0000 (13:41 -0700)
commit0137caf273f4297c4d36df3a542d7c0c853e75be
tree928e91e070fcdb2d96eb7eeaef5a83bda2c2d2f4
parent886f6c5ccdb500eeeec7e0abdf1500e20a304c45
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: <20160727004333.r3e2k2y6fvk2ntup@alap3.anarazel.de>
src/test/regress/expected/matview.out
src/test/regress/expected/psql.out
src/test/regress/expected/tsrf.out
src/test/regress/expected/union.out
src/test/regress/expected/with.out
src/test/regress/sql/matview.sql
src/test/regress/sql/psql.sql
src/test/regress/sql/tsrf.sql
src/test/regress/sql/union.sql
src/test/regress/sql/with.sql