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