Horton

Re: BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andre Lin <857348270@qq.com>
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>, guofenglinux <guofenglinux@gmail.com>
Date: 2022-09-05T17:19:53Z
Lists: pgsql-bugs 
"=?ISO-8859-1?B?QW5kcmUgTGlu?=" <857348270@qq.com> writes:
> &gt; After contemplating that for awhile, by far the least painful way
> &gt; seems to be to add the subLinkId to struct SubPlan.&nbsp; We can get
> &gt; away with that in the back branches as long as we add it at the
> &gt; end, since SubPlans don't get recorded in the catalogs.

> But let's assume that we manage to verify initplan/subplan by adding
> subLinkId to&nbsp;SubPlan, we still have problem. In short, the exact
> subqueryid of the new MULTIEXPR&nbsp;Param will be pain in the ass...

Well, yeah, that data structure would need to change.

			regards, tom lane

Commits

  1. Further fixes for MULTIEXPR_SUBLINK fix.