Tom Lane writes:
> Andreas Seltenreich <[email protected]> writes:
>> Tom Lane writes:
>>> Well, I certainly think all of these represent bugs:
>>>> 3 | ERROR: plan should not reference subplan's variable
>>>> 2 | ERROR: failed to assign all NestLoopParams to plan nodes
>
>> These appear to be related. The following query produces the former,
>> but if you replace the very last reference of provider with the literal
>> 'bar', it raises the latter error.
>
> Fixed that, thanks for the test case!
I haven't seen the former since your commit, but there recently were
some instances of the latter. The attached queries all throw the error
against master at 8752bbb.
regards,
Andreas
-- ERROR: failed to assign all NestLoopParams to plan nodes
select
subq_19608926.c0 as c0,
rel_124211605.objname as c1
from
(select
rel_124211602.numeric_precision as c0
from
information_schema.sequences as rel_124211602
where EXISTS (
select
rel_124211603.unique_constraint_name as c0
from
information_schema.referential_constraints as rel_124211603
where rel_124211603.unique_constraint_schema is not NULL)) as
subq_19608926
left join public.tab1 as rel_124211604
on (subq_19608926.c0 = rel_124211604.a )
right join pg_catalog.pg_seclabels as rel_124211605
right join public.phone as rel_124211606
on (rel_124211605.objtype = rel_124211606.comment )
on (rel_124211604.b = rel_124211605.objtype )
inner join public.bt_i4_heap as rel_124211729
inner join public.bt_i4_heap as rel_124211730
on (rel_124211729.random = rel_124211730.seqno )
on (subq_19608926.c0 = rel_124211730.seqno )
where rel_124211606.comment = rel_124211604.b;
-- ERROR: failed to assign all NestLoopParams to plan nodes
select
subq_53656269.c0 as c0
from
(select
rel_339945676.id3c as c0
from
public.rule_and_refint_t3 as rel_339945676
where rel_339945676.data !~~ rel_339945676.data) as subq_53656269
inner join public.dropcolumn as rel_339945677
on (subq_53656269.c0 = rel_339945677.b )
inner join public.bt_name_heap as rel_339945678
left join public.rtest_order2 as rel_339945705
inner join information_schema.sequences as rel_339945706
on (rel_339945705.a = rel_339945706.numeric_precision )
inner join public.num_result as rel_339945707
on (rel_339945705.b = rel_339945707.id1 )
on (rel_339945678.random = rel_339945706.numeric_precision )
on (rel_339945677.b = rel_339945706.numeric_precision )
where rel_339945678.seqno ~* rel_339945705.c
fetch first 45 rows only;
-- ERROR: failed to assign all NestLoopParams to plan nodes
select
rel_273437910.name as c0,
rel_273437908.sequence_catalog as c1,
rel_273437865.b as c2,
rel_273437910.location as c3,
rel_273437864.id2c as c4,
rel_273437908.start_value as c5
from
public.rule_and_refint_t2 as rel_273437864
inner join public.ruletest_tbl as rel_273437865
on (rel_273437864.id2c = rel_273437865.a )
inner join information_schema.sequences as rel_273437908
inner join public.rules_log as rel_273437909
on (rel_273437908.numeric_precision_radix = rel_273437909.f1 )
right join public.emp as rel_273437910
on (rel_273437909.tag = rel_273437910.name )
on (rel_273437865.a = rel_273437908.numeric_precision )
where rel_273437909.tag !~* rel_273437909.tag
fetch first 110 rows only;
-- ERROR: failed to assign all NestLoopParams to plan nodes
select
rel_156464410.minimum_value as c0
from
public.rule_and_refint_t1 as rel_156464330
inner join public.rules_src as rel_156464331
on (rel_156464330.id1b = rel_156464331.f1 )
inner join public.main_table as rel_156464401
inner join pg_catalog.pg_file_settings as rel_156464402
left join public.person as rel_156464409
inner join information_schema.sequences as rel_156464410
on (rel_156464409.age = rel_156464410.numeric_precision )
on (rel_156464402.sourceline = rel_156464409.age )
on (rel_156464401.a = rel_156464402.sourceline )
on (rel_156464331.f1 = rel_156464410.numeric_precision )
where rel_156464402.sourcefile @@ rel_156464409.name
fetch first 155 rows only;
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
