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
contypefrom 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)