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 <antti@lampinen.eu>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2024-07-02T10:22:26Z
Lists: pgsql-bugs

Attachments

On Wed, Jun 26, 2024 at 3:31 PM Richard Guo <guofenglinux@gmail.com> wrote:
> I've added a test case in the v2 patch.  I'll park it in the July
> commitfest.

Here is an updated patch, with some tweaks suggested by pgindent, and
adjustments to the commit message suggested by Andrew (off-list).

Barring objections, I'm planning to push it next week.

Thanks
Richard

Commits

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