[Digikam-devel] [Bug 286492] New: Two triggers applied for the same table - not supported by MySQL

[Ignatius Reilly]

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: digikam-devel at kde.org
        ReportedBy: ignatius.reilly at free.fr


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.