[ https://issues.apache.org/jira/browse/SPARK-41668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-41668: ------------------------------------ Assignee: Apache Spark > 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 > Assignee: Apache Spark > Priority: Major > > 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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org