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

    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

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

                Dates

                • Created:
                  Updated: