[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-devel at kde.org
          Reporter: ralf.habacker at 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'

-- 
You are receiving this mail because:
You are the assignee for the bug.