Comment 0 for bug 1011543

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.