[CALCITE-5604] Avg function should infer correct data type

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Fix Version/s: 1.35.0
• Component/s: core
• Assignee: Unassigned
• Reporter: logan.zheng
• Created: 22/Mar/23 12:02
• Updated: 14/Jul/23 05:50
• Resolved: 22/Mar/23 20:40

Description

Currently,when the avg input is int type,the return type is int type, but the correct type is float

RelDataTypeSystemImpl

// code placeholder
@Override public RelDataType deriveAvgAggType(RelDataTypeFactory typeFactory,
    RelDataType argumentType) {
  return argumentType;
} 

Issue Links

• duplicates: CALCITE-1945 Allow custom return types for AVG/VARIANCE/STDDEV/COVAR