You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/06/18 02:02:47 UTC
[jira] [Created] (DRILL-3308) Revisit INFORMATION_SCHEMA.COLUMNS's
SQL compliance.
Daniel Barclay (Drill) created DRILL-3308:
---------------------------------------------
Summary: 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)