[
https://issues.apache.org/jira/browse/CALCITE-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17422913#comment-17422913
]
Julian Hyde edited comment on CALCITE-4600 at 9/30/21, 5:05 PM:
----------------------------------------------------------------
I get a test failure. I've tried on JDK 11 on macOS, and JDK 8 and 11 on
Ubuntu, same result. Maybe it's my time zone.
{noformat}
FAILURE 0.0sec, org.apache.calcite.avatica.AvaticaResultSetConversionsTest >
testGetArray[26:
org.apache.calcite.avatica.AvaticaResultSetConversionsTest$DateArrayAccessorTestHelper@1e1cc417]
java.lang.AssertionError
at org.junit.Assert.fail(Assert.java:86)
at org.junit.Assert.assertTrue(Assert.java:41)
at org.junit.Assert.assertTrue(Assert.java:52)
at
org.apache.calcite.avatica.AvaticaResultSetConversionsTest$DateArrayAccessorTestHelper.testGetArray(AvaticaResultSetConversionsTest.java:628)
at
org.apache.calcite.avatica.AvaticaResultSetConversionsTest.testGetArray(AvaticaResultSetConversionsTest.java:1250)
{noformat}
[~Sergey Nuyanzin], Any chance of a fix in the next day or two? I'd like to get
this into avatica-1.19.
was (Author: julianhyde):
I get a test failure. I've tried on JDK 11 on macOS, and JDK 8 and 11 on
Ubuntu, same result. Maybe it's my time zone.
{noformat}
FAILURE 0.0sec, org.apache.calcite.avatica.AvaticaResultSetConversionsTest >
testGetArray[26:
org.apache.calcite.avatica.AvaticaResultSetConversionsTest$DateArrayAccessorTestHelper@1e1cc417]
java.lang.AssertionError
at org.junit.Assert.fail(Assert.java:86)
at org.junit.Assert.assertTrue(Assert.java:41)
at org.junit.Assert.assertTrue(Assert.java:52)
at
org.apache.calcite.avatica.AvaticaResultSetConversionsTest$DateArrayAccessorTestHelper.testGetArray(AvaticaResultSetConversionsTest.java:628)
at
org.apache.calcite.avatica.AvaticaResultSetConversionsTest.testGetArray(AvaticaResultSetConversionsTest.java:1250)
{noformat}
> ClassCastException for arrays with date/time/timestamp elements
> ---------------------------------------------------------------
>
> Key: CALCITE-4600
> URL: https://issues.apache.org/jira/browse/CALCITE-4600
> Project: Calcite
> Issue Type: Bug
> Components: avatica
> Affects Versions: avatica-1.17.0
> Reporter: Sergey Nuyanzin
> Priority: Major
> Labels: pull-request-available
> Fix For: avatica-1.19.0
>
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> cases to reproduce
> {code:sql}
> select array[current_date];
> select array[cast('1900-1-1' as date)];
> select array[current_timestamp];
> select array[current_time];
> {code}
> each query fails with {{ClassCastException}} mentioned below.
> It seems the reason is that date/time/timestamp could be both int/long and
> java_sql_*.
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
