Horton

Prevent Parallel Hash Join for JOIN_UNIQUE_INNER.

Thomas Munro <tmunro@postgresql.org>

View on postgr.es
Commit: 14d8b539d3bd4cf9faf65ca86a733bada202107f
Author: Thomas Munro <tmunro@postgresql.org>
Date: 2019-06-18T14:13:52Z
Releases: 11.5 
Prevent Parallel Hash Join for JOIN_UNIQUE_INNER.

WHERE EXISTS (...) queries cannot be executed by Parallel Hash Join
with jointype JOIN_UNIQUE_INNER, because there is no way to make a
partial plan totally unique.  The consequence of allowing such plans
was duplicate results from some EXISTS queries.

Back-patch to 11.  Bug #15857.

Author: Thomas Munro
Reviewed-by: Tom Lane
Reported-by: Vladimir Kriukov
Discussion: https://postgr.es/m/15857-d1ba2a64bce0795e%40postgresql.org

Files

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

Discussion