drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3308) Revisit INFORMATION_SCHEMA.COLUMNS's SQL compliance.
Date Thu, 18 Jun 2015 00:02:47 GMT
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)

Mime
View raw message