Re: [sqlsmith] ERROR: plan should not reference subplan's variable

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [sqlsmith] ERROR: plan should not reference subplan's variable
Date: 2018-08-11 19:15:25
Message-ID: 5475.1534014925@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andreas Seltenreich <seltenreich(at)gmx(dot)de> writes:
> sqlsmith caused another internal error while testing REL_11_STABLE at
> 1b9d1b08fe. The query below on the regression DB yields "plan should
> not reference subplan's variable" for me.

Thanks for the report. Seems to be wrong order of operations in
inheritance_planner: it shouldn't be appending extra SUBQUERY_RTE copies
to a subroot that it's going to use as a parent for later iterations.
That results in too many copies of the subqueries and screwed-up RTE
numbering in the children.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2018-08-11 19:47:05 Re: Facility for detecting insecure object naming
Previous Message Pavel Stehule 2018-08-11 18:46:34 Re: [HACKERS] proposal: schema variables