Bug #42401 | The server has returned this error message:You have an error in your SQL syntax | ||
---|---|---|---|
Submitted: | 28 Jan 2009 5:44 | Modified: | 2 Apr 2009 20:18 |
Reporter: | Cozta Nayl | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Parser | Severity: | S1 (Critical) |
Version: | 5.1, 6.0 bzr | OS: | Any (MS Windows 2008 Server, Linux) |
Assigned to: | CPU Architecture: | Any | |
Tags: | In Param, Naming Error, regression, stored procedure |
[28 Jan 2009 5:44]
Cozta Nayl
[28 Jan 2009 5:47]
Cozta Nayl
I forgot to mention, Version 5.1 win x64 on Windows 2008 Server
[28 Jan 2009 5:55]
MySQL Verification Team
smaller testcase: drop table if exists `t1`; create table `t1`(_filename int); quoting all params, fields in `backticks` works.
[28 Jan 2009 10:46]
Sveta Smirnova
Thank you for the report. Verified as described. Versions 4.1 and 5.0 are not affected.
[10 Mar 2009 4:37]
Tony Bojangles
I just ran into this bug. Any update on when it'll be fixed?
[2 Apr 2009 20:18]
Paul DuBois
_FILENAME is treated as a reserved word by the parser. This has been noted at: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html