Debian Codegraph @

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

raw
1 SET GLOBAL innodb_encrypt_tables = OFF;
2 SET GLOBAL innodb_encryption_threads = 4;
3 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB;
4 SHOW CREATE TABLE t1;
5 Table Create Table
6 t1 CREATE TABLE `t1` (
7 `pk` int(11) NOT NULL AUTO_INCREMENT,
8 `c` varchar(256) DEFAULT NULL,
9 PRIMARY KEY (`pk`)
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
11 CREATE TABLE t2 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=YES;
12 CREATE TABLE t3 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=NO;
13 CREATE TABLE t4 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=4;
14 SET GLOBAL innodb_encrypt_tables = on;
15 # Wait max 10 min for key encryption threads to encrypt required all spaces
16 # Success!
17 SELECT COUNT(1) FROM t1;
18 COUNT(1)
19 10
20 SELECT COUNT(1) FROM t2;
21 COUNT(1)
22 10
23 SELECT COUNT(1) FROM t3;
24 COUNT(1)
25 10
26 SELECT COUNT(1) FROM t4;
27 COUNT(1)
28 10
29 SET GLOBAL innodb_encrypt_tables = off;
30 # Wait max 10 min for key encryption threads to decrypt all required spaces
31 # Success!
32 SET GLOBAL innodb_encrypt_tables = ON;
33 set GLOBAL innodb_default_encryption_key_id=4;
34 CREATE TABLE t5 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB;
35 SHOW CREATE TABLE t5;
36 Table Create Table
37 t5 CREATE TABLE `t5` (
38 `pk` int(11) NOT NULL AUTO_INCREMENT,
39 `c` varchar(256) DEFAULT NULL,
40 PRIMARY KEY (`pk`)
41 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
42 INSERT INTO t5 select * from t1;
43 # Wait max 10 min for key encryption threads to encrypt required all spaces
44 # Success!
45 SELECT COUNT(1) FROM t1;
46 COUNT(1)
47 10
48 SELECT COUNT(1) FROM t2;
49 COUNT(1)
50 10
51 SELECT COUNT(1) FROM t3;
52 COUNT(1)
53 10
54 SELECT COUNT(1) FROM t4;
55 COUNT(1)
56 10
57 SELECT COUNT(1) FROM t5;
58 COUNT(1)
59 10
60 drop table t1,t2,t3,t4, t5;