[jira] [Comment Edited] (CALCITE-4589) 'Infinity' float values fails with java.lang.ClassCastException

["Chunwei Lei (Jira)" <ji...@apache.org>]

    [ 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)