Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
Cc: zuming(dot)jiang(at)inf(dot)ethz(dot)ch, pgsql-bugs(at)lists(dot)postgresql(dot)org, PG Bug reporting form <noreply(at)postgresql(dot)org>
Subject: Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN
Date: 2023-11-09 11:08:38
Message-ID: CAMbWs4_GWUiNVzQDPPj4tm21KG4G13qV4erf9Qu5j-V430f50Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Nov 9, 2023 at 12:51 PM Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
wrote:

> ... Should we add a reference to the
> bug that triggered the issue as a comment to the test?

Yeah, we can do that. I guess something like:

-- Check that SJE removes references from PHVs correctly (bug #18187)

> Also, to be sure,
> maybe add column t4.code into the list of the coalesce parameters?

I don't think it's necessary. It is t3 that SJE would remove, so it's
sufficient to have t3's Vars in the PHV expression to trigger this
error.

Thanks
Richard

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrei Lepikhov 2023-11-09 11:21:46 Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN
Previous Message torikoshia 2023-11-09 06:30:56 Re: pg_rewind WAL segments deletion pitfall