[CALCITE-5181] SUM aggregate function return wong result

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.30.0
• Component/s: core
• Assignee: Unassigned
• Reporter: xiong duan
• Created: 06/Jun/22 03:29
• Updated: 07/Jun/22 08:19

Description

To reproduce(dummy.iq):

!use scott
!set outputformat mysql

SELECT sum(empno) from "scott".emp; 

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.

Issue Links

• is related to: CALCITE-845 Derive SUM’s return type by a customizable policy