Re: [sqlsmith] Failed assertion in parallel worker in ExecInitSubPlan

Hi,

just caught another InitPlan below Gather with the recent patches in
(master as of 4cc6a3f). Recipe below.

regards,
andreas

set max_parallel_workers_per_gather = 2;
set min_parallel_relation_size = 0;
set parallel_setup_cost = 0;
set parallel_tuple_cost = 0;

explain select 1 from
public.quad_point_tbl as ref_0,
lateral (select
ref_0.p as c3,
sample_0.d as c5
from
public.nv_child_2010 as sample_0
left join public.mvtest_tvv as ref_1
on ('x'< (select contype from pg_catalog.pg_constraint limit 1))
limit 82) as subq_0;

-- QUERY PLAN
-- --------------------------------------------------------------------------------------------------------
-- Gather (cost=0.19..13727.52 rows=902246 width=4)
-- Workers Planned: 2
-- -> Nested Loop (cost=0.19..13727.52 rows=902246 width=4)
-- -> Parallel Seq Scan on quad_point_tbl ref_0 (cost=0.00..105.85 rows=4585 width=16)
-- -> Limit (cost=0.19..1.33 rows=82 width=20)
-- InitPlan 1 (returns $0)
-- -> Limit (cost=0.00..0.19 rows=1 width=1)
-- -> Gather (cost=0.00..10.22 rows=54 width=1)
-- Workers Planned: 2
-- -> Parallel Seq Scan on pg_constraint (cost=0.00..10.22 rows=22 width=1)
-- -> Seq Scan on nv_child_2010 sample_0 (cost=0.00..35.50 rows=2550 width=20)