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)
