Query produced warning - where can I see the warnings

myalo's profile image myalo posted 10 months ago in General Permalink

Running a query with 500 rows of insert I got a message box that the query produced 52 warnings. How can I see the warnings? Thanks

ansgar's profile image ansgar posted 10 months ago Permalink

That message dialog should have a button "Yes" which displays the warnings in a new tab:

Description

If you don't get that question/button, it may be the case that SHOW WARNINGS does not return all warnings.

In any case, you can get warnings through that SHOW WARNINGS query.

myalo's profile image myalo posted 10 months ago Permalink

Hello I clicked on the Yes, and nothing showed. I opened a new query window and typed SHOW WARNINGS and nothing showed. Please advise Thank you

ansgar's profile image ansgar posted 10 months ago Permalink

I'm not sure, but HeidiSQL fires a SELECT @max_error_count when the dialog appears, and this could cause the "warnings pool" to be emptied. I am just trying to simplify that.

Code modification/commit 6d3f24b from Ansgar Becker <anse@heidisql.com>, 10 months ago, revision 12.6.0.6794
Fix emptied "SHOW WARNINGS" pool due to queried @max_error_count in warning dialog. See https://www.heidisql.com/forum.php?t=41753
ansgar's profile image ansgar posted 10 months ago Permalink

Please update to the next build in an hour to get my latest bugfix (Help > Check for updates > Download and install build xyz).

Warnings should now be displayed when you click that "yes" button.

1 attachment(s):
  • query-warnings-fixed
myalo's profile image myalo posted 10 months ago Permalink

Downloading now. I will test and let you know. THANKS

Please login to leave a reply, or register at first.