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

Allow ROW_FORMAT=DYNAMIC in the InnoDB system tablespace

    XMLWordPrintable

Details

    Description

      When MySQL 5.7 introduced innodb_default_row_format and made ROW_FORMAT=DYNAMIC the default, it became possible to create any ROW_FORMAT tables in the InnoDB system tablespace, except ROW_FORMAT=COMPRESSED.

      See for example the file mysql-test/suite/innodb/r/create_tablespace.result which contains the following line:

      test/t_system        innodb_system   33      5       Dynamic 0       System
      

      For logical behaviour, we should stop refusing explicitly specified ROW_FORMAT=DYNAMIC when innodb_file_per_table=0.
      (We should still reject ROW_FORMAT=DYNAMIC and ROW_FORMAT=COMPRESSED when the deprecated setting innodb_file_format=Antelope is in effect.)

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              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.