MySQL Bugs: #31016: Syntax error should not replace server warnings.

Bug #31016	Syntax error should not replace server warnings.
Submitted:	14 Sep 2007 4:16	Modified:	16 Sep 2007 5:35
Reporter:	Tobias Asplund	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S4 (Feature request)
Version:	5.0.45	OS:	MacOS
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
A statement that generates warnings, followed by a mis-spelled SHOW WARNINGS command loses the warnings forever...

How to repeat:
SET SQL_MODE = 'ERROR_FOR_DIVISION_BY_ZERO';
SELECT 1/0;
-- oops, we're mis-spelling it!
show wranings;
show warnings;

Suggested fix:
Don't overwrite the buffer with syntax errors, since they could prove to just be mis-spelled SHOW WARNING commands.

Thank you for a reasonable feature request.