mysql - 将系统变量 'sql_warnings'设置为0，为什么还是报错？

Question

重新创建 SQL:

drop table t1;

set sql_mode = '';
create table t1 (c1 int, c2 int); 
set sql_warnings = 0;
SHOW VARIABLES LIKE '%sql_warnings%';
insert into t1 values(1,'b');

set sql_warnings = 1;
SHOW VARIABLES LIKE '%sql_warnings%';
insert into t1 values(1,'b');

输出:

mysql> create table t1 (c1 int, c2 int);
Query OK, 0 rows affected (0.01 sec)

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

mysql> SHOW VARIABLES LIKE '%sql_warnings%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_warnings  | OFF   |
+---------------+-------+
1 row in set, 1 warning (0.01 sec)

mysql> insert into t1 values(1,'b');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql>
mysql> set sql_warnings = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE '%sql_warnings%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_warnings  | ON    |
+---------------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> insert into t1 values(1,'b');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.8-rc  |
+-----------+
1 row in set (0.00 sec)

从输出来看，无论将 sql_warnings 设置为 0 还是 1，我总是在 INSERT 语句中收到警告。谁知道为什么？

更新:

“SHOW VARIABLES LIKE '%sql_warnings%';”的结果上面加了。

Answer 1

向 MySQL 提交了一个错误，他们将其验证为版本 5.0 到 5.7 的错误。

http://bugs.mysql.com/bug.php?id=80404

我很好奇为什么以前没有发现这种明显的行为。