Details
-
Bug
-
Status: Closed (View Workflow)
-
Resolution: Not a Bug
-
None
-
None
-
None
Description
After upgrading MariaDB from 5.3.7 to 5.5.24 version, JOIN statement inside the DELETE query are broken.
All triggers containing:
DELETE sales_tree_p t1 FROM sales_tree_p t1
JOIN (SELECT * FROM sales_tree_p WHERE id_sale_in = 1999) t2 ON t2.id_sale = t1.id_sale
JOIN (SELECT * FROM sales_tree_p WHERE id_sale = 2000) t3 ON (t3.id_sale_in = t1.id_sale_in);
are lost!!!!!
And when I manually try exec this query I receive error message
Error Code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 't1 FROM sales_tree_p t1
JOIN (SELECT * FROM sales_tree_p WHERE id_sale_in = 1' at line 1
After downgrade to version 5.3.7 all my triggers appear again and begins work.
Thus, I see two problems:
1) the main, broken JOIN statement inside the DELETE query.
2) when update must be reported that the break triggers and stored procedures.