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

["Julian Hyde (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-4589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17330848#comment-17330848 ] 

Julian Hyde commented on CALCITE-4589:
--------------------------------------

I’m not sure that Infinity is a valid REAL or FLOAT value in SQL.

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