pgsql: Provide deterministic order for catalog queries in partition_spl - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Provide deterministic order for catalog queries in partition_spl
Date
Msg-id E1sB4r7-001nCv-IO@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Provide deterministic order for catalog queries in partition_split.sql

System catalog tables are subject to modification by parallel tests.  This
is the source of instability when querying them without explicit ORDER BY.
This commit adds explicit ORDER BY to system catalog queries in
partition_split.sql to stabilize the result.

Reported-by: Tom Lane
Discussion: https://postgr.es/m/695264.1716578979%40sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d53a4286d772c50ad7a8ff72ca637de613532592

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


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: doc PG 17 relnotes: combine items
Next
From: Bruce Momjian
Date:
Subject: pgsql: doc PG 17 relnote: adjust "SLRU cache sizes to be configured"