[
https://issues.apache.org/jira/browse/DRILL-6710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16598471#comment-16598471
]
ASF GitHub Bot commented on DRILL-6710:
---------------------------------------
vvysotskyi commented on issue #1453: DRILL-6710: Disallow negative scale for
decimal data type
URL: https://github.com/apache/drill/pull/1453#issuecomment-417605255
Thanks for the review!
Currently, such behavior of aggregate functions cannot be fixed because
Drill does not know the input type of the function and rewrites it using `SUM`
and `COUNT` aggregate functions. For regular types, it is ok, since results of
these intermediate agg calls may be reused, but for decimals due to type
inference rules, intermediate calculations on the results of agg calls may
cause overflow.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> Disallow negative scale for VarDecimal
> --------------------------------------
>
> Key: DRILL-6710
> URL: https://issues.apache.org/jira/browse/DRILL-6710
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 1.14.0
> Reporter: Robert Hou
> Assignee: Volodymyr Vysotskyi
> Priority: Major
> Labels: ready-to-commit
> Fix For: 1.15.0
>
>
> Query is:
> select cast('999999999999999999' as decimal(18,0)) +
> cast('9999999999999999999999999999999999999' as decimal(38,0)) from data
> limit 1
> This is the error I get when my test program calls SQLExecDirect:
> The driver reported the following diagnostics whilst running SQLExecDirect
> HY000:1:40140:[MapR][Support] (40140) Scale can't be less than zero.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
