Debian Codegraph @

mysql-test/suite/innodb/r/101_compatibility.result

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