Re: Support "Right Semi Join" plan shapes

Alena Rybakina <lena.ribackina@yandex.ru>

From: Alena Rybakina <lena.ribackina@yandex.ru>

To: wenhui qiu <qiuwenhuifx@gmail.com>

Cc: Richard Guo <guofenglinux@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, vignesh C <vignesh21@gmail.com>

Date: 2024-03-09T13:24:25Z

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 06.03.2024 05:23, wenhui qiu wrote:
>
>
>       Hi Alena Rybakina
>       For merge join
>       + /*
>       + * For now we do not support RIGHT_SEMI join in mergejoin.
>       + */
>       + if (jointype == JOIN_RIGHT_SEMI)
>       + {
>       + *mergejoin_allowed = false;
>       + return NIL;
>       + }
>       +
>       Tanks
>
>
Yes, I see it, thank you. Sorry for the noise.

-- 
Regards,
Alena Rybakina
Postgres Professional:http://www.postgrespro.com
The Russian Postgres Company