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] [Updated] (DRILL-3308) Revisit INFORMATION_SCHEMA.COLUMNS's SQL compliance.
Date Thu, 18 Jun 2015 05:31:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Daniel Barclay (Drill) updated DRILL-3308:
------------------------------------------
    Component/s:     (was: Metadata)

> 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
>            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