pgsql: Improve stability of identity.sql regression test. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Improve stability of identity.sql regression test.
Date
Msg-id E1kPEeC-00055X-FZ@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Improve stability of identity.sql regression test.

I noticed while trying to run the regression tests under a low
geqo_threshold that one query on information_schema.columns had
unstable (as in, variable from one run to the next) output order.
This is pretty unsurprising given the complexity of the underlying
plan.  Interestingly, of this test's three nigh-identical queries on
information_schema.columns, the other two already had ORDER BY clauses
guaranteeing stable output.  Let's make this one look the same.

Back-patch to v10 where this test was added.  We've not heard field
reports of the test failing, but this experience shows that it can
happen when testing under even slightly unusual conditions.

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/0d1f6ae485d8d3d034e3d67dd38cc65ab359f773

Modified Files
--------------
src/test/regress/expected/identity.out | 2 +-
src/test/regress/sql/identity.sql      | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Fix handling of redundant options with COPY for "freeze" and "he
Next
From: Tom Lane
Date:
Subject: pgsql: Improve stability of identity.sql regression test.