MySQL Bugs: #52429: Allow COMMENTs in VIEWs as it exists for TABLEs

Bug #52429	Allow COMMENTs in VIEWs as it exists for TABLEs
Submitted:	29 Mar 2010 9:38	Modified:	29 Mar 2010 9:43
Reporter:	Leandro Morgado	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When using tables, we can create both table level and column level comments:

mysql> CREATE TABLE `t1` (   `a` bigint(20) unsigned DEFAULT '1' COMMENT 'my column' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT 'mytable';
Query OK, 0 rows affected (0.08 sec)

mysql> SHOW CREATE TABLE t1;
+-------+----------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                           |
+-------+----------------------------------------------------------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `a` bigint(20) unsigned DEFAULT '1' COMMENT 'my column'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='mytable' |
+-------+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

How to repeat:
However, this does not work for VIEWs:

mysql> CREATE VIEW v AS SELECT * FROM t1 COMMENT 'mytable';ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''mytable'' at line 1

mysql> CREATE VIEW v AS SELECT * FROM t1 COMMENt='mytable';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='mytable'' at line 1

Suggested fix:
Ideally, VIEWs would allow for COMMENTs at both column and table level. 
However, since columns are "taken" from the creation SELECT, it may be difficult to implement/choose how those columns are commented. 

I think we should at least allow COMMENTs at the table/view level for CREATE/ALTER VIEW.

In information_schema.TABLES the value of TABLE_COMMENT column is "VIEW" for views. But this is completely useless, because the right way to identify VIEWs is to read the TABLE_TYPE column.

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 :)