Bug #68108 Executing dump file ignores /*!40014 SET FOREIGN_KEY_CHECKS=0 */;
Submitted: 17 Jan 2013 17:49 Modified: 1 Feb 2013 6:08
Reporter: Ken Allen Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.44 OS:Mac OS X (10.8.2)
Assigned to: CPU Architecture:Any

[17 Jan 2013 17:49] Ken Allen
Description:
Produced a dump file from one system, which includes the following line (actually editing to remove the saving of the previous setting; forced back to 1 at the end of the script in a similar comment):

/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

When dump file execute in SQLWorkBench, it fails on one of the tables with this error:

Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails

If I execute the same file from the command line interface, it executes without error!

How to repeat:
Simply execute a dump file that involved referential integrity; fails in the work bench but will succeed from the command line.
[1 Feb 2013 6:08] Umesh Shastry
Hello Ken,

Thank you for the report.

I can not repeat described behavior on 5.2.45

Regards,
Umesh
[1 Feb 2013 6:09] Umesh Shastry
Activity log used for 68108

Attachment: 68108.txt (text/plain), 7.77 KiB.