On Tue, Jun 25, 2024 at 2:37 AM PG Bug reporting form
<noreply(at)postgresql(dot)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