Re: Wrong results from an antijoin

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Wrong results from an antijoin
Date: 2026-10-14 03:19:07
Message-ID: CAMbWs4_zcGJdigiNoBOT8Uq+u56TBskU2a1CYZTENWFTLTnORg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 14, 2026 at 4:40 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> > In v2, I updated add_antijoin_rte() to build the RTE by hand, much as
> > transform_MERGE_to_join() does for its join RTE.

> v2 works for me.

Thanks! Pushed and back-patched to v16.

- Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2026-10-14 03:30:00 Parallel vacuum: avoid dangling shared memory pointers
Previous Message Bharath Rupireddy 2026-10-14 03:15:00 Parallel autovacuum: honor reduced parallel workers after heap scan phase