Marco Gaido created SPARK-28235: ----------------------------------- Summary: Decimal sum return type Key: SPARK-28235 URL: https://issues.apache.org/jira/browse/SPARK-28235 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 3.0.0 Reporter: Marco Gaido
Our implementation of decimal operations follows SQLServer behavior. As per https://docs.microsoft.com/it-it/sql/t-sql/functions/sum-transact-sql?view=sql-server-2017, the result of sum operation should be `DECIMAL(38, s)` while currently we are setting it to `DECIMAL(10 + p, s)`. This means that with large datasets, we may incur in overflow, even though we may have been able to represent the value with higher precision and SQLServer returns correct results in that case. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org