[
https://issues.apache.org/jira/browse/TRAFODION-2803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Qilin Chen resolved TRAFODION-2803.
-----------------------------------
Resolution: Implemented
> new SQL statement support : COMMENT-ON
> --------------------------------------
>
> Key: TRAFODION-2803
> URL: https://issues.apache.org/jira/browse/TRAFODION-2803
> Project: Apache Trafodion
> Issue Type: New Feature
> Components: sql-general
> Reporter: Qilin Chen
> Priority: Minor
> Attachments: Trafodion_SQL_COMMENT_feature_design.171110.docx
>
>
> Add support for COMMENT-ON statement.
> This is a new requirement from customer, and below is design and
> implementation for now:
> 1. add new COMMENT-ON syntax, supported objects: SCHEMA, TABLE, VIEW, INDEX,
> LIBRARY, FUCNTION(UDR), PROCEDURE, SEQUENCE, COLUMN
> 2. new component privilege: SQL_OPERATIONS::COMMENT
> 3. SHOWDDL changes: add COMMENT-ON output for each object
> 4. new build-in views to look up comment: "MD".OBJECT_COMMENT_VIEW and
> "MD".COLUMN_COMMENT_VIEW
> Please see attachment for more detail.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
