Re: GROUP BY + join regression in 7.3

Tom Lane wrote:
> Just out of curiosity ---

Here's what I get:

select * from t1
f1 f2
----------- -----------
1 1
2 2

(2 row(s) affected)

select * from t2
f2 f3
----------- -----------
1 3

(1 row(s) affected)

select t1.f2 from t2 right join t1 on t1.f2 = t2.f2 group by f2
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'f2'.

select f2 from t2 right join t1 on t1.f2 = t2.f2 group by t1.f2
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'f2'.

select f2 from t2 right join t1 on t1.f2 = t2.f2 group by f2
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'f2'.
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'f2'.

select t1.f2 from t2 right join t1 on t1.f2 = t2.f2 group by t1.f2
f2
-----------
1
2

(2 row(s) affected)

Any other variations you want to see?

Joe