MySQL Bugs: #99296: Implement COMMENT ON

Bug #99296	Implement COMMENT ON
Submitted:	18 Apr 2020 12:25	Modified:	18 Apr 2020 18:52
Reporter:	Federico Razzoli	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
Please implement COMMENT ON, which is supported by all major DBMSs (with the exception of SQL Server, but it has a system stored procedure for that):

COMMENT ON <object_type> <object_name> IS [ string | NULL ];

This has several benefits:

* 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.

How to repeat:
Repeating a feature request is probably harder than changing this field to only be mandatory for bug :)

Thank you for the report. It only can be verified as Feature Request, so please change it to. Thanks in advance.

Yes sorry for the mistake, changing to S4.

Thank you for the feature request.