You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Lantao Jin (Jira)" <ji...@apache.org> on 2025/02/13 03:33:00 UTC

[jira] [Created] (CALCITE-6830) AVG aggregate function return wrong type

Lantao Jin created CALCITE-6830:
-----------------------------------

             Summary: 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


To reproduce (agg.iq)
```
!use post
!set outputformat mysql

SELECT avg(deptno) as a FROM emp;
```
Should return 22.1429, but returns 22.
This behavior is different from other databases.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)