Bug #1957 Can't use 'TYPES' as a table name in
Submitted: 26 Nov 2003 2:52 Modified: 26 Nov 2003 11:45
Reporter: Phil Sladen Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version: OS:Linux (Linux 9.0)
Assigned to: CPU Architecture:Any

[26 Nov 2003 2:52] Phil Sladen
'TYPES' was ok as a table name in version 4.0.15.

I've had to rename such tables via mysqldump in all my databases and recompile my application.

How to repeat:
If you don't already have a table called 'TYPES' then just trying to create such a table also displays an error:

mysql> create table TYPES (i int);
[26 Nov 2003 11:45] Dean Ellis
TYPES is on the list of Reserved Words, and is (of course) actually reserved in 4.1.  You can continue to use reserved words provided you escape them properly.

Thank you.