[CALCITE-4589] 'Infinity' float values fails with java.lang.ClassCastException

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 1.17.0
• Component/s: jdbc-driver
• Assignee: Unassigned
• Reporter: Anton Antonenko
• Created: 23/Apr/21 10:50
• Updated: 28/Feb/24 06:03

Description

We're using avatica JDBC driver for obtaining data from Apache Druid.

We have a float column that has an 'Infinity' value.

{"Right":"Infinity"} {"Right":0} {"Right":0.02}

It fails with the following exception:

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]

 
 
 
 

Issue Links

• relates to: CALCITE-4462 `ROUND` SQL function throws exception on Infinite or NaN arguments
• relates to: CALCITE-5827 Add IS_INF and IS_NAN functions (enabled in BigQuery library)