Erroneous SET STATEMENT produces two identical errors

[Elena Stepanova]

MySQL [test]> set statement non_existing=1 for select 1;
ERROR 1193 (HY000): Unknown system variable 'non_existing'
MySQL [test]> show errors;
+-------+------+----------------------------------------+
| Level | Code | Message |
+-------+------+----------------------------------------+
| Error | 1193 | Unknown system variable 'non_existing' |
| Error | 1193 | Unknown system variable 'non_existing' |
+-------+------+----------------------------------------+
2 rows in set (0.00 sec)

MySQL [test]> select @@error_count;
+---------------+
| @@error_count |
+---------------+
| 2 |
+---------------+
1 row in set (0.01 sec)

It looks redundant.

[Valerii Kravchuk (valerii-kravchuk)]

This is easy to confirm:

mysql> select version();
+-------------+
| version() |
+-------------+
| 5.6.21-69.0 |
+-------------+
1 row in set (0.03 sec)

mysql> set statement non_existing=1 for select 1;
ERROR 1193 (HY000): Unknown system variable 'non_existing'
mysql> show errors;
+-------+------+----------------------------------------+
| Level | Code | Message |
+-------+------+----------------------------------------+
| Error | 1193 | Unknown system variable 'non_existing' |
| Error | 1193 | Unknown system variable 'non_existing' |
+-------+------+----------------------------------------+
2 rows in set (0.00 sec)

mysql> select @@error_count;
+---------------+
| @@error_count |
+---------------+
| 2 |
+---------------+
1 row in set (0.00 sec)

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2096