[CALCITE-4602] ClassCastException retrieving from ARRAY that has mixed INTEGER and DECIMAL elements

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: avatica-1.17.0
• Fix Version/s: avatica-1.19.0
• Component/s: avatica
• Labels: pull-request-available
• Assignee: Sergey Nuyanzin
• Reporter: Sergey Nuyanzin
• Created: 11/May/21 11:52
• Updated: 13/Oct/21 23:37
• Resolved: 04/Oct/21 18:09

Description

Cases to reproduce: any query with array containing both int and bigdecimal elements for instance

select array[1, 1.1];
select array[1.1, 1];

which leads to 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')
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)

Issue Links

• is related to: CALCITE-4850 Wrong result retrieving from ARRAY with mixed INTEGER and DECIMAL elements
• relates to: CALCITE-4600 ClassCastException retrieving from an ARRAY that has DATE, TIME or TIMESTAMP elements
• relates to: CALCITE-4762 Upgrade Calcite to Avatica 1.19
• links to: Avatica PR 143
• links to: GitHub Pull Request #2547