Re: Wrong results with right-semi-joins

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Wrong results with right-semi-joins
Date: 2024-12-09 12:17:03
Message-ID: CAMbWs49m6mn=Lb9vxyx41L5=p6kKrp4QnsNRziWKidmdc0GQog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 3, 2024 at 5:56 PM Richard Guo <guofenglinux(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2024-12-09 12:20:16 Re: An inefficient query caused by unnecessary PlaceHolderVar
Previous Message Kirill Reshke 2024-12-09 11:50:16 Re: WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4)