Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join
Date
Msg-id CAMbWs4_+7BVazeFwhP8+XCPjsFa=hM=cnOA8ri5q_8qav9mC_g@mail.gmail.com
Whole thread Raw
In response to BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join
Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join
List pgsql-bugs
On Tue, Jun 25, 2024 at 2:37 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
> The following two queries result in different query plans and different
> results, even though there is only a dummy condition change between them.
> The
> latter results are correct, there are two rows that match the conditions.

Thank you for reporting.  As far as I recall, this is the first
field-reported bug about the right anti join!

Could you please provide the schema and necessary data for the two
tables to reproduce this bug?  If there is a self-contained repro, that
would be great.

Thanks
Richard



pgsql-bugs by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: error "can only drop stats once" brings down database
Next
From: Michael Paquier
Date:
Subject: Re: error "can only drop stats once" brings down database