[TRAFODION-2803] new SQL statement support : COMMENT-ON

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Implemented
• Component/s: sql-general
• Assignee: Unassigned
• Reporter: Qilin Chen
• Created: 13/Nov/17 07:35
• Updated: 15/Sep/18 07:30
• Resolved: 07/Dec/17 01:49

Description

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.

Issue Links

• links to: Github Pull Request #1288
• links to: GitHub Pull Request #1327