Debian Codegraph @

mysql-test/suite/ndb/r/ndb_restore_encrypted_backups.result

raw
1 select * from t0 order by id;
2 id val
3 3 3
4 4 4
5 5 5
6 6 6
7 8 8
8 9 9
9 10 12345
10 select * from t1 order by val;
11 val
12 2
13 4
14 5
15 8
16 9
17 11
18 select * from t2 order by id;
19 id
20 3
21 4
22 5
23 6
24 8
25 9
26 10
27 select * from t3 order by id;
28 id val
29 3 33
30 4 6
31 5 5
32 6 4
33 8 2
34 9 1
35 10 NULL
36 select * from t4 order by id;
37 id val
38 3 11001
39 4 44
40 5 11001
41 6 11001
42 8 11001
43 9 11001
44 10 11001
45 select id, sha1(val) from t5 order by id;
46 id sha1(val)
47 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
48 4 ea7dffff542a062f6e41c69afac9576d7e97634c
49 5 266d8973914802f093f698a58224566ca2a664bc
50 6 4a8284d4be6c4c063a910760610c8754ca1234a3
51 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
52 9 139101d8480a9a68e4e1256ed300aad365725fbc
53 10 NULL
54 select * from t6 order by id;
55 id val
56 3 3
57 4 4
58 5 5
59 6 66
60 8 8
61 9 9
62 10 NULL
63 select * from t7 order by id;
64 id val1 val2
65 4 6 6
66 5 5 5
67 8 2 2
68 9 1 1
69 select id, sha1(val) from t8 order by id;
70 id sha1(val)
71 3 e315b8015984d48b3d1777787d8b629bd77454cf
72 4 946a83f98e3f05c3d94f0c7f2e7131324245797c
73 5 66f223928b25272f115396aa099fb38efbfe3885
74 6 125d03fac5bb972ef45466e36d25fd219bf09b36
75 8 61984ed58e8de9ab388e62b54ced499e7336e82e
76 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
77 10 NULL
78 select count(*) from t9;
79 count(*)
80 7
81 show create table t4;
82 Table Create Table
83 t4 CREATE TABLE `t4` (
84 `id` int NOT NULL,
85 `val` int DEFAULT '11001',
86 PRIMARY KEY (`id`)
87 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
88 insert into t4 (id) values (-1);
89 select * from t4 where id = -1;
90 id val
91 -1 11001
92 drop tables t0,t1,t2,t3,t4,t5,t6,t7,t8,t9;
93 flush tables;
94 select * from t0 order by id;
95 id val
96 3 3
97 4 4
98 5 5
99 6 6
100 8 8
101 9 9
102 10 NULL
103 select * from t1 order by val;
104 val
105 1
106 2
107 4
108 5
109 8
110 9
111 select * from t2 order by id;
112 id
113 3
114 4
115 5
116 6
117 8
118 9
119 10
120 select * from t3 order by id;
121 id val
122 3 7
123 4 6
124 5 5
125 6 4
126 8 2
127 9 1
128 10 NULL
129 select * from t4 order by id;
130 id val
131 3 11001
132 4 11001
133 5 11001
134 6 11001
135 8 11001
136 9 11001
137 10 11001
138 select id, sha1(val) from t5 order by id;
139 id sha1(val)
140 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
141 4 ea7dffff542a062f6e41c69afac9576d7e97634c
142 5 8a96558c6361531c5f387582e5f6cd732332262b
143 6 4a8284d4be6c4c063a910760610c8754ca1234a3
144 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
145 9 139101d8480a9a68e4e1256ed300aad365725fbc
146 10 NULL
147 select * from t6 order by id;
148 id val
149 3 3
150 4 4
151 5 5
152 6 6
153 8 8
154 9 9
155 10 NULL
156 select * from t7 order by id;
157 id val1 val2
158 4 6 6
159 5 5 5
160 8 2 2
161 9 1 1
162 select id, sha1(val) from t8 order by id;
163 id sha1(val)
164 3 e315b8015984d48b3d1777787d8b629bd77454cf
165 4 946a83f98e3f05c3d94f0c7f2e7131324245797c
166 5 66f223928b25272f115396aa099fb38efbfe3885
167 6 125d03fac5bb972ef45466e36d25fd219bf09b36
168 8 f8f5538687ac9a4294a44de553d46dd798524504
169 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
170 10 NULL
171 select count(*) from t9;
172 count(*)
173 7
174 drop tables t0,t1,t2,t3,t4,t5,t6,t7,t8,t9;
175 flush tables;
176 select * from t0 order by id;
177 id val
178 7 7
179 8 8
180 9 9
181 select * from t1 order by val;
182 val
183 2
184 6
185 9
186 select * from t2 order by id;
187 id
188 7
189 8
190 9
191 22
192 select * from t3 order by id;
193 id val
194 7 3
195 8 2
196 9 1
197 select * from t4 order by id;
198 id val
199 7 11001
200 8 11001
201 9 11001
202 select id, sha1(val) from t5 order by id;
203 id sha1(val)
204 7 c1bd312a4dd67884e66d15671d38c854e99c8021
205 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
206 9 139101d8480a9a68e4e1256ed300aad365725fbc
207 select * from t6 order by id;
208 id val
209 7 7
210 8 8
211 9 9
212 select * from t7 order by id;
213 id val1 val2
214 3 7 7
215 4 6 6
216 6 4 4
217 7 77 3
218 9 1 1
219 10 10 NULL
220 select id, sha1(val) from t8 order by id;
221 id sha1(val)
222 7 cf47dcc87c1ca726f74a86a4aac57d453703facc
223 8 61984ed58e8de9ab388e62b54ced499e7336e82e
224 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
225 select count(*) from t9;
226 count(*)
227 3
228 show create table t4;
229 Table Create Table
230 t4 CREATE TABLE `t4` (
231 `id` int NOT NULL,
232 `val` int DEFAULT '11001',
233 PRIMARY KEY (`id`)
234 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
235 insert into t4 (id) values (-1);
236 select * from t4 where id = -1;
237 id val
238 -1 11001
239 drop tables t0,t1,t2,t3,t4,t5,t6,t7,t8,t9;
240 flush tables;
241 select * from t0 order by id;
242 id val
243 7 7
244 8 8
245 9 9
246 select * from t1 order by val;
247 val
248 2
249 6
250 9
251 select * from t2 order by id;
252 id
253 7
254 8
255 9
256 select * from t3 order by id;
257 id val
258 7 3
259 8 2
260 9 1
261 select * from t4 order by id;
262 id val
263 7 11001
264 8 11001
265 9 11001
266 select id, sha1(val) from t5 order by id;
267 id sha1(val)
268 7 c1bd312a4dd67884e66d15671d38c854e99c8021
269 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
270 9 139101d8480a9a68e4e1256ed300aad365725fbc
271 select * from t6 order by id;
272 id val
273 7 7
274 8 8
275 9 9
276 select * from t7 order by id;
277 id val1 val2
278 3 7 7
279 4 6 6
280 6 4 4
281 7 3 3
282 9 1 1
283 10 10 NULL
284 select id, sha1(val) from t8 order by id;
285 id sha1(val)
286 7 cf47dcc87c1ca726f74a86a4aac57d453703facc
287 8 f8f5538687ac9a4294a44de553d46dd798524504
288 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
289 select count(*) from t9;
290 count(*)
291 3
292 drop tables t0,t1,t2,t3,t4,t5,t6,t7,t8,t9;
293 flush tables;