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

Andreas Seltenreich <seltenreich@gmx.de>

From: Andreas Seltenreich <seltenreich@gmx.de>
To: pgsql-hackers@postgresql.org
Date: 2018-08-11T15:45:43Z
Lists: pgsql-hackers
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;


Commits

  1. Fix wrong order of operations in inheritance_planner.