[DRILL-2463] Implement JDBC mapping of SQL NULL for ResultSet.getXxx() methods

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Client - JDBC
• Assignee: Daniel Barclay
• Reporter: Daniel Barclay
• Created: 15/Mar/15 05:04
• Updated: 01/May/15 20:13
• Resolved: 27/Mar/15 22:00

Description

Fix AvaticaDrillSqlAccessor to implement mapping of SQL NULL to dummy primitive values (e.g,., returning 0 for ResultSet.getInt(...)).
Fix SqlAccessors template to implement mapping of SQL NULL to null pointers (e.g., returning null from ResultSet.getString(...).)

Issue Links

• blocks: DRILL-2465 Fix multiple DatabaseMetaData.getColumns() bugs (some)
• is related to: DRILL-2472 JDBC : ResultSet.wasNull should give proper error message when a user tries to call it before calling getXXX method
• is related to: DRILL-2471 JDBC : ResultSet.getXXX should return 0 when we encounter null for primitives which are numeric
• is related to: DRILL-2603 Review, resolve NULL checks/isNull()/null around vectors, accessors, JDBC SQLAccessor, etc.
• relates to: DRILL-2091 NPE in AbstractSqlAccessor
• supercedes: DRILL-2136 NullableIntAccessor's isNull(...) never returns true
• supercedes: DRILL-2464 JDBC : ResultSet.wasNull always returns false for all datatypes