Bug #111965 | default NULL column leads to foreign key constraint failure | ||
---|---|---|---|
Submitted: | 4 Aug 2023 2:43 | Modified: | 4 Aug 2023 7:31 |
Reporter: | Huaxiong Song (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
Version: | 8.0.34, 5.7.43 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[4 Aug 2023 2:43]
Huaxiong Song
[4 Aug 2023 7:31]
MySQL Verification Team
Hello Huaxiong Song, Thank you for the report and steps. Verified as described. regards, Umesh
[7 Aug 2023 12:33]
huahua xu
It is not a issue. If any of the foreign key fields in entry is SQL NULL, the innodb suppress the foreign key check which is compatible with Oracle. Reference the document: https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html