Bug #55297 CHAR field loose its size when synchronizing back to the model
Submitted: 15 Jul 2010 17:36 Modified: 23 Jul 2010 15:26
Reporter: Rodrigo Capile Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.25 CE OS:Windows (XP)
Assigned to: CPU Architecture:Any
Tags: char, synchronize model

[15 Jul 2010 17:36] Rodrigo Capile
Description:
Attempting to synchronize a CHAR field to the model fails to keep the field size.

How to repeat:
create table test (
    `codechar` char(4),
    `codevarchar` varchar(4)
);

In Workbench:
1) Reverse engeneer the 'test' table.
- It creates the table correctly
codechar CHAR(4)
codevarchar CHAR(4)

2) Synchronize the model with the DB
- It won´t find any changes because you just reversed engeneered it. So force to update the 'test' table on the model.
codechar CHAR
codevarchar CHAR(4)

The VARCHAR field will be correct but the CHAR field will loose its size (4)
[16 Jul 2010 8:56] Susanne Ebrecht
What do you mean with force update?
[16 Jul 2010 13:44] Rodrigo Capile
while synchronizing, at the "Model and Database Differences" screen, select the test table and choose "Update Model"
[17 Jul 2010 18:55] Valeriy Kravchuk
I can not repeat this on Mac OS X. Looks like Windows-specific problem. What exact version of MySQL server do you use?
[17 Jul 2010 20:22] Rodrigo Capile
MySQL Server 5.0.77, CentOS 5.5
[19 Jul 2010 13:02] MySQL Verification Team
WB

Attachment: wb-char.png (image/png, text), 38.22 KiB.

[19 Jul 2010 13:04] MySQL Verification Team
Verified on Fedora 13 X86_64 (see prior attached picture).
[23 Jul 2010 15:27] Alfredo Kojima
Duplicate of bug #55334