Bug #36272 Error 1064 too long
Submitted: 23 Apr 2008 3:29 Modified: 23 Apr 2008 11:13
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Errors Severity:S4 (Feature request)
Version:5.1.24 OS:Windows (Vista)
Assigned to: CPU Architecture:Any
Tags: 1064, too long

[23 Apr 2008 3:29] Jared S

S4 request. I frequenlty debug my application and really would like a more simpler error message when I type bad sql text in.  Problem is that I am not always in Query Browser when error occurs so the error message is in much large font and almost consists of 90% meaningless infomation.

How to repeat:
1. Type "select 1 fro!m abc" into query browser

Suggested fix:
1064 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 '!m abc' at line 1

>>  Something like this would speed up debugging of SQL

1064 SQL syntax error near '!m abc' at line 1
[23 Apr 2008 11:13] MySQL Verification Team
Thank you for the bug report.