[
https://issues.apache.org/jira/browse/CALCITE-4589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17334415#comment-17334415
]
Chunwei Lei edited comment on CALCITE-4589 at 4/28/21, 2:43 AM:
----------------------------------------------------------------
I checked PostgreSQL[1] and Oracle[2]. Both of them consider Infinity as a
valid value.
[1][https://www.postgresql.org/docs/current/datatype-numeric.html]
[2]https://docs.oracle.com/database/121/JAJDB/oracle/sql/NUMBER.html
was (Author: chunwei lei):
I checked PostgreSQL[1] and Oracle[2]. Both of them consider Infinity as a
valid value.
[1][https://www.postgresql.org/docs/current/datatype-numeric.html]
[2]https://docs.oracle.com/database/121/JAJDB/oracle/sql/NUMBER.html
> 'Infinity' float values fails with java.lang.ClassCastException
> ---------------------------------------------------------------
>
> Key: CALCITE-4589
> URL: https://issues.apache.org/jira/browse/CALCITE-4589
> Project: Calcite
> Issue Type: Bug
> Components: jdbc-driver
> Affects Versions: 1.17.0
> Reporter: Anton Antonenko
> Priority: Blocker
>
> We're using avatica JDBC driver for obtaining data from Apache Druid.
> We have a float column that has an 'Infinity' value.
> {code:java}
> {"Right":"Infinity"} {"Right":0} {"Right":0.02}{code}
> {{It fails with the following exception:}}
> {code:java}
> Caused by: java.lang.ClassCastException: class java.lang.String cannot be
> cast to class java.lang.Number (java.lang.String and java.lang.Number are in
> module java.base of loader 'bootstrap')
> Caused by: java.lang.ClassCastException: class java.lang.String cannot be
> cast to class java.lang.Number (java.lang.String and java.lang.Number are in
> module java.base of loader 'bootstrap') at
> org.apache.calcite.avatica.util.AbstractCursor$NumberAccessor.getNumber(AbstractCursor.java:722)
> ~[avatica-1.17.0.jar:1.17.0] at
> org.apache.calcite.avatica.util.AbstractCursor$BigNumberAccessor.getFloat(AbstractCursor.java:653)
> ~[avatica-1.17.0.jar:1.17.0] at
> org.apache.calcite.avatica.AvaticaResultSet.getFloat(AvaticaResultSet.java:263)
> ~[avatica-1.17.0.jar:1.17.0]{code}
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
