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)
