No need to reply the below mail. I am able to generate the scenario.
One of them is basically when there is an expression involving relations on one side and Var on other side. Select * from t1,t2 where t1.c1 + t2.c2 = t1.c3; From: Amit Kapila [mailto:amit.kap...@huawei.com] Sent: Thursday, April 19, 2012 7:37 AM To: 'PostgreSQL-development' Subject: clarification for generate join implied equalities In function generate_join_implied_equalities_normal(), in which kind of query it can have all three outer_members, inner_members, new_members set? There is handling related to that in the same function down which I wanted to understand.
