MySQL Bugs: #15344: Comments on views and triggers

Bug #15344	Comments on views and triggers
Submitted:	30 Nov 2005 9:43	Modified:	30 Nov 2005 10:08
Reporter:	Federico Razzoli (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Views	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
I would like to be able to set comments for views and triggers. I don't know if comments on those objects are standard SQL, but would be useful.

How to repeat:
.

Thank you for a feature request. I agree that stored comments to all database objects can be useful for large and complex databases.

For comments in triggers,
see related Bug#11230

To view the trigger statements (with the comments then),
see related Bug#18161

Bug #30729 was marked as a duplicate of this one.

There is really no workaround now because of Bug#5159. Once Bug#5159 is fixed, comments will be allowed at any place in view definition, which would provide a very good workaround.
Not closing as a duplicate since the suggested solution is different.

http://bugs.mysql.com/bug.php?id=71120 duplicate of this one.

It's really ugly and hacky, but if you must have some sort of inline documentation before this (ever) gets implemented, this below will work.  In the event someone ever needs to reverse engineer your views to see what it was for, via SHOW CREATE VIEW, they will get the blurb.

CREATE OR REPLACE VIEW foo
AS
SELECT bar, bat, biz
FROM cats c
JOIN dogs d ON (c.nickname = d.nickname)
WHERE d.has_fleas = 1
AND 'Comment' != 'This view was created to prove a point. Please implement Bug #15344 soon.';

Please put this feature! Anyone working on this?

Allowing comments to views would prevent me having to have maintain separate documentation for explaining some of the calculated fields I am producing in the view.
I would appreciate this feature being added.
Thanks

It would be appreciated :)