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