Postgres Pro
Downloads
Home   >   mailing lists

Re: Wrong results with right-semi-joins - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Wrong results with right-semi-joins
Date
Msg-id CAMbWs49m6mn=Lb9vxyx41L5=p6kKrp4QnsNRziWKidmdc0GQog@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Track the amount of time waiting due to cost_delay
Next
From: Richard Guo
Date:
Subject: Re: An inefficient query caused by unnecessary PlaceHolderVar