Re: Support "Right Semi Join" plan shapes

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: Japin Li <japinli@hotmail.com>

Cc: Alena Rybakina <lena.ribackina@yandex.ru>, wenhui qiu <qiuwenhuifx@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, vignesh C <vignesh21@gmail.com>

Date: 2024-07-05T01:00:47Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Support "Right Semi Join" plan shapes
- aa86129e19d7 18.0 landed
Fix neqjoinsel's behavior for semi/anti join cases.
- 7ca25b7de6ae 11.0 cited

On Thu, Jul 4, 2024 at 11:18 PM Japin Li <japinli@hotmail.com> wrote:

> On Thu, 04 Jul 2024 at 17:17, Richard Guo <guofenglinux@gmail.com> wrote:
> > Here is a new rebase.
> >
> > Barring objections, I'm planning to push it soon.

Pushed.  Thanks for all the reviews.

> Thanks for updating the patch.  It looks good to me, except for a minor nitpick:
>
> s/right-semijoin/right-semi join/

I did not take this one.  The comment nearby for RIGHT_ANTI uses
'right-antijoin', and I think we'd better adopt a consistent pattern for
RIGHT_SEMI.

Thanks
Richard