Debian Codegraph @

mysql-test/suite/innodb/t/101_compatibility.test

raw
1 --source include/innodb_page_size.inc
2 --source include/not_embedded.inc
3 --source include/have_symlink.inc
4
5 -- echo #
6 -- echo # MDEV-11623 MariaDB 10.1 fails to start datadir created with
7 -- echo # MariaDB 10.0/MySQL 5.6 using innodb-page-size!=16K
8 -- echo #
9
10 # This is actually testing the opposite: starting the fixed 10.1 with
11 # buggy 10.1 files (by manually converting the flags in the files).
12
13 --disable_query_log
14 call mtr.add_suppression("InnoDB: adjusting FSP_SPACE_FLAGS of file ");
15 FLUSH TABLES;
16 --enable_query_log
17 let INNODB_PAGE_SIZE=`select @@innodb_page_size`;
18 let MYSQLD_DATADIR=`select @@datadir`;
19
20 CREATE TABLE tr(a INT)ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
21 CREATE TABLE tc(a INT)ENGINE=InnoDB ROW_FORMAT=COMPACT;
22 CREATE TABLE td(a INT)ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
23 --disable_warnings
24 # ROW_FORMAT=COMPRESSED is not available with innodb_page_size>16k
25 SET INNODB_STRICT_MODE=OFF;
26 CREATE TABLE tz(a INT)ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
27 SET INNODB_STRICT_MODE=ON;
28 --enable_warnings
29
30 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
31 EVAL CREATE TABLE tdd(a INT) ENGINE=InnoDB, DATA DIRECTORY='$MYSQL_TMP_DIR';
32
33 CREATE TABLE tp(a INT) ENGINE=InnoDB ROW_FORMAT=DYNAMIC PAGE_COMPRESSED=1;
34 CREATE TABLE ti(a INT) ENGINE=InnoDB;
35 FLUSH TABLES ti FOR EXPORT;
36 perl;
37 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
38 ib_backup_tablespaces("test", "ti");
39 EOF
40 UNLOCK TABLES;
41 ALTER TABLE ti DISCARD TABLESPACE;
42 perl;
43 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
44 ib_discard_tablespaces("test", "ti");
45 ib_restore_tablespaces("test", "ti");
46 do "$ENV{MTR_SUITE_DIR}/include/crc32.pl";
47 do "$ENV{MTR_SUITE_DIR}/include/ibd_convert.pl";
48 my $ps = $ENV{INNODB_PAGE_SIZE};
49 my $dd = $ENV{MYSQLD_DATADIR};
50 convert_to_mariadb_101("$dd/test/ti.ibd", $ps);
51 EOF
52
53 ALTER TABLE ti IMPORT TABLESPACE;
54
55 BEGIN;
56 INSERT INTO tr VALUES(1);
57 INSERT INTO tc VALUES(1);
58 INSERT INTO td VALUES(1);
59 INSERT INTO tz VALUES(1);
60 INSERT INTO tdd VALUES(1);
61 INSERT INTO tp VALUES(1);
62 INSERT INTO ti VALUES(1);
63
64 --source include/kill_mysqld.inc
65
66 perl;
67 do "$ENV{MTR_SUITE_DIR}/include/crc32.pl";
68 do "$ENV{MTR_SUITE_DIR}/include/ibd_convert.pl";
69 my $ps = $ENV{INNODB_PAGE_SIZE};
70 my $dd = $ENV{MYSQLD_DATADIR};
71
72 convert_to_mariadb_101("$dd/ibdata1", $ps);
73 convert_to_mariadb_101("$dd/test/tr.ibd", $ps);
74 convert_to_mariadb_101("$dd/test/tc.ibd", $ps);
75 convert_to_mariadb_101("$dd/test/td.ibd", $ps);
76 convert_to_mariadb_101("$dd/test/tz.ibd", 1024) if $ps<32768;
77 convert_to_mariadb_101("$dd/test/tp.ibd", $ps);
78 convert_to_mariadb_101("$dd/test/ti.ibd", $ps);
79 convert_to_mariadb_101("$ENV{MYSQL_TMP_DIR}/test/tdd.ibd", $ps);
80 EOF
81
82 --source include/start_mysqld.inc
83 CHECK TABLE tr,tc,td,tz,tdd,tp,ti;
84 --source include/shutdown_mysqld.inc
85
86 perl;
87 do "$ENV{MTR_SUITE_DIR}/include/crc32.pl";
88 do "$ENV{MTR_SUITE_DIR}/include/ibd_convert.pl";
89 my $ps = $ENV{INNODB_PAGE_SIZE};
90 my $dd = $ENV{MYSQLD_DATADIR};
91
92 convert_to_mariadb_101("$dd/ibdata1", $ps);
93 convert_to_mariadb_101("$dd/test/tr.ibd", $ps);
94 convert_to_mariadb_101("$dd/test/tc.ibd", $ps);
95 convert_to_mariadb_101("$dd/test/td.ibd", $ps);
96 convert_to_mariadb_101("$dd/test/tz.ibd", 1024) if $ps<32768;
97 convert_to_mariadb_101("$dd/test/tp.ibd", $ps);
98 convert_to_mariadb_101("$dd/test/ti.ibd", $ps);
99 convert_to_mariadb_101("$ENV{MYSQL_TMP_DIR}/test/tdd.ibd", $ps);
100 EOF
101
102 --let $restart_parameters=--innodb-read-only
103 --source include/start_mysqld.inc
104 CHECK TABLE tr,tc,td,tz,tdd,tp,ti;
105 --source include/shutdown_mysqld.inc
106
107 --let $restart_parameters=
108 --source include/start_mysqld.inc
109 DROP TABLE tr,tc,td,tz,tdd,tp,ti;