Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 let $MYSQLD_DATADIR = `SELECT @@datadir`;
4
5 --echo #
6 --echo # MDEV-26137 ALTER TABLE IMPORT enhancement
7 --echo #
8
9 --echo # drop t1 before importing t2
10 CREATE TABLE t1 (a int) ENGINE=InnoDB;
11 INSERT INTO t1 VALUES(42);
12 FLUSH TABLES t1 FOR EXPORT;
13 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
14 --copy_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/t2.frm
15 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
16 UNLOCK TABLES;
17 DROP TABLE t1;
18 ALTER TABLE t2 IMPORT TABLESPACE;
19 SHOW CREATE TABLE t2;
20 SELECT * FROM t2;
21 DROP TABLE t2;
22
23 --echo # created t2 but did not discard tablespace
24 CREATE TABLE t1 (a int) ENGINE=InnoDB;
25 INSERT INTO t1 VALUES(42);
26 CREATE TABLE t2 LIKE t1;
27 FLUSH TABLES t1 FOR EXPORT;
28 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
29 UNLOCK TABLES;
30 DROP TABLE t1;
31 call mtr.add_suppression("InnoDB: Unable to import tablespace");
32 --error ER_TABLESPACE_EXISTS
33 ALTER TABLE t2 IMPORT TABLESPACE;
34 SHOW CREATE TABLE t2;
35 SELECT * FROM t2;
36 DROP TABLE t2;
37
38 --echo # attempt to import when there's no tablespace
39 --error ER_NO_SUCH_TABLE
40 ALTER TABLE t2 IMPORT TABLESPACE;
41
42 --echo # with index
43 CREATE TABLE t1 (a int, b varchar(50)) ENGINE=InnoDB;
44 CREATE UNIQUE INDEX ai ON t1 (a);
45 INSERT INTO t1 VALUES(42, "hello");
46 FLUSH TABLES t1 FOR EXPORT;
47 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
48 --copy_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/t2.frm
49 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
50 UNLOCK TABLES;
51 ALTER TABLE t2 IMPORT TABLESPACE;
52 SHOW CREATE TABLE t2;
53 SELECT * FROM t2;
54 SHOW INDEX FROM t1;
55 SHOW INDEX FROM t2;
56 DROP TABLE t1, t2;
57
58 --echo # with virtual column index
59 CREATE TABLE t1 (a int, b int as (a * a)) ENGINE=InnoDB;
60 CREATE UNIQUE INDEX ai ON t1 (b);
61 INSERT INTO t1 VALUES(42, default);
62 FLUSH TABLES t1 FOR EXPORT;
63 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
64 --copy_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/t2.frm
65 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
66 UNLOCK TABLES;
67 ALTER TABLE t2 IMPORT TABLESPACE;
68 SHOW CREATE TABLE t2;
69 SELECT * FROM t2;
70 SELECT b FROM t2 USE INDEX (ai);
71 SHOW INDEX FROM t1;
72 SHOW INDEX FROM t2;
73 CHECK TABLE t2 EXTENDED;
74 DROP TABLE t1, t2;
75
76 --echo # with auto_increment
77 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, i2 INT, i1 INT)ENGINE=INNODB;
78 INSERT INTO t1 (i2) SELECT 4 FROM seq_1_to_1024;
79 FLUSH TABLE t1 FOR EXPORT;
80 --copy_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/t2.frm
81 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
82 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
83 UNLOCK TABLES;
84 ALTER TABLE t2 IMPORT TABLESPACE;
85 CHECK TABLE t2 EXTENDED;
86 DROP TABLE t2, t1;