Bug #94400 | Imported Foreign Keys don't work if defined before the referenced table | ||
---|---|---|---|
Submitted: | 19 Feb 2019 23:22 | Modified: | 1 Apr 2019 17:56 |
Reporter: | Tim Düsterhus | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S2 (Serious) |
Version: | 8.0.15 | OS: | Debian (mysql:8 Docker Container) |
Assigned to: | CPU Architecture: | x86 (amd64) |
[19 Feb 2019 23:22]
Tim Düsterhus
[19 Feb 2019 23:23]
Tim Düsterhus
dump.sql reproducing the issue
Attachment: dump.sql (application/sql, text), 524 bytes.
[19 Feb 2019 23:23]
Tim Düsterhus
Transcript of MySQL 5.7.25 showing no issue.
Attachment: mysql-5.txt (text/plain), 1.82 KiB.
[19 Feb 2019 23:23]
Tim Düsterhus
Transcript of MySQL 8.0.15 showing the issue.
Attachment: mysql-8.txt (text/plain), 1.86 KiB.
[19 Feb 2019 23:45]
MySQL Verification Team
Thank you for the bug report.
[11 Mar 2019 14:12]
Tim Düsterhus
I investigated a bit more and it appears that this is a regression within patch releases the MySQL 8 series: - It works fine with 8.0.13. - It does not work with 8.0.14.
[11 Mar 2019 14:13]
Tim Düsterhus
Transcript of MySQL 8.0.13 showing no issue.
Attachment: mysql-8.0.13.txt (text/plain), 1.86 KiB.
[11 Mar 2019 14:13]
Tim Düsterhus
Transcript of MySQL 8.0.14 showing the issue.
Attachment: mysql-8.0.14.txt (text/plain), 1.86 KiB.
[1 Apr 2019 17:56]
Paul DuBois
Posted by developer: Fixed in 8.0.16. Imported foreign keys did not work if defined before the referenced table.