Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11305

MariDB 10.2.2 errno: 140 "Wrong create options", when creating an innodb Table with 'ROW_FORMAT=FIXED' options

    XMLWordPrintable

    Details

      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

            People

            Assignee:
            greenman Ian Gilfillan
            Reporter:
            fduenas Francisco Dueñas
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: