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