Bug #92317 | Possible to add inconsistent parent to orphan foreign key if SE changed. | ||
---|---|---|---|
Submitted: | 6 Sep 2018 9:57 | Modified: | 10 Oct 2018 18:38 |
Reporter: | Dmitry Lenev | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
Version: | 8.0.14 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[6 Sep 2018 9:57]
Dmitry Lenev
[10 Oct 2018 18:38]
Paul DuBois
Posted by developer: Fixed in 8.0.14. It was possible to create an inconsistent foreign key by adding a parent table with a different storage engine from the child table, then changing the parent table to the same storage engine as the child table.