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

[Andrew Crouthamel]

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

Andrew Crouthamel <***@kdemail.net> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|REPORTED |NEEDSINFO
Resolution|--- |WAITINGFORINFO

--- Comment #1 from Andrew Crouthamel <***@kdemail.net> ---
Dear Bug Submitter,

This bug has been stagnant for a long time. Could you help us out and re-test
if the bug is valid in the latest version? I am setting the status to NEEDSINFO
pending your response, please change the Status back to REPORTED when you
respond.

Thank you for helping us make KDE software even better for everyone!

[Andrew Crouthamel]

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

Andrew Crouthamel <***@kdemail.net> changed:

What |Removed |Added
----------------------------------------------------------------------------
Resolution|WAITINGFORINFO |---
Status|NEEDSINFO |REPORTED

--- Comment #2 from Andrew Crouthamel <***@kdemail.net> ---
Dear Bug Submitter,

This is a reminder that this bug has been stagnant for a long time. Could you
help us out and re-test if the bug is valid in the latest version? This bug
will be moved back to REPORTED Status for manual review later, which may take a
while. If you are able to, please lend us a hand.

Thank you for helping us make KDE software even better for everyone!

[Ralf Habacker]

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

Ralf Habacker <***@freenet.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@freenet.de

--- Comment #3 from Ralf Habacker <***@freenet.de> ---
Created attachment 116414
--> https://bugs.kde.org/attachment.cgi?id=116414&action=edit
xmi test case

[Ralf Habacker]

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

--- Comment #4 from Ralf Habacker <***@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'

[Ralf Habacker]

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

Ralf Habacker <***@freenet.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|REPORTED |RESOLVED
Latest Commit| |https://commits.kde.org/umb
| |rello/b1303405b534ee56ec37b
| |a33ecf2e4fa83d9a383
Resolution|--- |FIXED
Version Fixed In| |2.26.90 (KDE Applications
| |18.11.90)

--- Comment #5 from Ralf Habacker <***@freenet.de> ---
Git commit b1303405b534ee56ec37ba33ecf2e4fa83d9a383 by Ralf Habacker.
Committed on 20/11/2018 at 00:27.
Pushed by habacker into branch 'Applications/18.12'.

Fix 'SQL code indexes wrong field for foreign key'
FIXED-IN:2.26.90 (KDE Applications 18.11.90)

M +3 -3 umbrello/codegenerators/sql/mysqlwriter.cpp
M +1 -1 umbrello/codegenerators/sql/sqlwriter.cpp

https://commits.kde.org/umbrello/b1303405b534ee56ec37ba33ecf2e4fa83d9a383