[
https://issues.apache.org/jira/browse/DRILL-3308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14590889#comment-14590889
]
Daniel Barclay (Drill) commented on DRILL-3308:
-----------------------------------------------
Replaces DRILL-2763 to cover the parts (of DRILL-2763) not addressed (fixed) by
DRILL-3216.
> Revisit INFORMATION_SCHEMA.COLUMNS's SQL compliance.
> ----------------------------------------------------
>
> Key: DRILL-3308
> URL: https://issues.apache.org/jira/browse/DRILL-3308
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Reporter: Daniel Barclay (Drill)
> Assignee: Steven Phillips
>
> 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}}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
