Debian Codegraph @

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

raw
1 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
2 SHOW CREATE TABLE t1;
3 Table Create Table
4 t1 CREATE TABLE `t1` (
5 `c1` int DEFAULT NULL,
6 `c2` char(20) DEFAULT NULL
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
8 INSERT INTO t1 VALUES(0, "aaaaa");
9 INSERT INTO t1 VALUES(1, "bbbbb");
10 INSERT INTO t1 VALUES(2, "ccccc");
11 INSERT INTO t1 VALUES(3, "ddddd");
12 INSERT INTO t1 VALUES(4, "eeeee");
13 INSERT INTO t1 VALUES(5, "fffff");
14 INSERT INTO t1 VALUES(6, "ggggg");
15 INSERT INTO t1 VALUES(7, "hhhhh");
16 INSERT INTO t1 VALUES(8, "iiiii");
17 INSERT INTO t1 VALUES(9, "jjjjj");
18 INSERT INTO t1 select * from t1;
19 INSERT INTO t1 select * from t1;
20 INSERT INTO t1 select * from t1;
21 INSERT INTO t1 select * from t1;
22 INSERT INTO t1 select * from t1;
23 INSERT INTO t1 select * from t1;
24 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
25 c1 c2
26 0 aaaaa
27 0 aaaaa
28 0 aaaaa
29 0 aaaaa
30 0 aaaaa
31 0 aaaaa
32 0 aaaaa
33 0 aaaaa
34 0 aaaaa
35 0 aaaaa
36 # restart:
37 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
38 c1 c2
39 0 aaaaa
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 DROP TABLE t1;
50 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
51 INSERT INTO t1 VALUES(0, "aaaaa");
52 INSERT INTO t1 VALUES(1, "bbbbb");
53 INSERT INTO t1 VALUES(2, "ccccc");
54 INSERT INTO t1 VALUES(3, "ddddd");
55 INSERT INTO t1 VALUES(4, "eeeee");
56 INSERT INTO t1 VALUES(5, "fffff");
57 INSERT INTO t1 VALUES(6, "ggggg");
58 INSERT INTO t1 VALUES(7, "hhhhh");
59 INSERT INTO t1 VALUES(8, "iiiii");
60 INSERT INTO t1 VALUES(9, "jjjjj");
61 # Kill the server
62 # restart:
63 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
64 c1 c2
65 0 aaaaa
66 1 bbbbb
67 2 ccccc
68 3 ddddd
69 4 eeeee
70 5 fffff
71 6 ggggg
72 7 hhhhh
73 8 iiiii
74 9 jjjjj
75 DELETE FROM t1;
76 START TRANSACTION;
77 INSERT INTO t1 VALUES(0, "aaaaa");
78 INSERT INTO t1 VALUES(1, "bbbbb");
79 INSERT INTO t1 VALUES(2, "ccccc");
80 INSERT INTO t1 VALUES(3, "ddddd");
81 INSERT INTO t1 VALUES(4, "eeeee");
82 INSERT INTO t1 VALUES(5, "fffff");
83 INSERT INTO t1 VALUES(6, "ggggg");
84 INSERT INTO t1 VALUES(7, "hhhhh");
85 INSERT INTO t1 VALUES(8, "iiiii");
86 INSERT INTO t1 VALUES(9, "jjjjj");
87 # restart:
88 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
89 c1 c2
90 INSERT INTO t1 VALUES(0, "aaaaa");
91 INSERT INTO t1 VALUES(1, "bbbbb");
92 INSERT INTO t1 VALUES(2, "ccccc");
93 INSERT INTO t1 VALUES(3, "ddddd");
94 INSERT INTO t1 VALUES(4, "eeeee");
95 INSERT INTO t1 VALUES(5, "fffff");
96 INSERT INTO t1 VALUES(6, "ggggg");
97 INSERT INTO t1 VALUES(7, "hhhhh");
98 INSERT INTO t1 VALUES(8, "iiiii");
99 INSERT INTO t1 VALUES(9, "jjjjj");
100 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
101 c1 c2
102 0 aaaaa
103 1 bbbbb
104 2 ccccc
105 3 ddddd
106 4 eeeee
107 5 fffff
108 6 ggggg
109 7 hhhhh
110 8 iiiii
111 9 jjjjj
112 DROP TABLE t1;