MySQL Bugs: #55238: Comments are too long for schema generation

Bug #55238	Comments are too long for schema generation
Submitted:	13 Jul 2010 22:34	Modified:	15 Jul 2010 17:46
Reporter:	Jeremy Tinley	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.25 CE	OS:	Windows (7.0)
Assigned to:		CPU Architecture:	Any

Description:
When you Forward Engineer SQL Create, COMMENTs should be trimmed down to the maximum length for the database.

The result is:
ERROR 1105 (HY000): Too long comment for table 'table1'

How to repeat:
Create a new table
Enter very long comments for it.

File > Export > Forward Engineer SQL Create

Observe that the comment field will be too long.

Suggested fix:
Trim the COMMENT data to 255 characters per documentation here:

http://dev.mysql.com/doc/refman/5.0/en/create-table.html
and
http://dev.mysql.com/doc/refman/5.1/en/create-table.html

"A comment for a column can be specified with the COMMENT option, up to 255 characters long."

This could possibly be added as an option on the Forward Engineer panel:
"Trim comments to [____] characters.", default 255, in the event that a future version supports a longer length.

this is a duplicate of Bug #38597