[I] Filter operation (GT AND LT) on Float type result error [datafusion]

[via GitHub]

loloxwg opened a new issue, #13078:
URL: https://github.com/apache/datafusion/issues/13078

   ### Describe the bug
   
   ### SQL Query: Drone Information Table Operations
   
   #### Create Table
   ```sql
   CREATE TABLE droneinfo_test_where (ts timestamp, signal_strength INT, speed 
FLOAT, calibration_method STRING);
   ```
   
   #### Insert Data
   ```sql
   INSERT INTO droneinfo_test_where VALUES(NOW(), 80, 500.2, 'method2'); 
   ```
   
   #### Select Query
   ```sql
   SELECT * FROM droneinfo_test_where WHERE signal_strength >= 80 AND speed <= 
500.2;
   ```
   
   #### Expected Result
   ```
   +----+-----------------+-------+--------------------+
   | ts | signal_strength | speed | calibration_method  |
   +----+-----------------+-------+--------------------+
   |    |        80       | 500.2 | method2            |
   +----+-----------------+-------+--------------------+
   ```
   
   This result should match the output in DuckDB.
   
   ### To Reproduce
   
   run datadusion-cli
   input
   CREATE TABLE droneinfo_test_where (ts timestamp, signal_strength INT, speed 
FLOAT, calibration_method STRING);
   
   INSERT INTO droneinfo_test_where VALUES(NOW(),80,500.2,'method2'); 
   
   SELECT * FROM droneinfo_test_where WHERE signal_strength >= 80 AND speed <= 
500.2;
   
   ### Expected behavior
   
   Same sql excute on duckdb
   
![image](https://github.com/user-attachments/assets/6e261c3f-2906-476c-a94a-43896555596a)
   
   
   ### Additional context
   
   _No response_


-- 
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