Debian Codegraph @

mysql-test/suite/component_keyring_file/r/log_encrypt_1.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 # Kill the server
8 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
9 SHOW CREATE TABLE t1;
10 Table Create Table
11 t1 CREATE TABLE `t1` (
12 `c1` int DEFAULT NULL,
13 `c2` char(20) DEFAULT NULL
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 INSERT INTO t1 VALUES(0, "aaaaa");
16 INSERT INTO t1 VALUES(1, "bbbbb");
17 INSERT INTO t1 VALUES(2, "ccccc");
18 INSERT INTO t1 VALUES(3, "ddddd");
19 INSERT INTO t1 VALUES(4, "eeeee");
20 INSERT INTO t1 VALUES(5, "fffff");
21 INSERT INTO t1 VALUES(6, "ggggg");
22 INSERT INTO t1 VALUES(7, "hhhhh");
23 INSERT INTO t1 VALUES(8, "iiiii");
24 INSERT INTO t1 VALUES(9, "jjjjj");
25 INSERT INTO t1 select * from t1;
26 INSERT INTO t1 select * from t1;
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 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
32 c1 c2
33 0 aaaaa
34 0 aaaaa
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 # Kill the server
44 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
45 c1 c2
46 0 aaaaa
47 0 aaaaa
48 0 aaaaa
49 0 aaaaa
50 0 aaaaa
51 0 aaaaa
52 0 aaaaa
53 0 aaaaa
54 0 aaaaa
55 0 aaaaa
56 DROP TABLE t1;
57 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
58 INSERT INTO t1 VALUES(0, "aaaaa");
59 INSERT INTO t1 VALUES(1, "bbbbb");
60 INSERT INTO t1 VALUES(2, "ccccc");
61 INSERT INTO t1 VALUES(3, "ddddd");
62 INSERT INTO t1 VALUES(4, "eeeee");
63 INSERT INTO t1 VALUES(5, "fffff");
64 INSERT INTO t1 VALUES(6, "ggggg");
65 INSERT INTO t1 VALUES(7, "hhhhh");
66 INSERT INTO t1 VALUES(8, "iiiii");
67 INSERT INTO t1 VALUES(9, "jjjjj");
68 # Kill the server
69 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
70 c1 c2
71 0 aaaaa
72 1 bbbbb
73 2 ccccc
74 3 ddddd
75 4 eeeee
76 5 fffff
77 6 ggggg
78 7 hhhhh
79 8 iiiii
80 9 jjjjj
81 DELETE FROM t1;
82 START TRANSACTION;
83 INSERT INTO t1 VALUES(0, "aaaaa");
84 INSERT INTO t1 VALUES(1, "bbbbb");
85 INSERT INTO t1 VALUES(2, "ccccc");
86 INSERT INTO t1 VALUES(3, "ddddd");
87 INSERT INTO t1 VALUES(4, "eeeee");
88 INSERT INTO t1 VALUES(5, "fffff");
89 INSERT INTO t1 VALUES(6, "ggggg");
90 INSERT INTO t1 VALUES(7, "hhhhh");
91 INSERT INTO t1 VALUES(8, "iiiii");
92 INSERT INTO t1 VALUES(9, "jjjjj");
93 # Kill the server
94 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
95 c1 c2
96 INSERT INTO t1 VALUES(0, "aaaaa");
97 INSERT INTO t1 VALUES(1, "bbbbb");
98 INSERT INTO t1 VALUES(2, "ccccc");
99 INSERT INTO t1 VALUES(3, "ddddd");
100 INSERT INTO t1 VALUES(4, "eeeee");
101 INSERT INTO t1 VALUES(5, "fffff");
102 INSERT INTO t1 VALUES(6, "ggggg");
103 INSERT INTO t1 VALUES(7, "hhhhh");
104 INSERT INTO t1 VALUES(8, "iiiii");
105 INSERT INTO t1 VALUES(9, "jjjjj");
106 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
107 c1 c2
108 0 aaaaa
109 1 bbbbb
110 2 ccccc
111 3 ddddd
112 4 eeeee
113 5 fffff
114 6 ggggg
115 7 hhhhh
116 8 iiiii
117 9 jjjjj
118 DROP TABLE t1;
119 # ----------------------------------------------------------------------
120 # Teardown
121 # Removing manifest file for current MySQL server instance
122 # Removing local keyring file for keyring component: component_keyring_file
123 # Removing local configuration file for keyring component: component_keyring_file
124 # Restarting server without the manifest file
125 # ----------------------------------------------------------------------