Обсуждение: [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