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
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Component/s | Documentation [ 10903 ] | |
Component/s | Storage Engine - InnoDB [ 10129 ] | |
Component/s | Data Definition - Alter Table [ 10114 ] | |
Assignee | Ian Gilfillan [ greenman ] |
Fix Version/s | N/A [ 14700 ] | |
Resolution | Not a Bug [ 6 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 78337 ] | MariaDB v4 [ 151229 ] |