Bug #2384 | False SQL Syntax error report by MySQL Server when Using Date format Columns | ||
---|---|---|---|
Submitted: | 14 Jan 2004 6:11 | Modified: | 14 Jan 2004 7:47 |
Reporter: | Jattie van der Linde | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 4.0.17-nt | OS: | Windows (Win32) |
Assigned to: | Dean Ellis | CPU Architecture: | Any |
[14 Jan 2004 6:11]
Jattie van der Linde
[14 Jan 2004 6:33]
Jattie van der Linde
On Closer investigation it seems that the culprit field type is not the Date field but the "long text" field. The results are the same as described above however.
[14 Jan 2004 7:47]
Dean Ellis
This is not a bug; INDEX is documented as a reserved word and must be escaped when used as an identifier. I am unable to repeat the behavior of a query allowing INDEX to be used unescaped.
[15 Jan 2004 1:10]
Jattie van der Linde
Thanks, and embaressing oversight. Should've thought about it!