Bug #36272 Error 1064 too long

• Submitted: 23 Apr 2008 3:29
• Modified: 23 Apr 2008 11:13
• Reporter: Jared S (Silver Quality Contributor)
• Status: Verified
• Category: MySQL Server: Errors
• Severity: S4 (Feature request)
• Version: 5.1.24
• OS: Windows (Vista)
• CPU Architecture: Any
• Tags: 1064, too long

[23 Apr 2008 3:29] Jared S

Description:
Hi,

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.