]> granicus.if.org Git - postgresql/commit
Fix NULL handling in multi-batch Parallel Hash Left Join.
authorThomas Munro <tmunro@postgresql.org>
Fri, 2 Nov 2018 22:05:35 +0000 (11:05 +1300)
committerThomas Munro <tmunro@postgresql.org>
Fri, 2 Nov 2018 22:05:35 +0000 (11:05 +1300)
commit1ce4a807e25bcd726e34b8d3ba0338e9299f9a87
treee5cbfe067878303940a6b027756d10b0f64ebe4f
parenta4634b96cc419523b2aa699d0c9129331a6cc079
Fix NULL handling in multi-batch Parallel Hash Left Join.

NULL keys in left joins were skipped when building batch files.
Repair, by making the keep_nulls argument to ExecHashGetHashValue()
depend on whether this is a left outer join, as we do in other
paths.

Bug #15475.  Thinko in 1804284042e.  Back-patch to 11.

Reported-by: Paul Schaap
Diagnosed-by: Andrew Gierth
Dicussion: https://postgr.es/m/15475-11a7a783fed72a36%40postgresql.org
src/backend/executor/nodeHashjoin.c