Bug #6572 SHOW ERRORS doesn't
Submitted: 11 Nov 2004 10:45 Modified: 23 Feb 2005 18:54
Reporter: Carsten Pedersen
Status: Closed
Category:Server Severity:S2 (Serious)
Version:4.1.7-standard OS:Linux (SuSE Linux 9.1)
Assigned to: Sergey Gluhov Target Version:

[11 Nov 2004 10:45] Carsten Pedersen 
Description:
SHOW ERRORS consistently returns "Empty Set"

SHOW WARNINGS shows only warnings, not errors

How to repeat:
mysql> create table t (i);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at line 1
mysql> show errors;
Empty set (0.00 sec)

mysql> create table t (i int) engine=blah;
ERROR 1286 (42000): Unknown table engine 'blah'

mysql> create table t (i int not null primary key);
Query OK, 0 rows affected (0.11 sec)

mysql> insert into t values (1), (1);
ERROR 1062 (23000): Duplicate entry '1' for key 1
mysql> show warnings;
Empty set (0.00 sec)

mysql> show errors;
Empty set (0.00 sec)
[23 Feb 2005 17:15] Sergey Gluhov 
Fixed in 4.1.11
[23 Feb 2005 18:54] Paul DuBois 
Noted in 4.1.11 changelog.