[umbrello-devel] [umbrello] [Bug 362244] New: Generated SQL incomplete due to CHECK constraints not being terminated with ;

[Matthew Wild via KDE Bugzilla]

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

            Bug ID: 362244
           Summary: Generated SQL incomplete due to CHECK constraints not
                    being terminated with ;
           Product: umbrello
           Version: 2.18.2 (KDE Applications 15.12.2)
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
          Assignee: umbrello-devel at kde.org
          Reporter: matthew.wild at stfc.ac.uk

When generating SQL form an ERD using the PostgreSQL or MySQL code generator,
the resultant SQL file is wrong if a table contains a CHECK constraint. The
ALTER TABLE command is correctly generated but the line is not ended with a ;
and therefore will fail when pushed to the database.

Reproducible: Always

Steps to Reproduce:
1. Create ERD
2. Create Table
3. Create CHECK constraint on field within table
4. Generate PostgreSQL/MySQL code

Actual Results:  
-- 
ALTER TABLE SSA_Sensor_Site ADD CONSTRAINT range_check_constraint CHECK
(Range>=0)


Expected Results:  
-- 
ALTER TABLE SSA_Sensor_Site ADD CONSTRAINT range_check_constraint CHECK
(Range>=0);

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