Hashed LEFT JOIN would miss outer tuples with no inner match if the join
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 17 Sep 2004 18:29:40 +0000 (18:29 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 17 Sep 2004 18:29:40 +0000 (18:29 +0000)
commit44ed69c8f3b3e21153af60cc22287fd0258878fe
tree8a3ecfb57b8386fca83a75bc2fd9ce14d1f8418b
parenta59084fe5e724d4bc0bc96f8cae49525fa16fe4f
Hashed LEFT JOIN would miss outer tuples with no inner match if the join
was large enough to be batched and the tuples fell into a batch where
there were no inner tuples at all.  Thanks to Xiaoyu Wang for finding a
test case that exposed this long-standing bug.
src/backend/executor/nodeHashjoin.c