[CALCITE-4600] ClassCastException retrieving from an ARRAY that has DATE, TIME or TIMESTAMP 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: 10/May/21 00:57
• Updated: 13/Oct/21 23:38
• Resolved: 04/Oct/21 18:11

Description

cases to reproduce

select array[current_date];
select array[cast('1900-1-1' as date)];
select array[current_timestamp];
select array[current_time];

each query fails with ClassCastException mentioned below.
It seems the reason is that date/time/timestamp could be both int/long and java_sql_*.

class java.sql.Date cannot be cast to class java.lang.Number (java.sql.Date is in module java.sql of loader 'platform'; java.lang.Number is in module java.base of loader 'bootstrap')
java.lang.ClassCastException: class java.sql.Date cannot be cast to class java.lang.Number (java.sql.Date is in module java.sql of loader 'platform'; java.lang.Number is in module java.base of loader 'bootstrap')
	at org.apache.calcite.avatica.util.AbstractCursor$NumberAccessor.getNumber(AbstractCursor.java:722)
	at org.apache.calcite.avatica.util.AbstractCursor$DateFromNumberAccessor.getString(AbstractCursor.java:928)
	at org.apache.calcite.avatica.util.ArrayImpl.toString(ArrayImpl.java:62)
	at org.apache.calcite.avatica.util.AbstractCursor$ArrayAccessor.getString(AbstractCursor.java:1365)
	at org.apache.calcite.avatica.AvaticaResultSet.getString(AvaticaResultSet.java:239)

Issue Links

• is related to: CALCITE-4602 ClassCastException retrieving from ARRAY that has mixed INTEGER and DECIMAL elements
• relates to: CALCITE-4762 Upgrade Calcite to Avatica 1.19
• links to: Avatica PR 154
• links to: GitHub Pull Request #2548