[umbrello] [Bug 400803] New: mysql import does not convert enum index from column default value

[Ralf Habacker]

https://bugs.kde.org/show_bug.cgi?id=400803

Bug ID: 400803
Summary: mysql import does not convert enum index from column
default value
Product: umbrello
Version: 2.26.2 (KDE Applications 18.08.2)
Platform: Other
OS: All
Status: REPORTED
Severity: normal
Priority: NOR
Component: importer
Assignee: umbrello-***@kde.org
Reporter: ***@freenet.de
Target Milestone: ---

Created attachment 116154
--> https://bugs.kde.org/attachment.cgi?id=116154&action=edit
sql test file

mysql enum support provides numeric values for table column default values (see
https://dev.mysql.com/doc/refman/8.0/en/enum.html). Importing such statements
results into a numeric default value, which umbrello does not understand. The
numeric value should be converted to the related enum literal.

STEPS TO REPRODUCE
1. start umbrello
2. set active language to mysql
3. import the appended sql file

OBSERVED RESULT
After import opening the properties the table column 'tipo_empleado' shows '2'
as default value

EXPECTED RESULT
The default value of the mentioned column should be 'Empleado'

[Ralf Habacker]

https://bugs.kde.org/show_bug.cgi?id=400803

Ralf Habacker <***@freenet.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Latest Commit| |https://commits.kde.org/umb
| |rello/916330afea84f080fdefb
| |a4f5ca9ea4440d4f33a
Version Fixed In| |2.26.80 (KDE Applications
| |18.11.80)
Resolution|--- |FIXED
Status|REPORTED |RESOLVED

--- Comment #1 from Ralf Habacker <***@freenet.de> ---
Git commit 916330afea84f080fdefba4f5ca9ea4440d4f33a by Ralf Habacker.
Committed on 08/11/2018 at 13:16.
Pushed by habacker into branch 'master'.

Add support for importing indexed enum type default values from mysql files
FIXED-IN:2.26.80 (KDE Applications 18.11.80)

M +16 -3 umbrello/codeimport/sqlimport.cpp
M +0 -3 umbrello/uml1model/entityattribute.cpp

https://commits.kde.org/umbrello/916330afea84f080fdefba4f5ca9ea4440d4f33a