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

Importing InnoDB table from 10.1 to 10.2 causes Schema mismatch (Expected FSP_SPACE_FLAGS=0x21, .ibd file contains 0x0

    Details

      Description

      See attached test case that creates table and exports it, this should be run on 10.1 (attached also resulting t0.ibd). Second test case should be run on 10.2 to try import file created above but it fails. Note that final test case should test also row_format=compressed,
      encrypted and encrypted+compressed cases.

      set global innodb_file_format = 'Barracuda';
      set global innodb_file_per_table=ON;
      create table t0 (c1 int not null auto_increment primary key, b char(200)) engine=innodb;
      alter table t0 discard tablespace;
      alter table t0 import tablespace;
      encryption.jan2 'innodb'                 [ fail ]
              Test ended at 2018-01-24 11:19:34
       
      CURRENT_TEST: encryption.jan2
      mysqltest: At line 12: query 'alter table t0 import tablespace' failed: 1808: Schema mismatch (Expected FSP_SPACE_FLAGS=0x21, .ibd file contains 0x0.)
      

        Attachments

        1. jan2.test
          0.4 kB
        2. jan2.test
          0.3 kB
        3. t0.ibd
          96 kB

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                jplindst Jan Lindström
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated: