}

}

foreach(l,root->join_info_list)

{

SpecialJoinInfo*sjinfo= (SpecialJoinInfo*)lfirst(l);

sjinfo->min_lefthand=bms_del_member(sjinfo->min_lefthand,relid);

sjinfo->min_righthand=bms_del_member(sjinfo->min_righthand,relid);

sjinfo->syn_lefthand=bms_del_member(sjinfo->syn_lefthand,relid);

sjinfo->syn_righthand=bms_del_member(sjinfo->syn_righthand,relid);

}

Seq Scan on a

(1 row)

-- check optimization of outer join within another special join

explain (costs off)

select id from a where id in (

select b.id from b left join c on b.id = c.id

);

QUERY PLAN

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

Hash Semi Join

Hash Cond: (a.id = b.id)

-> Seq Scan on a

-> Hash

-> Seq Scan on b

(5 rows)

rollback;

create temp table parent (k int primary key, pd int);

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parent_pkey" for table "parent"

SELECT a.*FROM aLEFT JOIN (bleft join conb.c_id=c.id)

ON (a.b_id=b.id);

explain (costs off)

select idfrom awhere idin (

selectb.idfrom bleft join conb.id=c.id

);

rollback;

create temp table parent (kintprimary key, pdint);