[
https://issues.apache.org/jira/browse/CALCITE-4602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17427919#comment-17427919
]
Julian Hyde commented on CALCITE-4602:
--------------------------------------
[~Sergey Nuyanzin], By the way. You have 3 PRs that each adds a test case at
the same point in JdbcTest. Guess what? I'm hitting loads of merge conflicts.
Please don't just "stick a test case at the end".
> ClassCastException retrieving from ARRAY that has mixed INTEGER and DECIMAL
> elements
> ------------------------------------------------------------------------------------
>
> Key: CALCITE-4602
> URL: https://issues.apache.org/jira/browse/CALCITE-4602
> Project: Calcite
> Issue Type: Bug
> Components: avatica
> Affects Versions: avatica-1.17.0
> Reporter: Sergey Nuyanzin
> Assignee: Sergey Nuyanzin
> Priority: Major
> Labels: pull-request-available
> Fix For: avatica-1.19.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)
