Bug #44439 Comments text field should enforce length restriction imposed by MySQL server
Submitted: 23 Apr 2009 16:00 Modified: 28 May 2009 12:17
Reporter: Marc Liyanage Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1.10 Beta Rev 5306 OS:MacOS (10.5.6)
Assigned to: CPU Architecture:Any

[23 Apr 2009 16:00] Marc Liyanage
Description:
Workbench lets me enter table comments that are rejected by the MySQL server because they are too long. 

How to repeat:
1.) Define a table and give it a long comment
2.) Export the SQL definition file and try to load it into MySQL. It will fail with this message:

ERROR 1105 (HY000) at line 37: Too long comment for table 'foobar'

Suggested fix:
Workbench should restrict the comment length to what the MySQL server allows.
[23 Apr 2009 17:04] Valeriy Kravchuk
Thank you for the problem report. See also related feature request, Bug #38621.
[28 May 2009 12:17] Susanne Ebrecht
This is a duplicate of bug #38621