Debian Codegraph @

mysql-test/suite/innodb/r/partition_import_57.result

raw
1 #
2 # Import regular and partitioned tablespaces exported from 5.7 after a restart.
3 #
4 CREATE SCHEMA `import80`;
5 USE `import80`;
6 CREATE TABLE `t1` (`c1` INT);
7 CREATE TABLE `t2` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='MYSQL_TMP_DIR/external_dir';
8 CREATE TABLE `t3` (`c1` INT) PARTITION BY KEY (`c1`) PARTITIONS 2;
9 CREATE TABLE `t4` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='MYSQL_TMP_DIR/external_dir' PARTITION BY HASH (`c1`) PARTITIONS 2;
10 CREATE TABLE `t5` (`c1` INT);
11 INSERT INTO `t5` values (1);
12 CREATE TABLE `t6` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='MYSQL_TMP_DIR/external_dir';
13 INSERT INTO `t6` values (1, 1);
14 CREATE TABLE `t7` (`c1` INT) PARTITION BY KEY (`c1`) PARTITIONS 2;
15 INSERT INTO `t7` values (1);
16 CREATE TABLE `t8` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='MYSQL_TMP_DIR/external_dir' PARTITION BY HASH (`c1`) PARTITIONS 2;
17 INSERT INTO `t8` values (1, 1);
18 FLUSH TABLES `t5`, `t6`, `t7`, `t8` FOR EXPORT;
19 # Copy cfg and ibd files for `t5` to MYSQL_TMP_DIR/export80.
20 # Copy cfg and ibd files for `t6` to MYSQL_TMP_DIR/export80.
21 # Copy cfg and ibd files for `t7` to MYSQL_TMP_DIR/export80.
22 # Copy cfg and ibd files for `t8` to MYSQL_TMP_DIR/export80.
23 UNLOCK TABLES;
24 ALTER TABLE `t1` DISCARD TABLESPACE;
25 ALTER TABLE `t2` DISCARD TABLESPACE;
26 ALTER TABLE `t3` DISCARD TABLESPACE;
27 ALTER TABLE `t4` DISCARD TABLESPACE;
28 ALTER TABLE `t5` DISCARD TABLESPACE;
29 ALTER TABLE `t6` DISCARD TABLESPACE;
30 ALTER TABLE `t7` DISCARD TABLESPACE;
31 ALTER TABLE `t8` DISCARD TABLESPACE;
32 # Unzip exported 5.7 partitioned tables to MYSQL_TMP_DIR.
33 # Copy exported v5.7 t1 files to MYSQLD_DATADIR/import80.
34 # Copy exported v5.7 t2 files to MYSQL_TMP_DIR/external_dir/import80.
35 # Copy exported v5.7 t3 files to MYSQLD_DATADIR/import80.
36 # Copy exported v5.7 t4 files to MYSQL_TMP_DIR/external_dir/import80.
37 # Copy exported v8.0 t5 files to MYSQLD_DATADIR/import80.
38 # Copy exported v8.0 t6 files to MYSQL_TMP_DIR/external_dir/import80.
39 # Copy exported v8.0 t7 files to MYSQLD_DATADIR/import80.
40 # Copy exported v8.0 t8 files to MYSQL_TMP_DIR/external_dir/import80.
41 # restart
42 ALTER TABLE `t1` IMPORT TABLESPACE;
43 select * from t1;
44 c1
45 1
46 ALTER TABLE `t2` IMPORT TABLESPACE;
47 select * from t2;
48 c1 c2
49 1 1
50 ALTER TABLE `t3` IMPORT TABLESPACE;
51 select * from t3;
52 c1
53 1
54 ALTER TABLE `t4` IMPORT TABLESPACE;
55 select * from t4;
56 c1 c2
57 1 1
58 ALTER TABLE `t5` IMPORT TABLESPACE;
59 select * from t5;
60 c1
61 1
62 ALTER TABLE `t6` IMPORT TABLESPACE;
63 select * from t6;
64 c1 c2
65 1 1
66 ALTER TABLE `t7` IMPORT TABLESPACE;
67 select * from t7;
68 c1
69 1
70 ALTER TABLE `t8` IMPORT TABLESPACE;
71 select * from t8;
72 c1 c2
73 1 1
74 # Cleanup
75 DROP TABLE `t1`, `t2`, t3, t4, `t5`, `t6`, t7, t8;
76 USE `test`;
77 DROP SCHEMA `import80`;