Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2.2
-
Windows 2012 server
Description
When trying to create an innodb table with this settings
CREATE TABLE `__syssequences` (
`systemName` CHAR(50) NOT NULL,
`sequenceName` CHAR(50) NOT NULL,
`sequenceStep` INT(11) DEFAULT '1',
`lastValue` INT(11) DEFAULT '1',
`lastInsert` DATETIME DEFAULT '0000-00-00 00:00:00',
`lastUpdate` DATETIME DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`systemName`,`sequenceName`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED
Can't create table `ezgobx`.`__syssequences` (errno: 140 "Wrong create options")
If I remove ROW_FORMAT=FIXED or set ROW_FORMAT=DEFAULT it works perfect. I used that creation option in mysql 5.6 wihout issues