Bug #51080 Add or Change to DECIMAL sets scale to 0 when synchronizing

• Submitted: 11 Feb 2010 6:42
• Modified: 11 Feb 2010 10:44
• Reporter: Pete Ramsey
• Status: Duplicate
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.15 Beta
• OS: Windows (XP Professional)
• CPU Architecture: Any

[11 Feb 2010 6:42] Pete Ramsey

Description:
When adding or changing a DECIMAL column, the scale side is always changed to 0 when synchronizing the database. This issue is clearly visible in the SQL code displayed before you can execute.

How to repeat:
Create a table with a DECIMAL(5,2) column and try to synchronize. You will see DECIMAL(5,0) in the generated SQL code.

[11 Feb 2010 6:46] Pete Ramsey

Workbench Generated SQL code showing the issue

Attachment: decimal_bug.sql (application/octet-stream, text), 511 bytes.

[11 Feb 2010 7:24] Valeriy Kravchuk

Thank you for the bug report. Verified just as described.

[11 Feb 2010 10:44] Alexander Musienko

Duplicate of Bug #50110