Re: BUG #19653: "variable not found in subplan target list" during planning with parallel parameterized nested loop,

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 10215501441(at)stu(dot)ecnu(dot)edu(dot)cn, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19653: "variable not found in subplan target list" during planning with parallel parameterized nested loop,
Date: 2026-09-07 08:27:47
Message-ID: CAMbWs4913G2ZWwEFbc=65zibQcqbY2nhxtFmHEx7KF+jfsGtVQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Sep 7, 2026 at 12:30 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Yeah, I tried adjusting things like that and the regression tests
> immediately crashed. So now I think we have to do it as you have it;
> but maybe the comment could be improved to explain that we need to
> match both Vars having the child relid and PHVs having top-parent
> relids.

Done in the attached.

> Agreed. Quite aside from the number of places that'd have to be
> touched, I'm not too comfortable with rethinking those design
> decisions in a hasty back-patch. It seems not unlikely that
> extensions contain code that expects the current data structure
> definitions.

Agreed. I'll leave the design as it is.

- Richard

Attachment Content-Type Size
v2-0001-Fix-nestloop-parameter-handling-for-PlaceHolderVa.patch application/octet-stream 13.5 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ewan Young 2026-09-07 08:36:26 Re: BUG #19545: Integer truncation of `GinTuple.keylen` causes out-of-bounds read in parallel GIN index build
Previous Message Tom Lane 2026-09-07 03:30:33 Re: BUG #19653: "variable not found in subplan target list" during planning with parallel parameterized nested loop,