[DRILL-2519] INFORMATION_SCHEMA.COLUMNS is missing <interval_qualifier> info

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 1.2.0
• Component/s: Metadata
• Assignee: Daniel Barclay
• Reporter: Daniel Barclay
• Created: 23/Mar/15 17:07
• Updated: 05/Jun/15 17:55
• Resolved: 05/Jun/15 17:55

Description

The INFORMATION_SCHEMA.COLUMNS table does not have all data from the <interval_qualifier> of an INTERVAL type descriptor.

In particular, it does not have enough information to implement DatabaseMetaData.getColumns()'s COLUMN_SIZE or DECIMAL_DIGITS columns for INTERVAL types.

1. It does not have the starting and ending units, so we can't distinguish between INTERVAL HOUR TO MINUTE and INTERVAL HOUR TO SECOND--which have different lengths (COLUMN_SIZE) because their string representations have different fields.

2. It does not have the fractional seconds precision.

Issue Links

• blocks: DRILL-2420 [umbrella] Identify, fix DatabaseMetaData.getColumns() bugs
• Is contained by: DRILL-2522 Implement INFORMATION_SCHEMA.* enough for relevant tools [bug]
• is depended upon by: DRILL-2531 getColumns() not right/implemented for INTERVAL types
• is depended upon by: DRILL-2763 [umbrella] Implement INFORMATION_SCHEMA.COLUMNS enough for relevant tools
• is related to: DRILL-2530 getColumns() doesn't return right COLUMN_SIZE for INTERVAL types
• is superceded by: DRILL-3216 Fix existing(+) INFORMATION_SCHEMA.COLUMNS columns
• relates to: DRILL-2436 [umbrella] Implement JDBC enough for relevant tools
• relates to: DRILL-2465 Fix multiple DatabaseMetaData.getColumns() bugs (some)