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.
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 |