triggers and cascading updates or deletes

[rbro]

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?

http://bugs.mysql.com/bug.php?id=11472
http://bugs.mysql.com/bug.php?id=61555

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

[niljoshi]

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