[DRILL-2452] ResultSet.getDouble should not throw an exception when the underlying type is a FLOAT

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Client - JDBC
• Assignee: Daniel Barclay
• Reporter: Rahul Kumar Challapalli
• Created: 13/Mar/15 20:55
• Updated: 07/May/15 00:46
• Resolved: 29/Apr/15 17:35

Description

git.commit.id.abbrev=e92db23

Currently when we call ResultSet.getDouble(int) and if the underlying column's type is FLOAT, we get the below exception

org.apache.drill.exec.vector.accessor.AbstractSqlAccessor$InvalidAccessException: Requesting class of type double for an object of type FLOAT4:OPTIONAL is not allowed.
	at org.apache.drill.exec.vector.accessor.AbstractSqlAccessor.getDouble(AbstractSqlAccessor.java:62)
	at org.apache.drill.exec.vector.accessor.NullableFloat4Accessor.getDouble(NullableFloat4Accessor.java:87)
	at org.apache.drill.exec.vector.accessor.BoundCheckingAccessor.getDouble(BoundCheckingAccessor.java:73)
	at org.apache.drill.jdbc.AvaticaDrillSqlAccessor.getDouble(AvaticaDrillSqlAccessor.java:101)
	at net.hydromatic.avatica.AvaticaResultSet.getDouble(AvaticaResultSet.java:233)

According to the JDBC spec we should return the double representation of the value

Issue Links

• is superceded by: DRILL-2613 Implement ResultSet.getXxx(...) number-to-number data conversions