Bug #6572 SHOW ERRORS doesn't

• Submitted: 11 Nov 2004 9:45
• Modified: 23 Feb 2005 17:54
• Reporter: Carsten Pedersen
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.7-standard
• OS: Linux (SuSE Linux 9.1)
• Assigned to: Sergei Glukhov
• CPU Architecture: Any

[11 Nov 2004 9: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 16:15] Sergei Glukhov

Fixed in 4.1.11

[23 Feb 2005 17:54] Paul DuBois

Noted in 4.1.11 changelog.