Bug #52209 Synchronize Model finds non-existing differences on comments
Submitted: 19 Mar 2010 9:04 Modified: 19 Mar 2010 13:45
Reporter: Leif Inge Sandberg Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.16 OS:Any
Assigned to: CPU Architecture:Any

[19 Mar 2010 9:04] Leif Inge Sandberg 
Description:
When I do a model synchronization against the database that was created from a fresh export script, Workbench says any column that has a comment has been changed. Which is not the case.

How to repeat:
- Create a db using the attached script
- Open the attached Workbench model
- Select Database/Synchronize Model and get the sync script (don't Execute)
- Select Database/Generate Catalog Diff Report

Suggested fix:
Maybe the comparison doesn't handle column comments? Removing all column comments is not a workaround, so I'll have to postpone using this brilliant feature for now.
[19 Mar 2010 9:05] Leif Inge Sandberg 
Create db script

Attachment: TestWb.sql (application/octet-stream, text), 1.73 KiB.
[19 Mar 2010 9:06] Leif Inge Sandberg 
Workbench db model

Attachment: TestWb.mwb (application/octet-stream, text), 4.74 KiB.
[19 Mar 2010 13:45] Johannes Taxacher 
this is a duplicate of Bug #51765