Debian Codegraph @

mysql-test/suite/innodb/t/partition_import_57.test

raw
1 --echo #
2 --echo # Import regular and partitioned tablespaces exported from 5.7 after a restart.
3 --echo #
4
5 # The following SQL was used to create the tables on 5.7
6 # CREATE SCHEMA `export57`;
7 # USE `export57`;
8 # CREATE TABLE `t1` (`c1` INT);
9 # INSERT INTO `t1` values (1);
10 # CREATE TABLE `t2` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY '/tmp/data57';
11 # INSERT INTO `t2` values (1, 1);
12 # CREATE TABLE `t3` (`c1` INT) PARTITION BY KEY (`c1`) PARTITIONS 2;
13 # INSERT INTO `t3` values (1);
14 # CREATE TABLE `t4` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY '/tmp/data57' PARTITION BY HASH (`c1`) PARTITIONS 2;
15 # INSERT INTO `t4` values (1, 1);
16 # FLUSH TABLES `t1`, `t2`, `t3`, `t4` FOR EXPORT;
17 #
18 # Copy all .cfg and .ibd files for t1 and t3 files to /tmp/data57/export57
19 # /tmp/data57> zip -qr data57_exported.zip export57
20 # Copy data57_exported.zip to {branch mysql-8.0} mysql-test/std_data/data57_exported.zip
21 #
22 # UNLOCK TABLES;
23 # DROP TABLE `t1`, `t2`, `t3`, `t4`;
24
25 --source include/have_innodb_16k.inc
26 --let $MYSQLD_DATADIR = `select @@datadir`
27 --let $EXTERNAL_DIR = $MYSQL_TMP_DIR/external_dir
28
29 CREATE SCHEMA `import80`;
30 USE `import80`;
31
32 CREATE TABLE `t1` (`c1` INT);
33
34 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
35 eval CREATE TABLE `t2` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='$EXTERNAL_DIR';
36
37 CREATE TABLE `t3` (`c1` INT) PARTITION BY KEY (`c1`) PARTITIONS 2;
38
39 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
40 eval CREATE TABLE `t4` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='$EXTERNAL_DIR' PARTITION BY HASH (`c1`) PARTITIONS 2;
41
42 CREATE TABLE `t5` (`c1` INT);
43 INSERT INTO `t5` values (1);
44
45 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
46 eval CREATE TABLE `t6` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='$EXTERNAL_DIR';
47 INSERT INTO `t6` values (1, 1);
48
49 CREATE TABLE `t7` (`c1` INT) PARTITION BY KEY (`c1`) PARTITIONS 2;
50 INSERT INTO `t7` values (1);
51
52 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
53 eval CREATE TABLE `t8` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='$EXTERNAL_DIR' PARTITION BY HASH (`c1`) PARTITIONS 2;
54 INSERT INTO `t8` values (1, 1);
55
56 FLUSH TABLES `t5`, `t6`, `t7`, `t8` FOR EXPORT;
57 --mkdir $MYSQL_TMP_DIR/export80/
58 --echo # Copy cfg and ibd files for `t5` to MYSQL_TMP_DIR/export80.
59 --copy_files_wildcard $MYSQLD_DATADIR/import80/ $MYSQL_TMP_DIR/export80/ t5*
60 --echo # Copy cfg and ibd files for `t6` to MYSQL_TMP_DIR/export80.
61 --copy_files_wildcard $EXTERNAL_DIR/import80/ $MYSQL_TMP_DIR/export80/ t6*
62 --echo # Copy cfg and ibd files for `t7` to MYSQL_TMP_DIR/export80.
63 --copy_files_wildcard $MYSQLD_DATADIR/import80/ $MYSQL_TMP_DIR/export80/ t7*
64 --echo # Copy cfg and ibd files for `t8` to MYSQL_TMP_DIR/export80.
65 --copy_files_wildcard $EXTERNAL_DIR/import80/ $MYSQL_TMP_DIR/export80/ t8*
66 UNLOCK TABLES;
67
68 ALTER TABLE `t1` DISCARD TABLESPACE;
69 ALTER TABLE `t2` DISCARD TABLESPACE;
70 ALTER TABLE `t3` DISCARD TABLESPACE;
71 ALTER TABLE `t4` DISCARD TABLESPACE;
72 ALTER TABLE `t5` DISCARD TABLESPACE;
73 ALTER TABLE `t6` DISCARD TABLESPACE;
74 ALTER TABLE `t7` DISCARD TABLESPACE;
75 ALTER TABLE `t8` DISCARD TABLESPACE;
76
77 --echo # Unzip exported 5.7 partitioned tables to MYSQL_TMP_DIR.
78 --copy_file $MYSQLTEST_VARDIR/std_data/data57_exported.zip $MYSQL_TMP_DIR/data57_exported.zip
79 --file_exists $MYSQL_TMP_DIR/data57_exported.zip
80 --exec unzip -qo $MYSQL_TMP_DIR/data57_exported.zip -d $MYSQL_TMP_DIR
81
82 --echo # Copy exported v5.7 t1 files to MYSQLD_DATADIR/import80.
83 --copy_files_wildcard $MYSQL_TMP_DIR/export57/ $MYSQLD_DATADIR/import80/ t1*
84
85 --echo # Copy exported v5.7 t2 files to MYSQL_TMP_DIR/external_dir/import80.
86 --copy_files_wildcard $MYSQL_TMP_DIR/export57/ $EXTERNAL_DIR/import80/ t2*
87
88 --echo # Copy exported v5.7 t3 files to MYSQLD_DATADIR/import80.
89 --copy_files_wildcard $MYSQL_TMP_DIR/export57/ $MYSQLD_DATADIR/import80/ t3*
90
91 --echo # Copy exported v5.7 t4 files to MYSQL_TMP_DIR/external_dir/import80.
92 --copy_files_wildcard $MYSQL_TMP_DIR/export57/ $EXTERNAL_DIR/import80/ t4*
93
94 --echo # Copy exported v8.0 t5 files to MYSQLD_DATADIR/import80.
95 --copy_files_wildcard $MYSQL_TMP_DIR/export80/ $MYSQLD_DATADIR/import80/ t5*
96
97 --echo # Copy exported v8.0 t6 files to MYSQL_TMP_DIR/external_dir/import80.
98 --copy_files_wildcard $MYSQL_TMP_DIR/export80/ $EXTERNAL_DIR/import80/ t6*
99
100 --echo # Copy exported v8.0 t7 files to MYSQLD_DATADIR/import80.
101 --copy_files_wildcard $MYSQL_TMP_DIR/export80/ $MYSQLD_DATADIR/import80/ t7*
102
103 --echo # Copy exported v8.0 t8 files to MYSQL_TMP_DIR/external_dir/import80.
104 --copy_files_wildcard $MYSQL_TMP_DIR/export80/ $EXTERNAL_DIR/import80/ t8*
105
106 --source include/restart_mysqld.inc
107
108 ALTER TABLE `t1` IMPORT TABLESPACE;
109 select * from t1;
110
111 ALTER TABLE `t2` IMPORT TABLESPACE;
112 select * from t2;
113
114 ALTER TABLE `t3` IMPORT TABLESPACE;
115 select * from t3;
116
117 ALTER TABLE `t4` IMPORT TABLESPACE;
118 select * from t4;
119
120 ALTER TABLE `t5` IMPORT TABLESPACE;
121 select * from t5;
122
123 ALTER TABLE `t6` IMPORT TABLESPACE;
124 select * from t6;
125
126 ALTER TABLE `t7` IMPORT TABLESPACE;
127 select * from t7;
128
129 ALTER TABLE `t8` IMPORT TABLESPACE;
130 select * from t8;
131
132 --echo # Cleanup
133 DROP TABLE `t1`, `t2`, t3, t4, `t5`, `t6`, t7, t8;
134 USE `test`;
135 DROP SCHEMA `import80`;
136 --force-rmdir $EXTERNAL_DIR/import80
137 --force-rmdir $EXTERNAL_DIR
138 --force-rmdir $MYSQL_TMP_DIR/export57
139 --force-rmdir $MYSQL_TMP_DIR/export80
140 --remove_file $MYSQL_TMP_DIR/data57_exported.zip