[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
-
Fix wrong order of operations in inheritance_planner.
- 4a2994f055be 12.0 landed
- 0ff8f521d40f 11.0 landed