https://bugs.kde.org/show_bug.cgi?id=435179
--- Comment #16 from gessel <ges...@blackrosetech.com> ---
MariaDB [digikam]> show triggers;
+-----------------+--------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+---------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement
| Timing | Created
| sql_mode
| Definer | character_set_client |
collation_connection | Database Collation |
+-----------------+--------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+---------+----------------------+----------------------+--------------------+
| insert_tagstree | INSERT | Tags | INSERT INTO TagsTree SELECT NEW.id,
NEW.pid
UNION SELECT NEW.id, pid FROM TagsTree WHERE id = NEW.pid
| AFTER |
2021-03-26 21:09:24.38 |
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
| @% | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci |
| move_tagstree | UPDATE | Tags | BEGIN
IF (NEW.pid != OLD.pid) THEN
DELETE FROM TagsTree WHERE ((id = OLD.id) OR id IN
(SELECT id FROM
(SELECT id FROM TagsTree WHERE pid = OLD.id) AS
tmpTree1))
AND pid IN (SELECT pid FROM
(SELECT pid FROM TagsTree WHERE id = OLD.id) AS
tmpTree2);
INSERT INTO TagsTree SELECT NEW.id, NEW.pid
UNION SELECT NEW.id, pid FROM TagsTree
WHERE id = NEW.pid
UNION SELECT id, NEW.pid FROM TagsTree
WHERE pid = NEW.id
UNION SELECT A.id, B.pid FROM TagsTree A, TagsTree
B
WHERE A.pid = NEW.id AND B.id = NEW.pid;
END IF;
END | AFTER | 2021-03-26 21:09:24.47 |
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
| @% | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci |
| delete_tagstree | DELETE | Tags | BEGIN
DELETE FROM TagsTree WHERE id IN (SELECT id FROM
(SELECT id FROM TagsTree WHERE pid = OLD.id) AS
tmpTree1);
DELETE FROM TagsTree WHERE id = OLD.id;
END
| AFTER | 2021-03-26 21:09:24.43 |
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
| @% | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci |
+-----------------+--------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+---------+----------------------+----------------------+--------------------+
3 rows in set (0.001 sec)
--
You are receiving this mail because:
You are watching all bug changes.
