Bug #9898 | Can create table with name 'procedure' if the fully qualified name is used. | ||
---|---|---|---|
Submitted: | 14 Apr 2005 11:36 | Modified: | 15 Apr 2005 16:12 |
Reporter: | Disha | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.3 | OS: | Any (All) |
Assigned to: | Sergei Golubchik | CPU Architecture: | Any |
[14 Apr 2005 11:36]
Disha
[15 Apr 2005 16:12]
Sergei Golubchik
This is not a bug either. The logic is that test.procedure is unambiguous, just as `procedure` (or "procedure" in ANSI_QUOTES mode) - it could be only an identifier. That's why parser allows reserved words as identifiers if they are quoted (with backticks or double quotes) or qualified with db or table name. This is a very old feature, in fact, it exists since at least since 1998