Bug #1957 Can't use 'TYPES' as a table name in 4.1.0.0

• Submitted: 26 Nov 2003 2:52
• Modified: 26 Nov 2003 11:45
• Reporter: Phil Sladen
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.0.0
• OS: Linux (Linux 9.0)
• CPU Architecture: Any

[26 Nov 2003 2:52] Phil Sladen

Description:
'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.