[DRILL-2128] DatabaseMetaData.getColumns()'s DATA_TYPE has wrong type

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Client - JDBC
• Assignee: Daniel Barclay
• Reporter: Daniel Barclay
• Created: 31/Jan/15 00:14
• Updated: 01/May/15 20:07
• Resolved: 15/Mar/15 19:48

Description

The DATA_TYPE column in the result set returned by DatabaseMetaData.getColumns(...) contains type names instead of integer type codes from java.sql.Types.

Additionally, column TYPE_NAME is missing.

(See the result set table description in http://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getColumns-java.lang.String-java.lang.String-java.lang.String-java.lang.String-.)

Issue Links

• Is contained by: DRILL-2436 [umbrella] Implement JDBC enough for relevant tools
• Is contained by: DRILL-2420 [umbrella] Identify, fix DatabaseMetaData.getColumns() bugs
• relates to: DRILL-2465 Fix multiple DatabaseMetaData.getColumns() bugs (some)