[
https://issues.apache.org/jira/browse/DRILL-6710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16597739#comment-16597739
]
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-417416127
With the change in this PR, if aggregate functions:
- `AVG`
- `STDDEV_POP`
- `STDDEV_SAMP`
- `VAR_POP`
- `VAR_SAMP`
are applied to the decimal column without cast may fail if any of the
intermediate calculations for them (all of them may be rewritten using `SUM`
and `COUNT` aggregate functions) exceeds max allowed numeric precision.
For the case, when planner knows that this column is decimal (for example,
cast to decimal is used inside agg function), they wouldn't be rewritten and
exact implementation will be used.
----------------------------------------------------------------
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
> 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)
