| Subject: | Problem parsing MySQL table-options |
This is perl, v5.8.8 built for i386-linux-thread-multi
Linux theta 2.6.17-1.2139_FC5 #1 Fri Jun 23 12:40:16 EDT 2006 i686
athlon i386 GNU/Linux
When trying to parse a MySQL dump, with the following table definition:
CREATE TABLE `comment` (
`id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`comment` text NOT NULL,
`user_id` int(11) NOT NULL,
`ip` varchar(30) NOT NULL,
`date` timestamp NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Comments to an item' AUTO_INCREMENT=1 ;
SQL::Translator fails:
[SQL::Translator]
ERROR (line 38): Invalid statement: Was expecting comment, or use, or
set, or drop, or create, or alter, or insert
Removing the "COMMENT='Comments to an item'" section causes the SQL to
then work.