Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-2803

new SQL statement support : COMMENT-ON

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor
    • Resolution: Implemented
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sql-general
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              chenqilin Qilin Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: