MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Any plans to fix trigger bug relating to cascading foreign keys?
Posted by: Abraham Guyt
Date: May 28, 2012 06:32PM

LS,

A serious bug/issue now has been known and documented for 7 years, and the MySQL manual even carries a warning related to this bug, but is there a plan/schedule for fixing this?

Cascading foreign keys currently do NOT cause triggers to fire in the related tables, making it basically impossible to maintain integrity that way or to rely on triggers for that purpose.

Original 2005 bug report (still unfixed): http://bugs.mysql.com/bug.php?id=11472

At the moment this ACID thing is possibly the biggest issue driving people towards PostgreSQL (apart from the GIS functionality).

I like using MySQL, but if there's no plan for a fix we have a problem.

Any comments from MySQL itself?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Any plans to fix trigger bug relating to cascading foreign keys?
2256
Abraham Guyt
May 28, 2012 06:32PM
Re: Any plans to fix trigger bug relating to cascading foreign keys?
1320
Peter Brawley
May 29, 2012 10:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.