Bug #11242 | Error 1005 while creating table | ||
---|---|---|---|
Submitted: | 10 Jun 2005 12:35 | Modified: | 10 Jun 2005 14:20 |
Reporter: | [ name withheld ] (Basic Quality Contributor) | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.6 | OS: | Windows (WindowsXP) |
Assigned to: | CPU Architecture: | Any |
[10 Jun 2005 12:35]
[ name withheld ]
[10 Jun 2005 14:20]
MySQL Verification Team
Hello, Thank you for the report, but this is not a bug. You defined column as NOT NULL but try to create foreign key constraint with ON DELETE SET NULL. Use SHOW INNODB STATUS to see latest foreign key error.