MySQL Bugs: #56511: crash after restarting server once; error Code 1175 ever from Workbenck 5.2.26

Bug #56511	crash after restarting server once; error Code 1175 ever from Workbenck 5.2.26
Submitted:	2 Sep 2010 17:38	Modified:	2 Sep 2010 22:59
Reporter:	Roberto Cobo	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.1.46	OS:	Linux (fedora 12)
Assigned to:		CPU Architecture:	Any
Tags:	update safe mode workbench

Description:
first it is not letting me truncate a table; but it is possible from other computer. I'm using Workbench but the other pc is using db visualizer ( jdbc as well as I undertand.

After trying a clean start up, using /etc/init.d/mysqld stop ; /etc/init.d/mysqld start, I've got the crash.

Trying to repeat problem , it doesn't crash but:
truncate qlearning.muestra;

Error Code: 1175
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

How to repeat:
truncate qlearning.muestra;

Error Code: 1175
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

More info: seems to be clear that Workbench is guilty as this MS-DOS command demostrates:

C:\Documents and Settings\n052328.PRBES\My documents\kk\esp\linux>mysql -u root -p -h 180.5.14.207 qlearning
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.1.48 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> truncate muestra;
Query OK, 0 rows affected (0.06 sec)

mysql>

Sorry for my ignorance:

Effectively, there is an option under workbench preferences that reads:
Forbit update and delete statements without a where clause....

Excuses for your waste of time reading this.

Best regards

Thank you for the feedback.