Ted-Jiang opened a new issue, #4241:
URL: https://github.com/apache/arrow-datafusion/issues/4241
Nice! It's quit complicated deal with `null`.
in datafsuion:
```
❯ select true or NULL ;
Plan("'Boolean OR Null' can't be evaluated because there isn't a common type
to coerce the types to")
❯ select true or FALSE ;
+---------------------------------+
| Boolean(true) OR Boolean(false) |
+---------------------------------+
| true |
+---------------------------------+
1 row in set. Query took 0.003 seconds.
❯
```
RUN in spark-sql
```
spark-sql> select true or false;
true
Time taken: 3.139 seconds, Fetched 1 row(s)
spark-sql> select true or NULL;
true
Time taken: 0.076 seconds, Fetched 1 row(s)
spark-sql> select FALSE or NULL;
NULL
Time taken: 0.06 seconds, Fetched 1 row(s)
spark-sql>
```
I think its ok get error when run `NULL or xxx`
_Originally posted by @Ted-Jiang in
https://github.com/apache/arrow-datafusion/pull/4200#discussion_r1021374351_
--
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]
