[DRILL-3308] Revisit INFORMATION_SCHEMA.COLUMNS's SQL compliance.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Storage - Information Schema
• Assignee: Unassigned
• Reporter: Daniel Barclay
• Created: 18/Jun/15 00:02
• Updated: 18/Jun/15 05:31

Description

At some point, review the compliance with the SQL specification of Drill's INFORMATION_SCHEMA.COLUMNS table.

TABLE_NAME holds the original form of the identifier but might need to be uppercased here to be compliant (or possibly internal matching queries (e.g., for JDBC's getColumns(...)) could be case-insensitive).

COLUMN_NAME holds the original form of the identifier but might need to be uppercased here to be compliant (or possibly internal matching queries (e.g., for JDBC's getColumns(...)) could be case-insensitive).

MAXIMUM_CARDINALITY does not exist.

The following columns do not exist:

• CHARACTER_SET_CATALOG
• CHARACTER_SET_SCHEMA
• CHARACTER_SET_NAME
• COLLATION_CATALOG
• COLLATION_SCHEMA
• COLLATION_NAME
• DOMAIN_CATALOG
• DOMAIN_SCHEMA
• DOMAIN_NAME
• UDT_CATALOG
• UDT_SCHEMA
• UDT_NAME
• SCOPE_CATALOG
• SCOPE_SCHEMA
• SCOPE_NAME
• DTD_IDENTIFIER
• IS_SELF_REFERENCING
• IS_IDENTITY
• IDENTITY_GENERATION
• IDENTITY_START
• IDENTITY_INCREMENT
• IDENTITY_MAXIMUM
• IDENTITY_MINIMUM
• IDENTITY_CYCLE
• IS_GENERATED
• GENERATION_EXPRESSION
• IS_SYSTEM_TIME_PERIOD_START
• IS_SYSTEM_TIME_PERIOD_END
• SYSTEM_TIME_PERIOD_TIMESTAMP_GENERATION
• IS_UPDATABLE
• DECLARED_DATA_TYPE
• DECLARED_NUMERIC_PRECISION
• DECLARED_NUMERIC_SCALE

Issue Links

• supercedes: DRILL-2763 [umbrella] Implement INFORMATION_SCHEMA.COLUMNS enough for relevant tools