Horton

Re: Wrong results with right-semi-joins

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2024-12-09T12:17:03Z
Lists: pgsql-hackers 
On Tue, Dec 3, 2024 at 5:56 PM Richard Guo <guofenglinux@gmail.com> wrote:
> I've traced the root cause to ExecReScanHashJoin, where we neglect to
> reset the inner-tuple match flags in the hash table for right-semi
> joins when reusing the hash table.  It was my oversight in commit
> aa86129e1.  Attached is patch to fix it.

Pushed.

Thanks
Richard

Commits

  1. Improve the test case from 5668a857d

  2. Fix right-semi-joins in HashJoin rescans

  3. Support "Right Semi Join" plan shapes