Debian Codegraph @

mysql-test/suite/encryption/t/instant_alter_import.test

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 --source include/have_file_key_management_plugin.inc
4
5 SET GLOBAL innodb_encrypt_tables = ON;
6 SET GLOBAL innodb_encryption_threads = 4;
7
8
9 --let $MYSQLD_DATADIR= `SELECT @@datadir`
10
11 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, i2 INT, i1 INT)
12 ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=4;
13
14 INSERT INTO t1 (i2) SELECT 4 FROM seq_1_to_1024;
15 ALTER TABLE t1 DROP COLUMN i2, ALGORITHM=INSTANT;
16
17 CREATE TABLE t2 LIKE t1;
18 ALTER TABLE t2 DISCARD TABLESPACE;
19
20 FLUSH TABLE t1 FOR EXPORT;
21
22 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
23 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
24
25 UNLOCK TABLES;
26 ALTER TABLE t2 IMPORT TABLESPACE;
27
28 DROP TABLE t2, t1;
29
30
31 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, i2 INT, i1 INT)
32 ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=4 PAGE_COMPRESSED=1;
33
34 INSERT INTO t1 (i2) SELECT 4 FROM seq_1_to_1024;
35 ALTER TABLE t1 DROP COLUMN i2, ALGORITHM=INSTANT;
36
37 CREATE TABLE t2 LIKE t1;
38 ALTER TABLE t2 DISCARD TABLESPACE;
39
40 FLUSH TABLE t1 FOR EXPORT;
41
42 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
43 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
44
45 UNLOCK TABLES;
46 ALTER TABLE t2 IMPORT TABLESPACE;
47
48 DROP TABLE t2, t1;
49
50
51 SET GLOBAL innodb_encrypt_tables = OFF;
52 SET GLOBAL innodb_encryption_threads = 0;