MySQL Bugs: #77902: SHOW WARNINGS truncates

Bug #77902	SHOW WARNINGS truncates
Submitted:	31 Jul 2015 10:25	Modified:	10 May 2018 8:03
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:	5.6.25	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
It seems that SHOW WARNINGS has its output limited to a fixed buffer size or a fixed number of lines. I cannot find such limit documented anywhere.

However with a LOAD DATA statement you may get lots of warnings where the buffer does not suffice - one or more warning per row, actually, if data in the file and the table definition mismatch thus causing truncations.

How to repeat:
See for instance http://forums.webyog.com/index.php?showtopic=7893 for a real-life case.

Suggested fix:
Not sure if more than a docs clarification is needed here. But personally I'd prefer - at least - that the output of SHOW WARNINGS told something like "displaying details for *n* out of *m* warnigs" or similar.

does this help?   https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_error_coun...

Yes, it explains. I was not aware of that variable. Bad oversight by me as it is even referenced here https://dev.mysql.com/doc/refman/5.6/en/show-warnings.html. 

Even though I think that "65535" (a 16 bit integer) is a pretty low max_value nowadays

Peter it was the Shane's comment explained your issue?. Thanks.

Yes, it does (as I have already stated).

closing