XiDuo You created SPARK-39040:
---------------------------------
Summary: Respect NaNvl in EquivalentExpressions for expression
elimination
Key: SPARK-39040
URL: https://issues.apache.org/jira/browse/SPARK-39040
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.4.0
Reporter: XiDuo You
For example:
{code:java}
set spark.sql.ansi.enabled=true;
set
spark.sql.optimizer.excludedRules=org.apache.spark.sql.catalyst.optimizer.ConstantFolding;
SELECT nanvl(1, 1/0 + 1/0); {code}
We should respect the ordering of conditional expression that always evaluate
the predicate branch first, so the query above should not fail.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
