[
https://issues.apache.org/jira/browse/CALCITE-6830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17926651#comment-17926651
]
Mihai Budiu commented on CALCITE-6830:
--------------------------------------
In Calcite the result of any aggregate has the same type as the input type.
This differs from other databases, but matches some databases.
The standard does not say what the result type should be, so it's technically
not wrong.
At least the Oracle documentation seems to imply the same behavior (I don't
have one to try).
> AVG aggregate function return wrong type
> ----------------------------------------
>
> Key: CALCITE-6830
> URL: https://issues.apache.org/jira/browse/CALCITE-6830
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.39.0
> Reporter: Lantao Jin
> Priority: Major
>
> To reproduce (agg.iq)
> {code:java}
> !use post
> !set outputformat mysql
> SELECT avg(deptno) as a FROM emp;
> {code}
> Should return 22.1429, but returns 22.
> This behavior is different from other databases.
> Since the AVG agg with integer argument returns wrong type, the behaviors of
> var_pop, var_samp, stddev_pop, stddev_samp and stddev are wrong either.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
