Bug #1383 | some aliases cause a syntax error | ||
---|---|---|---|
Submitted: | 23 Sep 2003 9:50 | Modified: | 25 Sep 2003 12:34 |
Reporter: | Joerg Albrecht | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.1 | OS: | Windows (WIN2k) |
Assigned to: | CPU Architecture: | Any |
[23 Sep 2003 9:50]
Joerg Albrecht
[25 Sep 2003 12:34]
Indrek Siitan
"mod" (a mathematical operation) has been added to the list of reserved words in 4.1. To overcome the problem, enclose the reserved word in backticks, e.g.: SELECT mod.MOD_ID FROM modules AS `mod` WHERE 1;