[jira] [Created] (CALCITE-580) Average aggregation on an Integer column throw java.lang.ClassCastException

[Low Chin Wei (JIRA)]

Low Chin Wei created CALCITE-580:
------------------------------------

             Summary: Average aggregation on an Integer column throw 
java.lang.ClassCastException
                 Key: CALCITE-580
                 URL: https://issues.apache.org/jira/browse/CALCITE-580
             Project: Calcite
          Issue Type: Bug
            Reporter: Low Chin Wei
            Assignee: Julian Hyde


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])};
}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)