Re: "variable not found in subplan target lists" with partitionwise join

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: wenhui qiu <qiuwenhuifx(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: "variable not found in subplan target lists" with partitionwise join
Date: 2026-10-21 09:16:45
Message-ID: CAMbWs4_ifXE6Z-YKuEXmHu7uLfNvc-Z6wmiubOjAykxPQRRZqA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Oct 19, 2026 at 5:14 PM wenhui qiu <qiuwenhuifx(at)gmail(dot)com> wrote:
> One minor wording suggestion: the new comment says that equal() compares PlaceHolderVars “only by phid”, but phlevelsup and phnullingrels are also compared. The relevant point here is that phexpr and phrels are ignored, so perhaps:
> * otherwise match the translated ones in "exprs", since equal()
> * ignores phexpr and phrels when comparing PlaceHolderVars.
> What do you think?

Thanks! I've updated the comment, and then pushed and back-patched
it to v14.

- Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2026-10-21 09:20:09 Re: Wrong results from a mergejoin
Previous Message ZizhuanLiu X-MAN 2026-10-21 09:11:05 Re: Optimize MCV stats for sortable types and utilize sorted-order properties