Debian Codegraph @

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

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating local configuration file for keyring component: component_keyring_file
4 # Creating manifest file for current MySQL server instance
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 # Taking backup of local manifest file for MySQL server instance
8 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
9 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
10 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
11 ALTER TABLE t1 ENCRYPTION="Y", algorithm=copy;
12 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
13 DROP TABLE t1;
14 # Restore local manifest file for MySQL server instance from backup
15 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` int DEFAULT NULL,
20 `c2` char(20) DEFAULT NULL
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'
22 INSERT INTO t1 VALUES(0, "aaaaa");
23 INSERT INTO t1 VALUES(1, "bbbbb");
24 INSERT INTO t1 VALUES(2, "ccccc");
25 INSERT INTO t1 VALUES(3, "ddddd");
26 INSERT INTO t1 VALUES(4, "eeeee");
27 INSERT INTO t1 VALUES(5, "fffff");
28 INSERT INTO t1 VALUES(6, "ggggg");
29 INSERT INTO t1 VALUES(7, "hhhhh");
30 INSERT INTO t1 VALUES(8, "iiiii");
31 INSERT INTO t1 VALUES(9, "jjjjj");
32 INSERT INTO t1 select * from t1;
33 INSERT INTO t1 select * from t1;
34 INSERT INTO t1 select * from t1;
35 INSERT INTO t1 select * from t1;
36 INSERT INTO t1 select * from t1;
37 INSERT INTO t1 select * from t1;
38 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
39 c1 c2
40 0 aaaaa
41 0 aaaaa
42 0 aaaaa
43 0 aaaaa
44 0 aaaaa
45 0 aaaaa
46 0 aaaaa
47 0 aaaaa
48 0 aaaaa
49 0 aaaaa
50 # Taking backup of local manifest file for MySQL server instance
51 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
52 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
53 # Restore local manifest file for MySQL server instance from backup
54 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
55 c1 c2
56 0 aaaaa
57 0 aaaaa
58 0 aaaaa
59 0 aaaaa
60 0 aaaaa
61 0 aaaaa
62 0 aaaaa
63 0 aaaaa
64 0 aaaaa
65 0 aaaaa
66 DROP TABLE t1;
67 # ----------------------------------------------------------------------
68 # Teardown
69 # Removing manifest file for current MySQL server instance
70 # Removing local keyring file for keyring component: component_keyring_file
71 # Removing local configuration file for keyring component: component_keyring_file
72 # Restarting server without the manifest file
73 # ----------------------------------------------------------------------