Bug #59296 Reserved word not listed
Submitted: 5 Jan 2011 7:07 Modified: 5 Jan 2011 7:28
Reporter: Felix Paradis Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Parser Severity:S3 (Non-critical)
Version:5.5.6_1 OS:FreeBSD
Assigned to: CPU Architecture:Any
Tags: reserved words

[5 Jan 2011 7:07] Felix Paradis
Description:
Seems like "exif" is reserved but not documented

How to repeat:
mysql> CREATE TABLE `cpg14x_exwif` (   `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',   `exifData` text COLLATE utf8_unicode_ci NOT NULL,   UNIQUE KEY `filename` (`filename`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores EXIF data from individual pics';
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE `cpg14x_exif` (   `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',   `exifData` text COLLATE utf8_unicode_ci NOT NULL,   UNIQUE KEY `filename` (`filename`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores EXIF data from individual pics';
^CCtrl-C -- sending "KILL QUERY 154" to server ...
Ctrl-C -- query aborted.
ERROR 1317 (70100): Query execution was interrupted
[5 Jan 2011 7:28] Felix Paradis
No need