You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Table reference in this query is ambiguous, and should be rejected by the planner. select t1.v1 from t1 left outer join t1 on true;
Now it can be run successfully, see the reproducer:
(It can also be reproduced if 'left outer join' is changed to 'left join' 'right join' 'right outer join')
> create table t1(v1 int);
0 row(s) fetched.
Elapsed 0.068 seconds.
> insert into t1 values (1);
+-------+
| count |
+-------+
| 1 |
+-------+
1 row(s) fetched.
Elapsed 0.054 seconds.
> select t1.v1 from t1 left outer join t1 on true;
+----+
| v1 |
+----+
| 1 |
+----+
1 row(s) fetched.
Elapsed 0.016 seconds.
> select v1 from t1 left outer join t1 on true;
Schema error: Ambiguous reference to unqualified field v1