duyf created SPARK-31132:
----------------------------
Summary: receive_time<>'' Optimized Logical Plan is null
Key: SPARK-31132
URL: https://issues.apache.org/jira/browse/SPARK-31132
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 2.3.1
Reporter: duyf
receive_time='2020-02-10'；
SQL：
select case when receive_time<>''
then 1 else 0 end as tt
from xxx.xxx
where order_id=1234；
The output error is 0；
Because cast( as timestamp) is null, receive_time<>'' is false;
!image-2020-03-12-18-30-44-727.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
