Horton

Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: antti@lampinen.eu, pgsql-bugs@lists.postgresql.org
Date: 2024-07-01T02:55:23Z
Lists: pgsql-bugs 
On Tue, Jun 25, 2024 at 10:07 AM Richard Guo <guofenglinux@gmail.com> wrote:
> Thank you for reporting.  As far as I recall, this is the first
> field-reported bug about the right anti join!

Just for the record, this issue was reported again with BUG #18526 by
Feliphe Pozzer in

https://www.postgresql.org/message-id/flat/18526-bf89f27cb20d8a18%40postgresql.org

Thanks
Richard

Commits

  1. Fix right-anti-joins when the inner relation is proven unique