MySQL Bugs: #57070: Column comments too long

Bug #57070	Column comments too long
Submitted:	28 Sep 2010 14:46	Modified:	28 Sep 2010 15:53
Reporter:	Alex W	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.28	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
The comments option for columns allows you to type more than the 60 allowed characters breaking SQL generated by the forward engineer.

How to repeat:
1. Create a column and add a comment that exceeds 60 characters.
2. Generate SQL using the forward engineer.
3. Execute SQL.

Suggested fix:
1. The comment textbox is limited to 60 characters.
2. The forward engineer truncates comments to 60 characters.
3. Option to omit comments on forward engineer.

I prefer 3 as it would still allow the use of unrestricted comments in workbench and wouldn't effect the generated SQL.

Cannot second 3.  Then other clients will not see the comments. Comments are server-side objects. If WB should implement 'local comments' it will have to be in addition to 'server-side comments'.

this is a duplicate of Bug #38597