[MDEV-13110] Add support for COMMENT ON Created: 2017-06-16  Updated: 2023-02-13

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Heinz Wiesinger Assignee: Unassigned
Resolution: Unresolved Votes: 2
Labels: Compatibility, Oracle


 Description   

Add support for Oracle's way of adding comments to tables, views, materialized views, columns, etc.

Syntax and Semantics for Oracle's COMMENT statement can be found here: https://docs.oracle.com/database/122/SQLRF/COMMENT.htm#SQLRF01109



 Comments   
Comment by Federico Razzoli [ 2020-04-18 ]

This is supported by all major DBMSs, not just Oracle. The only exception is SQL Server, but it has a system stored procedure for this.

Also, it is not just a compatibility feature. It allows to:

  • Avoid dropping and recreating an index just to add a comment;
  • Avoid repeating a column definition just to add a comment: this is error prone;
  • Avoid granting a user ALTER privilege just because we want it to be able to add comments;
  • Similarly, avoid granting ALTER ROUTINE, that allows to change the SECURITY clause.

Dataedo CEO stated in a webinar that their tool doesn't add comments to MySQL because they don't want to use ALTER TABLE.

Generated at Thu Feb 08 08:02:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.