Bug #4087

Comma not recognized after PRIMARY KEY statement

Details

Submitted	2005-04-06 19:47 UTC
From	epte at ruffdogs dot com
Assigned	cybot
Status	Closed
Package	SQL_Parser
PHP Version	Irrelevant
Roadmaps	0.5.1

Comments

[2005-04-06 19:47 UTC] epte at ruffdogs dot com

Description:
------------
This sql breaks:

Reproduce code:
---------------
CREATE TABLE `mpn_bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`),
KEY `idxbannerfinishcid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Actual result:
--------------
Parse error: Expected identifier on line 9
PRIMARY KEY (`bid`),
^ found: ","