xiong duan created CALCITE-5181:
-----------------------------------
Summary: Sum aggregate function return wong result
Key: CALCITE-5181
URL: https://issues.apache.org/jira/browse/CALCITE-5181
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.30.0
Reporter: xiong duan
To reproduce(dummy.iq):
{code:java}
!use scott
!set outputformat mysql
SELECT sum(empno) from "scott".emp; {code}
Should return 108172, but return -22900.
This is because RelDataTypeSystemImpl deriveSumType return a wrong datatype. We
presume when the parameter is smllInt, the return datatype stay same as the
parameter. So the result out of range.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
