MySQL Bugs: #17965: Comments are not comitted to the DB.

Bug #17965	Comments are not comitted to the DB.
Submitted:	6 Mar 2006 14:15	Modified:	10 May 2006 13:37
Reporter:	Stefaan Lesage (Basic Quality Contributor)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S3 (Non-critical)
Version:	1.0.6 Beta	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
If you add comments to the Tables / Fields in your Model, and try to apply the changes to the DB, the comments do not getscripted / updated on the DB.

How to repeat:
Empty Model.
Reverse Engineer an empty Catalog / DB
New MyIsam Table.
Add some fields.
Add comments to the Tables / Fields.
Synchronise the model with the DB.

-> The comments are not scripted / stored on the DB.

Verified on Windows 2000 SP4, latest patches.

The synchronization process generated SQL like this:

CREATE TABLE `table_02` (
  `idtable_02` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`idtable_02`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

But it should have generated this:

CREATE TABLE `table_02` (
  `idtable_02` int(11) unsigned NOT NULL auto_increment COMMENT 'fieldcomment',
  PRIMARY KEY  (`idtable_02`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Update for 1.0.6 Beta.

Table comments apparently do not seem to get saved in the model.  Field comments do.  Though when synchronising your model with the DB, or exporting a Create Script for your model, the comments are not applied to the DB.