MySQL Bugs: #60967: MySQL Workbench clears the message list (errors, warnings, notes)

Bug #60967	MySQL Workbench clears the message list (errors, warnings, notes)
Submitted:	24 Apr 2011 14:51	Modified:	24 Apr 2011 18:02
Reporter:	tom worster	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.33	OS:	MacOS (10.6.7)
Assigned to:		CPU Architecture:	Any
Tags:	message list, show warnings, warning message

Description:
When I run these two commands in a query Scratch Area both together (e.g. select both and Command-Shift-Return, on my Mac), then Workbench returns the expected message in the query result:

drop table if exists no_such_table; show warnings;

But if I run them one at a time with a pause between then show warnings returns an empty set.

The above example is trivial but if I run a long query affecting millions of rows and the output shown in the Actions table indicates MySQL server gave a few warnings then I would like to be able to review them (without add show warnings after each query just in case).

How to repeat:
Run these together and observe the query result:

drop table if exists no_such_table; show warnings;

Then run them separately with a pause between:

drop table if exists no_such_table;

--pause--

show warnings;

and note that the messages table is empty.

Suggested fix:
The manual says in 12.4.5.41. SHOW WARNINGS Syntax: "a statement that uses a table but generates no messages clears the message list." My wild guess is that MySQL Workbench is performing some such query in the background. Beyond that I've no suggestions, sorry.

Thank you for the bug report.

this is a duplicate of bug #59221