[DRILL-2471] JDBC : ResultSet.getXXX should return 0 when we encounter null for primitives which are numeric

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Client - JDBC
• Assignee: Daniel Barclay
• Reporter: Rahul Kumar Challapalli
• Created: 15/Mar/15 23:51
• Updated: 05/May/15 00:01
• Resolved: 27/Mar/15 22:08

Description

git.commit.id.abbrev=7b4c887

I used the below query through JDBC to see how it behaves. From sqlline we get back all nulls

select cast(null as int) as int_null, cast(null as bigint) as bigint_null, cast(null as date) as date_null, cast(null as time) time_null, cast(null as timestamp) timestamp_null, cast(null as varchar) as varchar_null, cast(null as double) as double_null, cast(null as float) as float_null, cast(null as boolean) as boolean_null from dfs.jdbctesting.`fewtypes_null.parquet`

I used the below code to access the results

while (rs.next()) {
    System.out.print("  " + rs.getInt(1));
    System.out.print("  " + rs.getLong(2));
    System.out.print("      " + rs.getDate(3));
    System.out.print("      " + rs.getTime(4));
    System.out.print("      " + rs.getTimestamp(5));
    System.out.print("      " + rs.getString(6));
    System.out.print("      " + rs.getDouble(7));
     System.out.print("      " + rs.getFloat(8));
}

Output :

	7	4689679848943082537	null	null	null		-3.290061219836685E278	6.833468E-39
	892875088	4693955415459489645	null	null	null		-3.95183706712737E-209	6.83356E-39
	155464248	4687298138466757168	null	null	null		-6.25777451781332E89	6.853372E-39
	1342177280	4791877540239403909	null	null	null		1.1616051025384076E-19	6.85333E-39
	961823793	4648967379092714291	null	null	null		-1.566140588249918E-294	6.853375E-39
	1395995696	4665039317688404410	null	null	null		-1.2019953071460916E-255	6.853377E-39
	9	4739979635665875763	null	null	null		2.0158752237719652E142	6.853885E-39
	1413755216	4681520666516803027	null	null	null		9.5367431749203E-10	6.853843E-39
	808464441	4681489713615213691	null	null	null		1.5839247263595919E-196	6.853887E-39
	2643	4706865145145752289	null	null	null		-2.640804284464335E199	6.853888E-39
	808538112	4680740055935877120	null	null	null		6.805647344887834E38	6.855466E-39
	809063492	4680120333056896873	null	null	null		-6.330130140122477E-128	6.855469E-39
	223555632	4694820525793932739	null	null	null		7.131979894486345E177	6.874924E-39
	1342177280	4694805443005237533	null	null	null		-2.4466921838949077E-91	6.875437E-39
	961823793	4710968886936375132	null	null	null		3.4645199782253463E-9	6.875952E-39
	775238704	4701502231015057932	null	null	null		4.4671552526292066E147	6.854837E-39
	1395666993	4663911482860999226	null	null	null		-1.7310953463334223E41	6.85488E-39
	5	4724388908060135916	null	null	null		-1.7469523604389314E-85	6.85492E-39
	844706128	4680757843285235466	null	null	null		4.997003201540759E257	6.854851E-39
	845	4665966412149049786	null	null	null		-1.8661194612154757E-24	6.856876E-39
	1496469504	4710000304825743442	null	null	null		6.722218728220181E89	6.854963E-39

In the above output, we should make sure drill returns 0 for numeric types

Issue Links

• relates to: DRILL-2463 Implement JDBC mapping of SQL NULL for ResultSet.getXxx() methods