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

Aria ROW_FORMAT=FIXED + LONG bug

    XMLWordPrintable

Details

    Description

      The Aria storage engine is supposed to accept ROW_FORMAT=FIXED on tables that don't contain BLOB or TEXT fields; however it fails back to ROW_FORMAT=PAGE when a LONG datatype is present.

      CREATE TABLE a (
      foo INT NOT NULL
      )
      ENGINE=Aria ROW_FORMAT=FIXED;

      CREATE TABLE b (
      foo LONG NOT NULL
      )
      ENGINE=Aria ROW_FORMAT=FIXED;

      SHOW TABLE STATUS;
      ^ Note the Row_format and Create_options fields

      Attachments

        Activity

          People

            Unassigned Unassigned
            mnarine Micael Narine
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.