2012-06-11 11:03:03 |
Mikhail Gavrilov |
description |
After upgrading MariaDB from 5.3.7 to 5.5.24 version, JOIN's in DELETE statement 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. |
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. |
|