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-de...@kde.org
Reporter: matthew.w...@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 watching all bug changes.
