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
• Status: Closed
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.0.21 with MySQL 4.1.12a-nt
• OS: Windows (Windows XP)
• 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.