Bug #59221 "show warnings" statement does not appear to be working - returns 0 records

• Submitted: 29 Dec 2010 20:33
• Modified: 1 Sep 2011 16:25
• Reporter: Samir Abboushi
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S1 (Critical)
• Version: 5.2.30 CE Rev. 6790, 5.2.31
• OS: Any (Windows Vista 64, Mac OS X)
• CPU Architecture: Any
• Tags: show warnings

[29 Dec 2010 20:33] Samir Abboushi

Description:
LOAD DATA INFILE 'r:\\HCAD\\DATA\\20101205\\data\\building_other.txt' INTO TABLE HCAD20101205.building_other CHARACTER SET latin1;

Message:
188875 row(s) affected
Records: 188875  Deleted: 0  Skipped: 0  Warnings: 188875

executing "show warnings" results in 0 records

default for max_error_count is in effect (64)

How to repeat:
1) load data infile that results in warnings
2) executing "show warnings"

[30 Dec 2010 18:32] Valeriy Kravchuk

Thank you for the bug report. Verified with simple test case like this:

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

mysql> create table tt(c1 int);
Query OK, 0 rows affected (0.07 sec)

mysql> insert into tt values('abc');
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> show warnings\G
*************************** 1. row ***************************
  Level: Warning
   Code: 1366
Message: Incorrect integer value: 'abc' for column 'c1' at row 1
1 row in set (0.00 sec)

As you can see, we have a warning in this case in mysql command line client. Same actions in Workbench does not give any information about warnings in the Output tab, and SHOW WARNINGS returns nothing...

[24 Apr 2011 18:02] Alfredo Kojima

bug #60967 is a duplicate

[27 Apr 2011 11:55] Valeriy Kravchuk

Bug #60967 was marked as a duplicate of this one.

[1 Sep 2011 16:25] Philip Olson

Fixed as of 5.2.34:

+        A <literal>SHOW WARNINGS</literal> query would return zero
+        results, even when warnings existed.