Re: Wrong results with right-semi-joins

Melanie Plageman <melanieplageman@gmail.com>

From: Melanie Plageman <melanieplageman@gmail.com>

To: Richard Guo <guofenglinux@gmail.com>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2024-12-12T12:48:47Z

Lists: pgsql-hackers

On Wed, Dec 11, 2024 at 9:44 PM Richard Guo <guofenglinux@gmail.com> wrote:
>
> On Wed, Dec 11, 2024 at 11:27 AM Richard Guo <guofenglinux@gmail.com> wrote:
>
> > Maybe I should update the test case introduced in 5668a857d to this
> > one.
>
> Done.

Great, thanks. I think the new example is more clear.

- Melanie

Commits

Improve the test case from 5668a857d
- d8f335156c57 18.0 landed
Fix right-semi-joins in HashJoin rescans
- 5668a857de4f 18.0 landed
Support "Right Semi Join" plan shapes
- aa86129e19d7 18.0 cited