projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: d522b05) | patch
Fix instability in regression test for Parallel Hash Full Join
authorMichael Paquier <michael@paquier.xyz>
Mon, 12 Jun 2023 03:19:46 +0000 (12:19 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 12 Jun 2023 03:19:46 +0000 (12:19 +0900)
commit3e8da50244a8de69317babcfdb048172cf30f14c
tree5809fddf21f3c6cc232cf629014a6db1bc2aa661tree
parentd522b05c8c1c2c430b2c8be795c609f6f4f2ce44commit | diff
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
src/test/regress/expected/join_hash.out diff | blob | blame | history
src/test/regress/sql/join_hash.sql diff | blob | blame | history
Robert Haas's development tree.