Bug #70280 sql_safe_updates fails when set in global scope

• Submitted: 9 Sep 2013 21:21
• Modified: 9 Sep 2013 21:41
• Reporter: monty solomon
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.5.31
• OS: Linux (CentOS release 6.3)
• CPU Architecture: Any

[9 Sep 2013 21:21] monty solomon

Description:
The sql_safe_updates variable does not work when set in global scope.

How to repeat:
mysql> set global sql_safe_updates=1;
Query OK, 0 rows affected (0.00 sec)

mysql> show global variables like 'sql_safe_updates';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| sql_safe_updates | ON    |
+------------------+-------+
1 row in set (0.00 sec)

mysql> delete from t2;
Query OK, 16 rows affected (0.00 sec)

[9 Sep 2013 21:41] monty solomon

The global variable change does not affect the session variable for any client that is currently connected.