Query produced warning - where can I see the warnings

myalo's profile image myalo posted 3 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 3 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 3 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 3 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>, 3 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 3 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 3 months ago Permalink

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

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