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

InnoDB produces wrong message or wrong row format upon attempt to create table with ROW_FORMAT=COMPRESSED and big page size

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      SET @file_format= @@innodb_file_format;
      SET GLOBAL innodb_file_format= Barracuda;
       
      CREATE TABLE t1 (a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
      SHOW WARNINGS;
      query_vertical SHOW TABLE STATUS LIKE 't1';
       
      # Cleanup
      DROP TABLE t1;
      SET GLOBAL innodb_file_format= @file_format;
      

      10.1 f1bcfbb4373

      CREATE TABLE t1 (a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
      Warnings:
      Warning	1478	InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=COMPACT.
       
      SHOW TABLE STATUS LIKE 't1';
      Name	t1
      Engine	InnoDB
      Version	10
      Row_format	Dynamic
      ...
      

      So, the warning says that the assumed format is COMPACT, but the created table has format Dynamic (or pretends to, see MDEV-17161).

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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