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

   ### Describe the bug
   
   Run following statements in datafusion-cli to reproduce:
   ```
   CREATE TABLE t1 (v0 BIGINT);
   CREATE TABLE t2 (v0 DOUBLE); 
   CREATE TABLE t3 (v0 DOUBLE); 
   INSERT INTO t1 (v0) VALUES (-503661263); 
   INSERT INTO t2 (v0) VALUES (-1.6635639473878496E308); 
   INSERT INTO t3 (v0) VALUES (0.05112015193508901);
   
   select t3.v0, t2.v0 from t1,t2,t3 where t3.v0 >= t1.v0;
   ```
   Error Message:
   ```
   Execution error: Fail to build join indices in NestedLoopJoinExec, 
error:Arrow error: Invalid argument error: column types must match schema 
types, expected Int64 but found Float64 at column index 0
   ```
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   _No response_
   
   ### Additional context
   
   This issue seem to report similar error message, I'm not sure if they are 
related https://github.com/apache/datafusion/issues/9254
   
   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

Reply via email to