[
https://issues.apache.org/jira/browse/CALCITE-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15263110#comment-15263110
]
Julian Hyde commented on CALCITE-1168:
--------------------------------------
Review comments:
# I see that {{DESCRIBE DATABASE}} currently does the same as {{DESCRIBE
SCHEMA}}. That's OK, I suppose, but misleading.
# Since JDBC's DatabaseMetaData has database, catalog, schema, we should also
have a {{DESCRIBE CATALOG}} command.
# I don't understand why you want to allow a character literal for a column,
e.g. {{DESCRIBE emp 'deptno'}}. An identifier is sufficient, e.g. {{DESCRIBE
emp "deptno"}}. Remove the former.
# Need to allow the optional {{TABLE}} keyword, e.g. {{DESCRIBE TABLE emp}} as
an alternative to {{DESCRIBE emp}}.
# Need to add {{DESCRIBE statement}} and {{DESCRIBE STATEMENT statement}}.
# There is no test for compound identifier
# We should not allow compound column name
> Add DESCRIBE SCHEMA/DATABASE/TABLE/query
> ----------------------------------------
>
> Key: CALCITE-1168
> URL: https://issues.apache.org/jira/browse/CALCITE-1168
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Arina Ielchiieva
> Assignee: Julian Hyde
>
> Add DESCRIBE
> statement so it can support the following:
> {noformat}
> DESCRIBE [SCHEMA | DATABASE] name;
> DESCRIBE table_name;
> {noformat}
> Example, [usage in MySql|http://dev.mysql.com/doc/refman/5.7/en/explain.html]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
