Horton

Provide deterministic order for catalog queries in partition_split.sql

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: d53a4286d772c50ad7a8ff72ca637de613532592
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2024-05-26T03:41:56Z
Releases: 17.0 
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

Files

PathChange+/−
src/test/regress/expected/partition_split.out modified +17 −17
src/test/regress/sql/partition_split.sql modified +17 −17

Discussion