MySQL Bugs: #67302: Multiple table drops, doesn't refresh properly if it fails to drop one of the ta

Bug #67302	Multiple table drops, doesn't refresh properly if it fails to drop one of the ta
Submitted:	19 Oct 2012 16:44	Modified:	19 Nov 2012 20:05
Reporter:	Chris Shepherd	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.44	OS:	Mac OS X (Darwin 11.4.2)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
When I am in a database and I have multiple tables selected and choose to drop them. 
Sometimes it will fail because one ore more of my tables might have a forign key constraint that prevents it from being removed. When this happens it tells me
it failed to remove because of XYZ table. However the tables before that were deleted. When I close the window, the old tables which had been removed are still showing until I hit refresh.	

----- Developer Notes -----

MySQL Workbench CE for Mac OS X version 5.2.44  revision 9933
Configuration Directory: /Users/chris/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.9.1
OS: Darwin 11.4.2
CPU: 8x Intel(R) Core(TM) i7-2760QM CPU @ 2.40GHz, 8.0 GB RAM

How to repeat:
Setup 3 tables. Table A, Table B, Table C. Setup a foriegn key linking C.field to B.field. Then select all three of those tables and choose to drop table.

 It will start dropping tehme in order. However will not finish, because it will be unable to remove table B. When the screen comes up and you close it you will
still see Table A in the left column under schemas. You will have to manually refresh it to see it was removed.

Thank you for the bug report. This happens with alive server or modeling?. Thanks.

It happens with a live server, not modeling.

Thank you for the feedback and if you perform before the drop table the
set foreign_key_checks=0; command it works?
1
mysql 5.7 >show variables like "foreign_key_checks";
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| foreign_key_checks | ON    |
+--------------------+-------+
1 row in set (0.01 sec)

mysql 5.7 >set foreign_key_checks=0;
Query OK, 0 rows affected (0.00 sec)

mysql 5.7 >show variables like "foreign_key_checks";
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| foreign_key_checks | OFF   |
+--------------------+-------+
1 row in set (0.01 sec)

mysql 5.7 >

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".