| From: | Alexander Korotkov <akorotkov(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Provide deterministic order for catalog queries in partition_spl |
| Date: | 2024-05-26 03:47:33 |
| Message-ID: | E1sB4r7-001nCv-IO@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2024-05-26 03:48:37 | pgsql: doc PG 17 relnote: adjust "SLRU cache sizes to be configured" |
| Previous Message | Bruce Momjian | 2024-05-26 03:40:41 | pgsql: doc PG 17 relnotes: combine items |