Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN
Date
Msg-id CAMbWs4_GWUiNVzQDPPj4tm21KG4G13qV4erf9Qu5j-V430f50Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN  (Andrei Lepikhov <a.lepikhov@postgrespro.ru>)
Responses Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN  (Andrei Lepikhov <a.lepikhov@postgrespro.ru>)
List pgsql-bugs
Tree view

On Thu, Nov 9, 2023 at 12:51 PM Andrei Lepikhov <a.lepikhov@postgrespro.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

pgsql-bugs by date:

Previous
From: Andrei Lepikhov
Date:
Subject: Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN
Next
From: Andrei Lepikhov
Date:
Subject: Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN