Horton

Fix instability in regression test for Parallel Hash Full Join

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 3e8da50244a8de69317babcfdb048172cf30f14c
Author: Michael Paquier <michael@paquier.xyz>
Date: 2023-06-12T03:19:46Z
Releases: 16.0 
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

Files

PathChange+/−
src/test/regress/expected/join_hash.out modified +2 −1
src/test/regress/sql/join_hash.sql modified +2 −1

Discussion