Serge Rielau created SPARK-41668:
------------------------------------
Summary: DECODE function returns wrong results when passed NULL
Key: SPARK-41668
URL: https://issues.apache.org/jira/browse/SPARK-41668
Project: Spark
Issue Type: Bug
Components: Spark Core
Affects Versions: 3.1.2
Reporter: Serge Rielau
The DECODE function was implemented for Oracle compatibility. It works similar
to CASE expression, but it is supposed to have one major difference: NULL ==
NULL
[https://docs.oracle.com/database/121/SQLRF/functions057.htm#SQLRF00631]
The Spark implementation does not observe this however:
select decode(null, 6, 'Spark', NULL, 'SQL', 4, 'rocks');
NULL
The result is supposed to be 'SQL'
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
