Re: BUG #17768: Assert triggered on initsplan.c - Mailing list pgsql-bugs

 

Thanks for the report!  I can reproduce this issue with the following
query.

create table t1(a int);
create table t2(a int);
create table t3(a int);
create table t4(a int);
create table t5(a int);

select * from t1, lateral (select * from t2 inner join t3 on t1.a = 1 inner join (t4 right join t5 on true) on true) as sub;

There is something wrong about postponing quals.  We are supposed to
postpone quals only from children to their parent nodes.  But here in
deconstruct_distribute we scan all the jointree nodes in depth-first
traversal order and any quals postponed by left children may be checked
against right children.  If the right subtree is an outer join as in
this example, the assertion would be triggered.

Thanks
Richard