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_XreeMgvDMPDGPWYdz5fh3X1v2Qe_XRaN3d1g72URi2A@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>)
List pgsql-bugs

On Wed, Nov 22, 2023 at 10:32 AM Andrei Lepikhov <a.lepikhov@postgrespro.ru> wrote:
Your patch is ok.

Thanks for looking into this patch.
 
I think the comment, 'PHVs should not impose ...' looks redundant. It
may be enough to have it in the commit comment.

Hmm, I'm not sure.  I'm thinking that when people read this part of the
code, they might be confused as to why we don't consider PHVs.  And this
comment will give them some clues.  This is just like how we explain why
we need not worry about LATERAL nor PHVs in is_simple_values().

Thanks
Richard

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18209: New connection is waiting for ProcArrayLock lock when execute a stored procedure concurrently
Next
From: PG Bug reporting form
Date:
Subject: BUG #18210: libpq: PQputCopyData sometimes fails in non-blocking mode over GSSAPI encrypted connection