MySQL Bugs: #44543: Too long table comments allowed

Bug #44543	Too long table comments allowed
Submitted:	29 Apr 2009 14:40	Modified:	29 Apr 2009 14:58
Reporter:	Jan Juricek	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.30 (3384)	OS:	Windows (Vista)
Assigned to:		CPU Architecture:	Any

Description:
MWB allows to insert a comment longer, than InnoDB engine allows, resutling in syntax error:

COMMENT = 'Specifies which category contains which genres. Every station belonging to a category naturally inherits those genres'
Error 1105: Too long comment for table 'stats_genre_artists'

How to repeat:
- Create a table
- Specify long comment (for example "Specifies which category contains which genres. Every station belonging to a category naturally inherits those genres")
- export sql code and import it or synchronize with the DB directly
- fail

Suggested fix:
Put a maxlength limit on the comment field

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=34507.

I really useful fix for this would be to add an option in the export command to not export
all the comments.

After all one of the main purposes of workbench is to document your schema and
restricting comment size in workbench would be a very bad solution to this problem.

Adding an option of not exporting comments or simply truncating them would be very useful
indeed.