Make regression tests less dependent on hash table order.
Andres Freund <andres@anarazel.de>
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>
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/matview.out | modified | +3 −3 |
| src/test/regress/expected/psql.out | modified | +1 −1 |
| src/test/regress/expected/tsrf.out | modified | +4 −4 |
| src/test/regress/expected/union.out | modified | +69 −60 |
| src/test/regress/expected/with.out | modified | +4 −4 |
| src/test/regress/sql/matview.sql | modified | +2 −2 |
| src/test/regress/sql/psql.sql | modified | +1 −1 |
| src/test/regress/sql/tsrf.sql | modified | +1 −1 |
| src/test/regress/sql/union.sql | modified | +34 −29 |
| src/test/regress/sql/with.sql | modified | +4 −4 |