|Subject:||MySQL parser does not recognize a create with an embedded comment before an auto_increment|
Consider the following SQL snippet: CREATE TABLE `city_hours` ( `id` integer(11) NOT NULL comment 'Each row is a datetime range during which Artists and Locations may book Performances for a given City.' auto_increment, `city_id` integer(11) NOT NULL ); SQL::Translator reports the following for that SQL: ERROR (line 1): Invalid statement: Was expecting comment, or use, or set, or drop, or create, or alter, or insert, or delimiter, or empty statement If I remove the "comment '.*'" clause, then it parses successfully. Other columns with comments are fine, just the auto_increment one fails.