Tom Lane writes:
> Andreas Seltenreich <seltenreich@gmx.de> writes:
>> I've added new grammar rules to sqlsmith and improved some older ones.
>> This was rewarded with a return of "failed to generate plan" errors.
>
> I believe I've dealt with these cases now. Thanks for the report!
I no longer see "failed to build any n-way joins" after pulling, but
there are still instances of "could not devise a query plan". Samples below.
regards,
Andreas
select ref_1.aa as c0, subq_1.c1 as c1, coalesce(ref_1.class, ref_1.class) as c2, subq_1.c0 as c3
from (select subq_0.c1 as c0, coalesce(sample_0.a, sample_1.i) as c1from public.rtest_t9 as sample_0 tablesample
bernoulli(5.6) inner join public.iportaltest as sample_1 tablesample bernoulli (9.8) on (sample_0.a = sample_1.i
), lateral (select sample_1.d as c0, ref_0.a as c1, sample_1.p as c2, ref_0.a as c3, ref_0.a as c4,
sample_0.bas c5, sample_1.i as c6 from public.rtest_view2 as ref_0 where sample_0.b = sample_0.b
fetchfirst 93 rows only) as subq_0where sample_0.b ~<=~ sample_0.b) as subq_1 right join public.e_star as ref_1 on
(subq_1.c0= ref_1.aa )
where ref_1.cc < ref_1.cc
fetch first 59 rows only;
select sample_69.tmpllibrary as c0, coalesce(sample_69.tmplname, sample_69.tmplname) as c1, subq_33.c0 as c2
from (select coalesce(ref_53.provider, sample_68.typdefault) as c0from pg_catalog.pg_type as sample_68 tablesample
bernoulli(6.9) inner join pg_catalog.pg_shseclabel as ref_53 on (sample_68.typowner = ref_53.objoid ), lateral
(select sample_68.typcategory as c0, ref_54.speaker as c1, ref_54.speaker as c2 from
public.test_range_exclas ref_54 where (ref_53.label >= ref_53.provider) and (ref_53.label !~* ref_53.provider)
fetch first 143 rows only) as subq_32where ref_53.label ~>~ ref_53.label) as subq_33 right join
pg_catalog.pg_pltemplateas sample_69 tablesample bernoulli (9.8) on (subq_33.c0 = sample_69.tmplhandler )
where sample_69.tmplvalidator ~ subq_33.c0
fetch first 131 rows only;