[CALCITE-580] Average aggregation on an Integer column throws java.lang.ClassCastException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0-incubating
• Assignee: Julian Hyde
• Reporter: Low Chin Wei
• Created: 30/Jan/15 04:39
• Updated: 23/Mar/15 08:08
• Resolved: 10/Feb/15 19:08

Description

There are 2 Integer columns: a, c in table abc.

While running the following sql, it throw the ClassCastException:
select a, avg(c) as agg from abc group by a

Exception in thread "main" java.lang.ClassCastException: java.lang.Long incompatible with java.lang.Integer
at org.apache.calcite.avatica.util.AbstractCursor$IntAccessor.getInt(AbstractCursor.java:460)
at org.apache.calcite.avatica.AvaticaResultSet.getInt(AvaticaResultSet.java:311)

The generated code that I think causing the issue, it try to cast the result to long.
public Object current() {
final Object[] current = (Object[]) inputEnumerator.current();
return new Object[]

{ current[0], (long) org.apache.calcite.runtime.SqlFunctions.toInt(current[1]) / org.apache.calcite.runtime.SqlFunctions.toLong(current[2])}

;
}