]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0ab7110) | patch
Prevent Parallel Hash Join for JOIN_UNIQUE_INNER.
authorThomas Munro <tmunro@postgresql.org>
Tue, 18 Jun 2019 10:38:30 +0000 (22:38 +1200)
committerThomas Munro <tmunro@postgresql.org>
Tue, 18 Jun 2019 13:25:57 +0000 (01:25 +1200)
commitaca127c105aae551620d607e88d76930e6b9a2cf
tree0bfa491870fa91d9c93396589af251c4e3f27623tree | snapshot
parent0ab7110bcbcce5ff58afb32e7871c54e87502139commit | diff
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
src/backend/optimizer/path/joinpath.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.