Bug #67853 Unsigned attribute missing during sync's for User Defined Types.
Submitted: 9 Dec 2012 23:50 Modified: 1 Jun 2013 22:21
Reporter: Robert Cesaric Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.45 OS:MacOS (10.8.2)
Assigned to: CPU Architecture:Any
Tags: UDT, UNSIGNED, User Defined Type

[9 Dec 2012 23:50] Robert Cesaric 
Description:
The UNSIGNED flag for User Defined Types isn't being persisted during model synchronizations.  This will cause a sync error in cases where you set a UDT default value to be larger than an unsigned type can hold.

How to repeat:
Create a UDT. For example:

Name: RGB
Type: MEDIUMINT
FLAGS: UNSIGNED

Then use this UDT for a column and give it a default value larger than can be held by a SIGNED MEDIUMINT (10750464 for example).

Sync your model with the DB and it will error.

Suggested fix:
Take the UNSIGNED flag of UDT's into account when synching, forward engineering, etc..
[22 Jan 2013 14:01] MySQL Verification Team 
Thank you for the bug report.
[23 Jan 2013 14:08] MySQL Verification Team 
http://bugs.mysql.com/bug.php?id=68147 marked as duplicate of this one.
[1 Jun 2013 22:21] Alfredo Kojima 
This is a duplicate of bug #52373