Bug #12078 FK "on delete set null" bugs during restoration
Submitted: 21 Jul 2005 11:10 Modified: 21 Jul 2005 11:35
Reporter: Mickael Besson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.21 with MySQL 4.1.12a-nt OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[21 Jul 2005 11:10] Mickael Besson
Description:
restoration bugs when a table contains FK with "on delete set null"

How to repeat:
create 2 tables t1 and t2.
create a FK from t2 to t1 with "On Delete " "set null", Apply
create a normal backup (InnoDB Online Backup)
drop the database
restore the backup
-> PB with this FK

Suggested fix:
backup doesn't create the good syntax with this type of FK
[21 Jul 2005 11:35] Mickael Besson
Sorry it's correct. The restoration functions.
I've surely bad data in the DB.
This bug can be closed.