https://bugs.kde.org/show_bug.cgi?id=286492 Summary: Two triggers applied for the same table - not
supported by MySQL
Product: digikam
Version: 2.3.0
Platform: Ubuntu Packages
OS/Version: Linux
Status: UNCONFIRMED
Severity: minor
Priority: NOR
Component: Database
AssignedTo:
[hidden email]
ReportedBy:
[hidden email]
Version: 2.3.0 (using KDE 4.7.2)
OS: Linux
DDL on SQLite:
CREATE TRIGGER delete_tag DELETE ON Tags
BEGIN
DELETE FROM ImageTags WHERE tagid=OLD.id;
DELETE FROM TagProperties WHERE tagid=OLD.id;
DELETE FROM ImageTagProperties WHERE tagid=OLD.id;
END;
CREATE TRIGGER delete_tagstree DELETE ON Tags
BEGIN
DELETE FROM Tags
WHERE id IN (SELECT id FROM TagsTree WHERE pid=OLD.id);
DELETE FROM TagsTree
WHERE id IN (SELECT id FROM TagsTree WHERE pid=OLD.id);
DELETE FROM TagsTree
WHERE id=OLD.id;
END;
This is not supported by MySQL
Reproducible: Didn't try
Steps to Reproduce:
Install a new SQLite and export the DDL
Actual Results:
This possibly impairs the SQLite => MySQL migration
Expected Results:
Don't know - I upgraded from an older installation
Merge the two triggers into one
--
Configure bugmail:
https://bugs.kde.org/userprefs.cgi?tab=email------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Locked
