Bug #96356 User Types List, Change Sequence
Submitted: 27 Jul 2019 15:33 Modified: 28 Dec 2020 18:53
Reporter: Manfred Sprenger Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:8.0.22 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: modeling, User types list

[27 Jul 2019 15:33] Manfred Sprenger
When you change the sequence of elements in "the datatypes list",then the assigned user defined datatypes in table definition also changes   

How to repeat:
Define two datatype "A" and "B" in the "User type list"

Define table "tab1" with column "F1" and datatype "A"

Define table "tab2" with column "F1" and datatype "B"

Edit "User type list" and shift "B" in front of "A"

Now column "F1" in table "tab1" has datatype "B" and column "F1" in table "tab2" has datatype "A"

Suggested fix:
At the Moment: Do not change sequence of Elements in "user types liste"
[27 Jul 2019 17:26] MySQL Verification Team
Thank you for the bug report.
[28 Dec 2020 18:53] Manfred Sprenger
Problem still occurs in Version 8.0.22. Changes in Sequence of User Types still change Table-Definition in strange way. Synchronizing "destroy" Tables in DB-Schema.