MySQL Bugs: #28466: Error message is unnecessary repetitive and long

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

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

Many thanks for writing a feature request. We will discuss this.

Bug #67588 was marked as duplicate of this one

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.