Debian Codegraph @

mysql-test/suite/encryption/r/instant_alter_import.result

raw
1 SET GLOBAL innodb_encrypt_tables = ON;
2 SET GLOBAL innodb_encryption_threads = 4;
3 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, i2 INT, i1 INT)
4 ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=4;
5 INSERT INTO t1 (i2) SELECT 4 FROM seq_1_to_1024;
6 ALTER TABLE t1 DROP COLUMN i2, ALGORITHM=INSTANT;
7 CREATE TABLE t2 LIKE t1;
8 ALTER TABLE t2 DISCARD TABLESPACE;
9 FLUSH TABLE t1 FOR EXPORT;
10 UNLOCK TABLES;
11 ALTER TABLE t2 IMPORT TABLESPACE;
12 DROP TABLE t2, t1;
13 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, i2 INT, i1 INT)
14 ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=4 PAGE_COMPRESSED=1;
15 INSERT INTO t1 (i2) SELECT 4 FROM seq_1_to_1024;
16 ALTER TABLE t1 DROP COLUMN i2, ALGORITHM=INSTANT;
17 CREATE TABLE t2 LIKE t1;
18 ALTER TABLE t2 DISCARD TABLESPACE;
19 FLUSH TABLE t1 FOR EXPORT;
20 UNLOCK TABLES;
21 ALTER TABLE t2 IMPORT TABLESPACE;
22 DROP TABLE t2, t1;
23 SET GLOBAL innodb_encrypt_tables = OFF;
24 SET GLOBAL innodb_encryption_threads = 0;