[ https://issues.apache.org/jira/browse/TRAFODION-2803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Qilin Chen updated TRAFODION-2803: ---------------------------------- External issue URL: (was: https://github.com/apache/incubator-trafodion/pull/1288) > 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)