[umbrello] [Bug 292239] SQL code indexes wrong field for foreign key

[Ralf Habacker]

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

--- Comment #4 from Ralf Habacker <ralf.habacker at freenet.de> ---
The reported issue could be reproduced with current version. Generating mysql
code returns:

------------ neue_entitaet.sql ---------------

CREATE TABLE neue_entitaet (
    neues_feld  NOT NULL 
);

CREATE INDEX neue_entitaet_1_feld_index  ON neue_entitaet(feld);

-- 
ALTER TABLE neue_entitaet ADD CONSTRAINT neue_fremschluessel_einschraenkung
FOREIGN KEY (neues_feld) REFERENCES neue_entitaet_1(feld) ON UPDATE NO ACTION
ON DELETE NO ACTION;


------------ neue_entitaet_1.sql ---------------

CREATE TABLE neue_entitaet_1 (
    feld int NOT NULL 
);

The incorrectly generated line is

CREATE INDEX neue_entitaet_1_feld_index  ON neue_entitaet(feld);

because 'feld' is not a column of table 'neue_entitaet'

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