Bug #42728 field types are altered wrong
Submitted: 10 Feb 2009 13:10 Modified: 10 Jun 2009 15:09
Reporter: Tino Korth (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.0.29 SE OS:Windows (XP Professional)
Assigned to: Alexander Musienko CPU Architecture:Any
Tags: CHECKED

[10 Feb 2009 13:10] Tino Korth 
Description:
We've created a MySQL scheme and when we want to synchronize this scheme an error occures.
Please see the files attached ...

How to repeat:
Create a table with different data types (float, tinyint, ...), synchronize this table.

Suggested fix:
Better datatype translation table.
[10 Feb 2009 13:10] Tino Korth 
Workbench Scheme

Attachment: Workbench-Test.mwb (application/octet-stream, text), 3.96 KiB.
[10 Feb 2009 13:11] Tino Korth 
Reference database SQL

Attachment: Workbench-Test.sql (text/x-sql), 1.05 KiB.
[10 Feb 2009 13:11] Tino Korth 
bug report

Attachment: Workbench-Bug.pdf (application/pdf, text), 27.53 KiB.
[11 Feb 2009 11:31] MySQL Verification Team 
Thank you for the bug report.
[9 Jun 2009 17:04] Alexander Musienko 
Fixed in 5.1
[9 Jun 2009 18:13] Johannes Taxacher 
fix confirmed in version 5.1. when syncing the supplied model file against the table created using the sql-script there's only one difference reported (DEFAUL '0' on the PK column in the script which is in fact missing in the documents table). 
This difference creates an ALTER-line which corrects this in the database. on subsequent syncs no more differences are reported.
fix will be inclided in 5.1.13
[10 Jun 2009 15:09] Tony Bedford 
An entry was added to the 5.1.13 changelog:

When synchronizing a model with a database, using the Synchronize Model with Database wizard, the data type translation resulted in errors.