[sqlsmith] ERROR: plan should not reference subplan's variable
Hi,
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.
regards,
Andreas
delete from public.prt1_l
where
EXISTS (
select
from
public.xmltest as ref_10 ,
lateral (select
ref_10.data as c0
from
public.radix_text_tbl as ref_0,
lateral (select
ref_11.name as c0
from
public.equipment_r as ref_11
limit 134) as subq_0
limit 110) as subq_1
where public.prt1_l.c is NULL)
returning 42;
Andreas Seltenreich <seltenreich@gmx.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