Bug #28466 Error message is unnecessary repetitive and long
Submitted: 16 May 2007 11:43 Modified: 3 Apr 2009 11:37
Reporter: Jason Garrett Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Errors Severity:S4 (Feature request)
Version:5.0+ OS:Any (MS Windows, Linux)
Assigned to: CPU Architecture:Any
Tags: check, error, manual, message, repetitive, server, syntax, verbose, version
Triage: Needs Triage: D5 (Feature request)

[16 May 2007 11:43] Jason Garrett
Description:
The message produced when an error occurs in the MySQL Command Line client is too verbose, and repetitive.  In order to view the detail of the error, it is necessary to scroll the Command Prompt window to the right (Window Buffer set to large width to provide tidier formatting when querying)

Example:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NEW.active = 1 THEN
                                UPDATE locations SET totalPacketCount = totalPacketCo' at line 7

How to repeat:
Enter any invalid SQL statement.
Observe overly long error message

Suggested fix:
I recall in MySQL v3.23.58, the error message was shorter, and more to the point.
One does not need it suggested at every error, to refer to the manual.  

Suggest that the repetitive 'suggestive' text is removed.
Example Error message:
ERROR 1064 (42000): You have an error in your SQL syntax near 'IF NEW.active = 1 THEN
                                UPDATE locations SET totalPacketCount = totalPacketCo' at line 7
[3 Apr 2009 11:37] Susanne Ebrecht
Many thanks for writing a feature request. We will discuss this.
[15 Nov 2012 20:00] Sveta Smirnova
Bug #67588 was marked as duplicate of this one
[15 Nov 2012 21:08] matteo sisti sette
I wouldn't call this a feature request, I would call this a bug. Decent error reporting is basic.

It's not only a matter of length or shortness, please see the duplicate report
http://bugs.mysql.com/bug.php?id=67588

And wow, reported in 2007 and still there..... so I guess I'm actually wasting my time.