[umbrello-devel] [umbrello] [Bug 353668] New: Hangs on MySQL script import when a column has a character set

[rk80kk5e2yjivh1 at jetable.org]

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

            Bug ID: 353668
           Summary: Hangs on MySQL script import when a column has a
                    character set
           Product: umbrello
           Version: 2.17.0 (KDE Applications 15.08.0)
          Platform: Debian testing
               URL: https://dev.mysql.com/doc/refman/5.7/en/charset-column
                    .html
                OS: Linux
            Status: UNCONFIRMED
          Severity: minor
          Priority: NOR
         Component: general
          Assignee: umbrello-devel at kde.org
          Reporter: rk80kk5e2yjivh1 at jetable.org

Umbrello hangs (unresponsive and 100% CPU) when using [Code/Code Importing
Wizard/] with a simple MySQL script containing the following table definition :
CREATE TABLE `mytable` (`myvarchar` text CHARACTER SET utf8);

The last debug lines are :
umbrello: 1 "TABLE"
umbrello: 2 "`"
umbrello: 3 "mytable"
umbrello: 4 "`"
umbrello: 5 "("
umbrello: parsing create table "mytable"
umbrello: scene= "class diagram"  / object= "mytable"
umbrello: 6 "`"
umbrello: 7 "myvarchar"
umbrello: 8 "`"
umbrello: 9 "text"
umbrello: 10 "CHARACTER"
umbrello: 11 "SET"


Reproducible: Always

Steps to Reproduce:
1. Create an SQL script as follow : CREATE TABLE `mytable` (`myvarchar` text
CHARACTER SET utf8);
2. Try importing it using Code Importing Wizard with "MySQL" as a language


Actual Results:  
Umbrello hangs : unresponsive + 100% CPU

Expected Results:  
Entities created
or
A parsing error message without application crash/hang

The new SQL parser doesn't seem to implement character set yet :
https://dev.mysql.com/doc/refman/5.7/en/charset-column.html
Workaround : remove the character set definition in the script as they are
useless to the code import.

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