Debian Codegraph @

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

raw
1 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Can't generate new master key for tablespace encryption, please check the keyring plugin is loaded.");
2 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Encryption can't find master key, please check the keyring plugin is loaded.");
3 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Function 'keyring_file' already exists");
4 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Couldn't load plugin named 'keyring_file' with soname 'keyring_file.*'.");
5 call mtr.add_suppression("Plugin keyring_file reported");
6 DROP TABLE IF EXISTS t1;
7 SET GLOBAL innodb_file_per_table = 1;
8 SELECT @@innodb_file_per_table;
9 @@innodb_file_per_table
10 1
11 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
12 SHOW CREATE TABLE t1;
13 Table Create Table
14 t1 CREATE TABLE `t1` (
15 `c1` int DEFAULT NULL,
16 `c2` char(20) DEFAULT NULL
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'
18 INSERT INTO t1 VALUES(0, "aaaaa");
19 INSERT INTO t1 VALUES(1, "bbbbb");
20 INSERT INTO t1 VALUES(2, "ccccc");
21 INSERT INTO t1 VALUES(3, "ddddd");
22 INSERT INTO t1 VALUES(4, "eeeee");
23 INSERT INTO t1 VALUES(5, "fffff");
24 INSERT INTO t1 VALUES(6, "ggggg");
25 INSERT INTO t1 VALUES(7, "hhhhh");
26 INSERT INTO t1 VALUES(8, "iiiii");
27 INSERT INTO t1 VALUES(9, "jjjjj");
28 INSERT INTO t1 select * from t1;
29 INSERT INTO t1 select * from t1;
30 INSERT INTO t1 select * from t1;
31 INSERT INTO t1 select * from t1;
32 INSERT INTO t1 select * from t1;
33 INSERT INTO t1 select * from t1;
34 SELECT * FROM t1 LIMIT 10;
35 c1 c2
36 0 aaaaa
37 1 bbbbb
38 2 ccccc
39 3 ddddd
40 4 eeeee
41 5 fffff
42 6 ggggg
43 7 hhhhh
44 8 iiiii
45 9 jjjjj
46 # restart:
47 SELECT * FROM t1 LIMIT 10;
48 c1 c2
49 0 aaaaa
50 1 bbbbb
51 2 ccccc
52 3 ddddd
53 4 eeeee
54 5 fffff
55 6 ggggg
56 7 hhhhh
57 8 iiiii
58 9 jjjjj
59 ALTER INSTANCE ROTATE INNODB MASTER KEY;
60 DROP TABLE t1;
61 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
62 INSERT INTO t1 VALUES(0, "aaaaa");
63 INSERT INTO t1 VALUES(1, "bbbbb");
64 INSERT INTO t1 VALUES(2, "ccccc");
65 INSERT INTO t1 VALUES(3, "ddddd");
66 INSERT INTO t1 VALUES(4, "eeeee");
67 INSERT INTO t1 VALUES(5, "fffff");
68 INSERT INTO t1 VALUES(6, "ggggg");
69 INSERT INTO t1 VALUES(7, "hhhhh");
70 INSERT INTO t1 VALUES(8, "iiiii");
71 INSERT INTO t1 VALUES(9, "jjjjj");
72 # Kill and restart:
73 SELECT * FROM t1 LIMIT 10;
74 c1 c2
75 0 aaaaa
76 1 bbbbb
77 2 ccccc
78 3 ddddd
79 4 eeeee
80 5 fffff
81 6 ggggg
82 7 hhhhh
83 8 iiiii
84 9 jjjjj
85 DROP TABLE t1;
86 # restart: --early-plugin-load=keyring_file=keyring_file.so --loose-keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring2 --general-log --log-output=FILE --general_log_file=MYSQL_TMP_DIR/keyring_query_log --plugin-dir=KEYRING_PLUGIN_PATH
87 SET block_encryption_mode = 'aes-256-cbc';
88 DROP DATABASE IF EXISTS tde_db;
89 CREATE DATABASE tde_db;
90 CREATE TABLE tde_db.t1(c1 INT PRIMARY KEY, c2 char(50)) ENCRYPTION = 'Y' ENGINE = InnoDB;
91 INSERT INTO tde_db.t1 VALUES(0, 'abc');
92 INSERT INTO tde_db.t1 VALUES(1, 'xyz');
93 INSERT INTO tde_db.t1 VALUES(2, null);
94 INSERT INTO tde_db.t1 VALUES(3, null);
95 SELECT * FROM tde_db.t1 LIMIT 10;
96 c1 c2
97 0 abc
98 1 xyz
99 2 NULL
100 3 NULL
101 ALTER INSTANCE ROTATE INNODB MASTER KEY;
102 SELECT * FROM tde_db.t1 LIMIT 10;
103 c1 c2
104 0 abc
105 1 xyz
106 2 NULL
107 3 NULL
108 # Mysqldump output
109
110 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `tde_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
111
112 USE `tde_db`;
113 /*!40101 SET @saved_cs_client = @@character_set_client */;
114 /*!50503 SET character_set_client = utf8mb4 */;
115 CREATE TABLE `t1` (
116 `c1` int NOT NULL,
117 `c2` char(50) DEFAULT NULL,
118 PRIMARY KEY (`c1`)
119 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y';
120 /*!40101 SET character_set_client = @saved_cs_client */;
121 INSERT INTO `t1` VALUES (0,'abc'),(1,'xyz'),(2,NULL),(3,NULL);
122 # Redirecting mysqlpump output to MYSQL_TMP_DIR/mysqlpump_encrypt.sql
123 DROP DATABASE tde_db;
124 Pattern "ALTER INSTANCE ROTATE INNODB MASTER KEY" found
125 # Loading tables from mysqlpump_encrypt.sql
126 SELECT * FROM tde_db.t1 LIMIT 10;
127 c1 c2
128 0 abc
129 1 xyz
130 2 NULL
131 3 NULL
132 INSERT INTO tde_db.t1 VALUES(4, null);
133 SELECT * FROM tde_db.t1 LIMIT 10;
134 c1 c2
135 0 abc
136 1 xyz
137 2 NULL
138 3 NULL
139 4 NULL
140 DROP DATABASE tde_db;
141 #
142 # Bug #26634507 CREATE_OPTIONS FLD IN INFORMATION_SCHEMA.TABLES NOT
143 # FILLING PROPERLY.
144 # The CREATE_OPTIONS field from I_S.TABLES should show the option
145 # 'ENCRYPTION='.
146 #
147 CREATE TABLE not_encrypted1 (col1 INT) ENCRYPTION='n';
148 CREATE TABLE not_encrypted2 (col1 INT) ENCRYPTION='N';
149 CREATE TABLE encrypted1 (col1 INT) ENCRYPTION='y';
150 CREATE TABLE encrypted2 (col1 INT) ENCRYPTION='Y';
151 SELECT TABLE_SCHEMA, TABLE_NAME, CREATE_OPTIONS
152 FROM INFORMATION_SCHEMA.TABLES
153 WHERE TABLE_NAME like '%encrypted%'
154 ORDER BY TABLE_NAME;
155 TABLE_SCHEMA TABLE_NAME CREATE_OPTIONS
156 test encrypted1 ENCRYPTION='y'
157 test encrypted2 ENCRYPTION='Y'
158 test not_encrypted1
159 test not_encrypted2
160 DROP TABLE encrypted1;
161 DROP TABLE not_encrypted1;
162 DROP TABLE encrypted2;
163 DROP TABLE not_encrypted2;
164 # restart:
165 SET GLOBAL innodb_file_per_table=1;