Debian Codegraph @

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

raw
1 call mtr.add_suppression(".*Encryption can't find master key.*");
2 call mtr.add_suppression(".*Encryption information in datafile.*");
3 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
4 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
5 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
6 ALTER TABLE t1 ENCRYPTION="Y", algorithm=copy;
7 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
8 DROP TABLE t1;
9 # restart: --early-plugin-load=keyring_file=keyring_file.so --loose-keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring --plugin-dir=KEYRING_PLUGIN_PATH
10 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
11 SHOW CREATE TABLE t1;
12 Table Create Table
13 t1 CREATE TABLE `t1` (
14 `c1` int DEFAULT NULL,
15 `c2` char(20) DEFAULT NULL
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'
17 INSERT INTO t1 VALUES(0, "aaaaa");
18 INSERT INTO t1 VALUES(1, "bbbbb");
19 INSERT INTO t1 VALUES(2, "ccccc");
20 INSERT INTO t1 VALUES(3, "ddddd");
21 INSERT INTO t1 VALUES(4, "eeeee");
22 INSERT INTO t1 VALUES(5, "fffff");
23 INSERT INTO t1 VALUES(6, "ggggg");
24 INSERT INTO t1 VALUES(7, "hhhhh");
25 INSERT INTO t1 VALUES(8, "iiiii");
26 INSERT INTO t1 VALUES(9, "jjjjj");
27 INSERT INTO t1 select * from t1;
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 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
34 c1 c2
35 0 aaaaa
36 0 aaaaa
37 0 aaaaa
38 0 aaaaa
39 0 aaaaa
40 0 aaaaa
41 0 aaaaa
42 0 aaaaa
43 0 aaaaa
44 0 aaaaa
45 # restart:
46 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
47 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
48 # restart: --early-plugin-load=keyring_file=keyring_file.so --loose-keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring --plugin-dir=KEYRING_PLUGIN_PATH
49 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
50 c1 c2
51 0 aaaaa
52 0 aaaaa
53 0 aaaaa
54 0 aaaaa
55 0 aaaaa
56 0 aaaaa
57 0 aaaaa
58 0 aaaaa
59 0 aaaaa
60 0 aaaaa
61 DROP TABLE t1;
62 # restart: