Fix parallel hash join path search.

Robert Haas <rhaas@postgresql.org>

Commit: 655393a022bd653e2b48dbf20b69236981e35195
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-03-07T15:22:07Z
Releases: 10.0
Fix parallel hash join path search.

When the very cheapest path is not parallel-safe, we want to instead use
the cheapest unparameterized path that is.  The old code searched
innerrel->cheapest_parameterized_paths, but that isn't right, because
the path we want may not be in that list.  Search innerrel->pathlist
instead.

Spotted by Dilip Kumar.

Discussion: http://postgr.es/m/CAFiTN-szCEcZrQm0i_w4xqSaRUTOUFstNu32Zn4rxxDcoa8gnA@mail.gmail.com

Files

PathChange+/−
src/backend/optimizer/path/joinpath.c modified +4 −4

Discussion