1# 2# MDEV-11623 MariaDB 10.1 fails to start datadir created with 3# MariaDB 10.0/MySQL 5.6 using innodb-page-size!=16K 4# 5CREATE TABLE tr(a INT)ENGINE=InnoDB ROW_FORMAT=REDUNDANT; 6CREATE TABLE tc(a INT)ENGINE=InnoDB ROW_FORMAT=COMPACT; 7CREATE TABLE td(a INT)ENGINE=InnoDB ROW_FORMAT=DYNAMIC; 8SET INNODB_STRICT_MODE=OFF; 9CREATE TABLE tz(a INT)ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1; 10SET INNODB_STRICT_MODE=ON; 11CREATE TABLE tdd(a INT) ENGINE=InnoDB, DATA DIRECTORY='MYSQL_TMP_DIR'; 12CREATE TABLE tp(a INT) ENGINE=InnoDB ROW_FORMAT=DYNAMIC PAGE_COMPRESSED=1; 13CREATE TABLE ti(a INT) ENGINE=InnoDB; 14FLUSH TABLES ti FOR EXPORT; 15backup: ti 16UNLOCK TABLES; 17ALTER TABLE ti DISCARD TABLESPACE; 18restore: ti .ibd and .cfg files 19ALTER TABLE ti IMPORT TABLESPACE; 20BEGIN; 21INSERT INTO tr VALUES(1); 22INSERT INTO tc VALUES(1); 23INSERT INTO td VALUES(1); 24INSERT INTO tz VALUES(1); 25INSERT INTO tdd VALUES(1); 26INSERT INTO tp VALUES(1); 27INSERT INTO ti VALUES(1); 28# Kill the server 29# restart 30CHECK TABLE tr,tc,td,tz,tdd,tp,ti; 31Table Op Msg_type Msg_text 32test.tr check status OK 33test.tc check status OK 34test.td check status OK 35test.tz check status OK 36test.tdd check status OK 37test.tp check status OK 38test.ti check status OK 39# restart: --innodb-read-only 40CHECK TABLE tr,tc,td,tz,tdd,tp,ti; 41Table Op Msg_type Msg_text 42test.tr check status OK 43test.tc check status OK 44test.td check status OK 45test.tz check status OK 46test.tdd check status OK 47test.tp check status OK 48test.ti check status OK 49# restart 50DROP TABLE tr,tc,td,tz,tdd,tp,ti; 51