phv->phrels=replace_relid(phv->phrels,relid,subst);

phv->phrels=replace_relid(phv->phrels,ojrelid,subst);

phinfo->ph_lateral=replace_relid(phinfo->ph_lateral,relid,subst);

phinfo->ph_var->phrels=replace_relid(phinfo->ph_var->phrels,relid,subst);

Assert(!bms_is_empty(phv->phrels));

replace_varno((Node*)phv->phexpr,relid,subst);

phinfo->ph_lateral=replace_relid(phinfo->ph_lateral,relid,subst);

Assert(phv->phnullingrels==NULL);/* no need to adjust */

}

}

-> Seq Scan on emp1 c3

(7 rows)

-- Check that SJE removes references from PHVs correctly

explain (costs off)

select * from emp1 t1 left join

(select coalesce(t3.code, 1) from emp1 t2

left join (emp1 t3 join emp1 t4 on t3.id = t4.id)

on true)

on true;

QUERY PLAN

----------------------------------------------------

Nested Loop Left Join

-> Seq Scan on emp1 t1

-> Materialize

-> Nested Loop Left Join

-> Seq Scan on emp1 t2

-> Materialize

-> Seq Scan on emp1 t4

Filter: (id IS NOT NULL)

(8 rows)

-- We can remove the join even if we find the join can't duplicate rows and

-- the base quals of each side are different. In the following case we end up

-- moving quals over to s1 to make it so it can't match any rows.

EXCEPT ALL

SELECTc3.codeFROM emp1 c3;

explain (costs off)

select*from emp1 t1left join

(select coalesce(t3.code,1)from emp1 t2

left join (emp1 t3join emp1 t4ont3.id=t4.id)

on true)

on true;