[
https://issues.apache.org/jira/browse/SPARK-41668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gengliang Wang updated SPARK-41668:
-----------------------------------
Fix Version/s: 3.3.2
3.4.0
> 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.2.0, 3.2.1, 3.3.0, 3.2.2, 3.3.1
> Reporter: Serge Rielau
> Assignee: Gengliang Wang
> Priority: Major
> Fix For: 3.2.3, 3.3.2, 3.4.0
>
>
> 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]
