pgsql: Fix some more regression test row-order-instability issues.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix some more regression test row-order-instability issues.
Date: 2017-01-13 22:32:43
Message-ID: E1cSAOp-0000Q1-8A@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix some more regression test row-order-instability issues.

Commit 0563a3a8b just introduced another instance of the same unsafe
testing methodology that appeared in 2ac3ef7a0, which I corrected in
257d81572. Robert/Amit, please stop doing that.

Also look through the rest of f0e44751d's test cases, and correct some
other queries with underdetermined ordering of results from the system
catalogs. These haven't failed in the buildfarm yet, but I don't
have any confidence in that staying true.

Per multiple buildfarm members.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/5ad966ab1c50e829462f2b3e3ffa59e2d95479e6

Modified Files
--------------
src/test/regress/expected/alter_table.out | 3 ++-
src/test/regress/expected/create_table.out | 8 ++++++--
src/test/regress/sql/alter_table.sql | 3 ++-
src/test/regress/sql/create_table.sql | 8 ++++++--
4 files changed, 16 insertions(+), 6 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2017-01-14 02:26:34 pgsql: Updates to reflect that pg_ctl stop -m fast is the default
Previous Message Tom Lane 2017-01-13 22:00:01 pgsql: In PL/Tcl tests, don't choke if optional error fields are missin