[
https://issues.apache.org/jira/browse/DRILL-834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14011729#comment-14011729
]
Chun Chang commented on DRILL-834:
----------------------------------
I referred to JIRA833 for more information.
For example, if the data type is bigint, and one of the row contains the
maximum number for bigint, the following query will overflow to negative and
gives wrong result:
select sum(c_bigint) from table_name;
> The sum() operator should automatically promote to a type that can hold the
> sum
> -------------------------------------------------------------------------------
>
> Key: DRILL-834
> URL: https://issues.apache.org/jira/browse/DRILL-834
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Operators
> Reporter: Chun Chang
> Assignee: Chun Chang
> Priority: Blocker
>
> The sum() of a type may exceed the type range, hence, should implicitly and
> automatically promote to a type that can hold the sum. Currently, the sum
> just overflows into negative (see JIRA833) and gives wrong result.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
