| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Fix instability in regression test for Parallel Hash Full Join |
| Date: | 2023-06-12 03:21:47 |
| Message-ID: | E1q8Y7m-001LrN-Q0@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Fix instability in regression test for Parallel Hash Full Join
As reported by buildfarm member conchuela, one of the regression tests
added by 558c9d7 is having some ordering issues. This commit adds an
ORDER BY clause to make the output more stable for the problematic
query.
Fix suggested by Tom Lane. The plan of the query updated still uses a
parallel hash full join.
Author: Melanie Plageman
Discussion: https://postgr.es/m/623596.1684541098@sss.pgh.pa.us
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/3e8da50244a8de69317babcfdb048172cf30f14c
Modified Files
--------------
src/test/regress/expected/join_hash.out | 3 ++-
src/test/regress/sql/join_hash.sql | 3 ++-
2 files changed, 4 insertions(+), 2 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2023-06-12 13:26:29 | pgsql: Remove a few unused global variables and declarations. |
| Previous Message | Michael Paquier | 2023-06-12 00:15:28 | pgsql: hstore: Tighten key/value parsing check for whitespaces |