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:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.27 OS:Linux (Ubuntu 10.4 32bit)
Assigned to: CPU Architecture:Any

[8 Sep 2010 16:07] Yves Goergen
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
[8 Sep 2010 16:08] Alfredo Kojima
Did you reconnect after disabling Safe Updates?
[8 Sep 2010 16:24] Yves Goergen
No, I did not reconnect. I had my script open and needed to submit those queries.
[8 Sep 2010 16:26] Yves Goergen
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.
[9 Sep 2010 0:16] MySQL Verification Team
Thank you for the bug report. Reconnecting is the work-around.
[14 Sep 2010 4:45] Alfredo Kojima
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.