[ https://issues.apache.org/jira/browse/TRAFODION-2803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16290177#comment-16290177 ]
ASF GitHub Bot commented on TRAFODION-2803: ------------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/1327 > 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)