[DRILL-2450] JDBC : DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Client - JDBC
• Assignee: Daniel Barclay
• Reporter: Rahul Kumar Challapalli
• Created: 13/Mar/15 18:52
• Updated: 04/May/15 23:45
• Resolved: 27/Mar/15 22:07

Description

git.commit.id.abbrev=e92db23

DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set. This is also screwing up the order in which other fields are returned.

Below is the column size returned by postgres for different data types. Though its specific to the data, I am just adding it here

int8 : 19   (this is a bigint column)
bool:1
date:13
float8:17  (this is a double column)
float8:17 (this is a float column)
int4 : 10
time:15
timestamp : 29
varchar : 50

Below are few things an analytic tool might use which are currently not working because of this :

DECIMAL_DIGITS : 9
NULLABLE : 11
REMARKS : 12

Issue Links

• is part of: DRILL-2465 Fix multiple DatabaseMetaData.getColumns() bugs (some)
• is part of: DRILL-2420 [umbrella] Identify, fix DatabaseMetaData.getColumns() bugs