| 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
| 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 |