[jira] [Created] (CALCITE-4602) ClassCastException for arrays with int and decimal elements within one array

["Sergey Nuyanzin (Jira)" <ji...@apache.org>]

Sergey Nuyanzin created CALCITE-4602:
----------------------------------------

             Summary: ClassCastException for arrays with int and decimal elements within one array
                 Key: CALCITE-4602
                 URL: https://issues.apache.org/jira/browse/CALCITE-4602
             Project: Calcite
          Issue Type: Bug
    Affects Versions: avatica-1.17.0
            Reporter: Sergey Nuyanzin


Cases to reproduce: any query with array containing both int and bigdecimal elements for instance
{code:sql}
select array[1, 1.1];
select array[1.1, 1];
{code}
which leads to ClassCastException
{noformat}

class java.lang.Integer cannot be cast to class java.math.BigDecimal (java.lang.Integer and java.math.BigDecimal are in module java.base of loader 'bootstrap')
java.lang.ClassCastException: class java.lang.Integer cannot be cast to class java.math.BigDecimal (java.lang.Integer and java.math.BigDecimal are in module java.base of loader 'bootstrap')
	at org.apache.calcite.avatica.util.AbstractCursor$BigDecimalAccessor.getBigDecimal(AbstractCursor.java:701)
	at org.apache.calcite.avatica.util.AbstractCursor$ArrayAccessor.convertValue(AbstractCursor.java:1338)
	at org.apache.calcite.avatica.util.AbstractCursor$ArrayAccessor.getObject(AbstractCursor.java:1299)
	at org.apache.calcite.avatica.util.AbstractCursor$ArrayAccessor.getArray(AbstractCursor.java:1352)
	at org.apache.calcite.avatica.util.AbstractCursor$ArrayAccessor.getString(AbstractCursor.java:1364)
	at org.apache.calcite.avatica.AvaticaResultSet.getString(AvaticaResultSet.java:239)
{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)