[jira] [Created] (TRAFODION-2803) new SQL statement support : COMMENT-ON

["Qilin Chen (JIRA)" <ji...@apache.org>]

Qilin Chen created TRAFODION-2803:
-------------------------------------

             Summary: 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)