Serge Rielau created SPARK-42546: ------------------------------------ Summary: SPARK-42045 is incomplete in supporting ANSI_MODE fro round() and bround() Key: SPARK-42546 URL: https://issues.apache.org/jira/browse/SPARK-42546 Project: Spark Issue Type: Bug Components: Spark Core Affects Versions: 3.3.2, 3.4.0 Reporter: Serge Rielau
under ANSI mode SPARK-42045 added error conditions insetad of silent overflows for edge cases in round() and bround(). However it appears this fix works only for the INT data type. Trying it on a e.g. SMALLINT the function still returns wrong results: {code:java} spark-sql> select round(2147483647, -1); [ARITHMETIC_OVERFLOW] Overflow. If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error.{code} {code:java} spark-sql> select round(127y, -1); -126 {code} -- 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