2010YOUY01 opened a new issue, #13976:
URL: https://github.com/apache/datafusion/issues/13976
### Describe the bug
Run in datafusion-cli compiled from main (commit 259443d66)
```
> select 1 where null between null and 2;
type_coercion
caused by
Error during planning: Cannot automatically convert Int64 to Null
```
### To Reproduce
_No response_
### Expected behavior
`null` should be interpreted as a missing integer, so the expression should
be valid, and the query should return empty set
```
postgres=# select 1 where null between null and 2;
?column?
----------
(0 rows)
```
### Additional context
This bug is found by the recently integrated SQLite test suite, after the
fix, all related `skipif`s can be removed from test cases in
https://github.com/apache/datafusion-testing
```
# Datafusion - Error during planning: Cannot automatically convert Int64 to
Null
skipif Datafusion
```
--
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]
