Provide deterministic order for catalog queries in partition_split.sql
authorAlexander Korotkov <[email protected]>
Sun, 26 May 2024 03:38:00 +0000 (06:38 +0300)
committerAlexander Korotkov <[email protected]>
Sun, 26 May 2024 03:41:56 +0000 (06:41 +0300)
commitd53a4286d772c50ad7a8ff72ca637de613532592
treee780215f1155fcfcc7fb05112d95b16406958426
parent87331c68233425dd02048978e527dcf1ca505c6d
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
src/test/regress/expected/partition_split.out
src/test/regress/sql/partition_split.sql