2010YOUY01 opened a new issue, #11408: URL: https://github.com/apache/datafusion/issues/11408
### Describe the bug 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 ``` ### To Reproduce _No response_ ### Expected behavior _No response_ ### Additional context found by SQLancer https://github.com/apache/datafusion/issues/11030 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
