FW: clarification for generate join implied equalities

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: FW: clarification for generate join implied equalities
Date: 2012-04-19 02:38:50
Message-ID: 001f01cd1dd5$8e4ad1c0$aae07540$%kapila@huawei.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(dot)kapila(at)huawei(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message i+pgbugs 2012-04-19 10:02:35 BUG #6602: concurrent psql session clobbers history
Previous Message Jon Plotky 2012-04-19 01:27:15 Re: BUG #6601: Inconsistent behavior of ALTER TABLE ADD COLUMN