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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 10215501441(at)stu(dot)ecnu(dot)edu(dot)cn
Cc: 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-04 14:01:36
Message-ID: 1564958.1788530496@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> A query using a partitioned left/right join split, with
> `enable_partitionwise_join`, parallel settings, and `GROUP BY ROLLUP` fails
> at planning time with:
> ERROR: variable not found in subplan target list

Fascinating. For me, this fails *only* in v18, not earlier or later
branches. That's not a usual pattern for our bugs ...

Will look closer in a bit, if nobody beats me to it.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrey Rachitskiy 2026-09-04 14:59:19 Re: BUG #19653: "variable not found in subplan target list" during planning with parallel parameterized nested loop,
Previous Message Andrey Rachitskiy 2026-09-04 10:38:27 Re: BUG #19621: Unexpected results of JSON_VALUE with DEFAULT ON EMPTY