triggers and cascading updates or deletes

MySQL & MariaDB Other MySQL® Questions
1

Currently triggers are not executed in a cascade update or delete. It’s a known issue since 2005 in MySQL, but still not fixed. Is there a way that it can be fixed in Percona Server?

[URL]MySQL Bugs: #11472: Triggers not executed following foreign key updates/deletes
[URL]MySQL Bugs: #61555: Triggers AFTER DELETE is NOT CALLED WHEN DELETE BY a ON DELETE CASCADE constrain

From a comment in the first link from 2009, it may have been fixed in 6.1 (lp:6.1-fk tree). Is it possible that those changes could be merged into the Percona 5.5 branch?

Thanks,
Ryan

2

Hi Ryan,

We’ll unlikely see this fixed for at least several years in MySQL and It is possible OR we would only work on it if we were engaged to…though we don’t think there’s an “easy” fix as it would take lot of efforts.

Regards,
Nil