MySQL Bugs: #31548: Multiple "InnoDB Free ..." messages added to "Comments" field when editing table

Bug #31548	Multiple "InnoDB Free ..." messages added to "Comments" field when editing table
Submitted:	11 Oct 2007 21:49	Modified:	13 Feb 2009 14:01
Reporter:	Chris Calender	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	All	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	comments, innodb free, multiple innodb free, over-write, overwritten

Description:
If you edit an InnoDB table within the table editor within MySQL Administrator, it stores the "InnoDB free" information to the table's "Comments".

Now, when you go and edit the table again (any edit of the "Comment" field), it will re-add another, fresh, "InnoDB free ..." output.

How to repeat:
1. Create an InnoDB table.
2. Edit the table within MA (any edit) should add the "InnoDB Free ..." provided the "comments" are empty.
3. Now, edit the table again (i.e., add something to the end of the comment)

You'll see it keeps the first "InnoDB Free", and adds another "InnoDB".  It will keep doing this until you get an error stating your "Comment" field is too long.

Suggested fix:
Please do not add this twice.  Somehow check it, and remove the old information, at worst.

And even better would be to not even store this information at all, but I'll file another report on that with reasoning.

This is similar/related to bug #31549 (but they are not quite the same).

http://bugs.mysql.com/bug.php?id=31549

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/