MySQL Bugs: #56660: Cannot delete all rows in a table ("safe update")

Bug #56660	Cannot delete all rows in a table ("safe update")
Submitted:	8 Sep 2010 16:07	Modified:	14 Sep 2010 4:45
Reporter:	Yves Goergen	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.27	OS:	Linux (Ubuntu 10.4 32bit)
Assigned to:		CPU Architecture:	Any

Description:
The query "delete from tablename" cannot be executed. The application says that "safe update mode" is active. Disabling that mode in the preferences has not effect. Starting with an empty script thereafter also has no effect.

How to repeat:
1. Open a new SQL editor
2. Try to execute "delete from tablename"
3. Disable safe update option in the application preferences
4. Repeat the query

Did you reconnect after disabling Safe Updates?

No, I did not reconnect. I had my script open and needed to submit those queries.

PS I didn't even know that those "newbie" features (?) exist. I thought I could just enter that query and have it executed.

Setting severity from 1 to 2. Workaround: Use the commandline MySQL client to get the work done.

Thank you for the bug report. Reconnecting is the work-around.

This is actually "not a bug", since you need to reconnect for the option to take effect.
But i'm marking as duplicate of bug #56159, as it'd be better if the UI gave a hint about that.