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

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

          fduenas Francisco Dueñas created issue -
          elenst Elena Stepanova made changes -
          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 ]
          greenman Ian Gilfillan made changes -
          Fix Version/s N/A [ 14700 ]
          Resolution Not a Bug [ 6 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 78337 ] MariaDB v4 [ 151229 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.