2010YOUY01 opened a new issue, #12337:
URL: https://github.com/apache/datafusion/issues/12337

   ### Describe the bug
   
   The `t1.v1` inside query's `on` clause is ambiguous, it's not clear whether 
`t1` it's referring to, such query should be rejected by the planner
   
   See reproducer in `datafusion-cli` (Compilred from latest main with `cargo 
run`, commit hash d6f3f738e)
   ```
   DataFusion CLI v41.0.0
   > create table t1(v1 int);
   
   0 row(s) fetched.
   Elapsed 0.070 seconds.
   
   > select count(*)
   from t1
   right outer join t1
   on t1.v1 > 0;
   +----------+
   | count(*) |
   +----------+
   | 0        |
   +----------+
   1 row(s) fetched.
   Elapsed 0.075 seconds.
   
   ```
   
   ### 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to