Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5614

Add COMMENT ON syntax to support comments on all objects

    XMLWordPrintableJSON

    Details

    • Epic Color:
      ghx-label-4

      Description

      The current SQL grammar (v2.9) allows for comments on objects at creation time but does not allow for modification post-fact. Postgres and others support the COMMENT ON syntax although it is not part of the ANSI standard.

      For example:

      COMMENT ON DATABASE my_database IS 'Development Database';
      COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
      COMMENT ON COLUMN my_table.my_column IS 'Employee ID number';
      COMMENT ON VIEW my_view IS 'View of departmental costs';
      COMMENT ON FUNCTION my_function (timestamp) IS 'Returns Roman Numeral';
      
      COMMENT ON DATABASE my_database IS NULL; -- to remove a comment
      

      References:

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fredyw Fredy Wijaya
                Reporter:
                grahn Greg Rahn
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: