aboutsummaryrefslogtreecommitdiff
path: root/src/test/modules/commit_ts/sql/commit_timestamp.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2014-12-12 15:49:03 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2014-12-12 15:49:09 -0500
commit1c5c70df45714f38c033bb1a272d8db4f2dc8a2f (patch)
treed4ca3be242d575d97c63b221d3a08b0649a212ef /src/test/modules/commit_ts/sql/commit_timestamp.sql
parent7e354ab9fe9e7c3b0a7a40f226c76bd5cf6438d0 (diff)
downloadpostgresql-1c5c70df45714f38c033bb1a272d8db4f2dc8a2f.tar.gz
postgresql-1c5c70df45714f38c033bb1a272d8db4f2dc8a2f.zip
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.
Diffstat (limited to 'src/test/modules/commit_ts/sql/commit_timestamp.sql')
0 files changed, 0 insertions, 0 deletions