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

   ### Describe the bug
   
   datafusion-cli is compiled from the latest main commit 
https://github.com/apache/datafusion/commit/d19bf524e384bc24e509c70f1806b6f330829529
   
   ```sql
   -- Setup
   
   -- Tables
   CREATE TABLE t0 (id INT, flag BOOLEAN);
   CREATE TABLE t1 (id INT);
   CREATE TABLE t2 (id INT);
   
   -- Tiny data (values don’t matter for planning/binding)
   INSERT INTO t0 VALUES (1, TRUE);
   INSERT INTO t1 VALUES (10);
   INSERT INTO t2 VALUES (100);
   ```
   
   ```sh
   DataFusion CLI v49.0.2
   
   > SELECT *
   FROM t0
   RIGHT ANTI JOIN t1 ON TRUE
   RIGHT ANTI JOIN t2 ON t0.flag;
   
   Schema error: No field named t0.flag. Valid fields are t1.id, t2.id.
   ```
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   This query seems valid to me, it should be runnable
   
   ### 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