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
