]> granicus.if.org Git - postgresql/commit
Avoid instability in output of new REINDEX SCHEMA test.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 12 Dec 2014 20:49:03 +0000 (15:49 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 12 Dec 2014 20:49:09 +0000 (15:49 -0500)
commit1c5c70df45714f38c033bb1a272d8db4f2dc8a2f
treed4ca3be242d575d97c63b221d3a08b0649a212ef
parent7e354ab9fe9e7c3b0a7a40f226c76bd5cf6438d0
Avoid instability in output of new REINDEX SCHEMA test.

The planner seems to like to do this join query as a hash join, making
the output ordering machine-dependent; worse, it's a hash on OIDs, so
that it's a bit astonishing that the result doesn't change from run to
run even on one machine.  Add an ORDER BY to get consistent results.
Per buildfarm.

I also suppressed output from the final DROP SCHEMA CASCADE, to avoid
occasional failures similar to those fixed in commit 81d815dc3ed74a7d.
That hasn't been observed in the buildfarm yet, but it seems likely
to happen in future if we leave it as-is.
src/test/regress/expected/create_index.out
src/test/regress/sql/create_index.sql