Announcement

Announcement Module
Collapse
No announcement yet.

triggers and cascading updates or deletes

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • triggers and cascading updates or deletes

    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

  • #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

    Comment

    Working...
    X