The Infamous 20 Year Old MySQL Bug #11472 Has Been Fixed
7 hours ago
- #Triggers
- #Foreign Keys
- #MySQL
- MySQL bug #11472, reported in 2005, describes a serious issue where triggers are not executed when foreign key cascading updates or deletes occur, impacting data integrity and ACID compliance.
- The bug was acknowledged early as a known problem, documented as a shortcoming, and initially targeted for fix in version 5.1, but remained unresolved for many years across multiple MySQL versions.
- Users repeatedly expressed frustration over the years, noting the bug persisted in versions up to 8.0, with some migrating to other databases like PostgreSQL as a workaround.
- Discussions included considerations for fixing the bug, such as potential backward compatibility issues with statement-based replication and the need for careful implementation to avoid data drift.
- The bug was finally marked as fixed on March 17, 2025, as part of WorkLog WL#17024, which activates triggers on referencing tables during foreign key CASCADE operations.