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
Look like test nestedjoin_with_alias() also is wrong
explain verbose select*from ((select1as a, 2as b) c INNER JOIN (select1as a, 3as d) e onc.a=e.a) f;
+------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------+
| plan_type | plan |
+------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------+
| initial_logical_plan | Projection: c.a, c.b, e.a, e.d |
| | Inner Join: c.a=e.a |
| | SubqueryAlias: c |
| | Projection: Int64(1) AS a, Int64(2) AS b |
| | EmptyRelation |
| | SubqueryAlias: e |
| | Projection: Int64(1) AS a, Int64(3) AS d |
| | EmptyRelation |
I think this sql should be wrong, when we select f.a from it, f.a exist two.
pg
selectf.afrom ((select1as a, 2as b) c INNER JOIN (select1as a, 3as d) e onc.a=e.a) f;
Help: db error: ERROR: column reference "a" is ambiguous
sqlite
select*from ((select1as a, 2as b) c INNER JOIN (select1as a, 3as d) e onc.a=e.a) f;
ambiguous column name: a
Activity
jackwener commentedon Dec 2, 2022
Look like test
nestedjoin_with_alias()also is wrongI think this sql should be wrong, when we
select f.a from it,f.aexist two.jackwener commentedon Dec 2, 2022
same problem with #4454