]> granicus.if.org Git - postgresql/commit
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:28:53 +0000 (18:28 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 17 Sep 2004 18:28:53 +0000 (18:28 +0000)
commita5713ec427f15f2c63eaed14f2a16a952b7ddf06
treeba8dc425608584922b7ca91ae20670ecf07be755
parent054b78ba38e7bd11db1725ede38675b5cfaebe0b
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