Bug #50660 Syncrhonize database with decimal columns
Submitted: 27 Jan 2010 13:09 Modified: 5 Feb 2010 13:02
Reporter: Leandro Vidal Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.11 OSS OS:Windows (XP)
Assigned to: Assigned Account CPU Architecture:Any
Tags: decimal, synchronize

[27 Jan 2010 13:09] Leandro Vidal
Description:
I have some tables with column datatypes DECIMAL(5,2). When I syncrhonize the model with the database, the decimal columns are writen into the database like DECIMAL(5,0)

How to repeat:
Create a table with a decimal column like DECIMAL(5,2) for example an syncronize the model
[27 Jan 2010 21:36] Johannes Taxacher
i was not able to repeat by just creating a new table from scratch and fwd eng. that to db.
i could repeat it like this:
- rev. eng. some table
- add a column DECIMAL(5,2)
- run sync
in this case the proposed alter script contained "... DECIMAL(5,0) ..."
[29 Jan 2010 20:42] Johannes Taxacher
Bug #50708 was marked as a duplicate of this one
[5 Feb 2010 13:02] Alexander Musienko
Duplicate of http://bugs.mysql.com/bug.php?id=50110