Debian Codegraph @

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

raw
1 Case 1: multithreaded backup + multithreaded restore
2 "Create tables for backup"
3 Warnings:
4 Warning 1681 Integer display width is deprecated and will be removed in a future release.
5 Warning 1681 Integer display width is deprecated and will be removed in a future release.
6 Warning 1681 Integer display width is deprecated and will be removed in a future release.
7 Warning 1681 Integer display width is deprecated and will be removed in a future release.
8 Warning 1681 Integer display width is deprecated and will be removed in a future release.
9 Warning 1681 Integer display width is deprecated and will be removed in a future release.
10 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
11 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
12 Warning 1681 Integer display width is deprecated and will be removed in a future release.
13 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
14 Warning 1681 Integer display width is deprecated and will be removed in a future release.
15 Warning 1681 Integer display width is deprecated and will be removed in a future release.
16 Warning 1681 Integer display width is deprecated and will be removed in a future release.
17 Warning 1681 Integer display width is deprecated and will be removed in a future release.
18
19 Starting backup
20 Backup started
21 "Update tables during backup"
22
23 "Wait for backup to complete"
24 Waiting for backup to complete
25 Backup completed
26 "Drop tables after backup completes"
27 "Restoring metadata"
28 "Restoring backup on node 1"
29 "Restoring backup on node 2"
30 "Print restored rows"
31 use test;
32 select * from t0 order by id;
33 id val
34 1 1
35 2 2
36 3 3
37 4 4
38 5 5
39 6 6
40 7 7
41 8 8
42 9 9
43 10 12345
44 select * from t1 order by val;
45 val
46 NULL
47 2
48 3
49 4
50 5
51 6
52 7
53 8
54 9
55 11
56 select * from t2 order by id;
57 id
58 1
59 3
60 4
61 5
62 6
63 7
64 8
65 9
66 10
67 22
68 select * from t3 order by id;
69 id val
70 1 9
71 2 8
72 3 33
73 4 6
74 5 5
75 6 4
76 7 3
77 8 2
78 9 1
79 10 NULL
80 select * from t4 order by id;
81 id val
82 1 11001
83 2 11001
84 3 11001
85 4 44
86 5 11001
87 6 11001
88 7 11001
89 8 11001
90 9 11001
91 10 11001
92 select id, sha1(val) from t5 order by id;
93 id sha1(val)
94 1 0b35a3e0949353117c55151be416c64481dc9778
95 2 0f5f3d3783159438eff81e6b3c8911480daf7eac
96 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
97 4 ea7dffff542a062f6e41c69afac9576d7e97634c
98 5 266d8973914802f093f698a58224566ca2a664bc
99 6 4a8284d4be6c4c063a910760610c8754ca1234a3
100 7 c1bd312a4dd67884e66d15671d38c854e99c8021
101 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
102 9 139101d8480a9a68e4e1256ed300aad365725fbc
103 10 NULL
104 select * from t6 order by id;
105 id val
106 1 1
107 2 2
108 3 3
109 4 4
110 5 5
111 6 66
112 7 7
113 8 8
114 9 9
115 10 NULL
116 select * from t7 order by id;
117 id val1 val2
118 1 9 9
119 2 8 8
120 3 7 7
121 4 6 6
122 5 5 5
123 6 4 4
124 7 77 3
125 8 2 2
126 9 1 1
127 10 10 NULL
128 select id, sha1(val) from t8 order by id;
129 id sha1(val)
130 1 025bd54db3f70cdac283a9653518c14f3d331602
131 2 360252745cb517637959a9ba6cb7a789cf05fa98
132 3 e315b8015984d48b3d1777787d8b629bd77454cf
133 4 946a83f98e3f05c3d94f0c7f2e7131324245797c
134 5 66f223928b25272f115396aa099fb38efbfe3885
135 6 125d03fac5bb972ef45466e36d25fd219bf09b36
136 7 cf47dcc87c1ca726f74a86a4aac57d453703facc
137 8 61984ed58e8de9ab388e62b54ced499e7336e82e
138 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
139 10 NULL
140 select * from t9 order by auto;
141 auto string vstring tiny short medium long_int longlong real_float real_double real_decimal utiny ushort umedium ulong ulonglong bits options flags date_field year_field time_field date_time
142 1 bbbb bbbb -22 -22 -22 -22 -22 22.2 22.2200 22.2200 22 00022 22 22 22  two two 1922-02-22 1922 22:22:22 1922-02-22 22:22:22
143 2 8888 8888 -8 -8 -8 -8 -8 8.8 8.8000 8.8000 8 00008 8 8 8  one one 1988-08-08 1988 08:08:08 1988-08-08 08:08:08
144 3 7777 7777 -7 -7 -7 -7 -7 7.7 7.7000 7.7000 7 00007 7 7 7  one one 1977-07-07 1977 07:07:07 1977-07-07 07:07:07
145 4 6666 6666 -6 -6 -6 -6 -6 6.6 6.6000 6.6000 6 00006 6 6 6  one one 1966-06-06 1966 06:06:06 1966-06-06 06:06:06
146 5 5555 5555 -5 -5 -5 -5 -5 5.5 5.5000 5.5000 5 00005 5 5 5  one one 1955-05-05 1955 05:05:05 1955-05-05 05:05:05
147 6 4444 4444 -4 -4 -4 -4 -4 4.4 4.4000 4.4000 4 00004 4 4 4  one one 1944-04-04 1944 04:04:04 1944-04-04 04:04:04
148 7 3333 3333 -3 -3 -3 -3 -3 3.3 3.3000 3.3000 3 00003 3 3 3  one one 1933-03-03 1933 03:03:03 1933-03-03 03:03:03
149 8 2222 2222 -2 -2 -2 -2 -2 2.2 2.2000 2.2000 2 00002 2 2 2  one one 1922-02-02 1922 02:02:02 1922-02-02 02:02:02
150 9 1111 1111 -1 -1 -1 -1 -1 1.1 1.1000 1.1000 1 00001 1 1 1  one one 1911-01-01 1911 01:01:01 1911-01-01 01:01:01
151 10 NULL NULL 10 10 10 10 10 10.1 NULL NULL 10 00010 10 10 10 NULL two two NULL NULL NULL NULL
152 "Drop tables after backup completes"
153 Case 2: multithreaded snapshotstart backup + multithreaded restore
154 "Create tables for backup"
155 Warnings:
156 Warning 1681 Integer display width is deprecated and will be removed in a future release.
157 Warning 1681 Integer display width is deprecated and will be removed in a future release.
158 Warning 1681 Integer display width is deprecated and will be removed in a future release.
159 Warning 1681 Integer display width is deprecated and will be removed in a future release.
160 Warning 1681 Integer display width is deprecated and will be removed in a future release.
161 Warning 1681 Integer display width is deprecated and will be removed in a future release.
162 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
163 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
164 Warning 1681 Integer display width is deprecated and will be removed in a future release.
165 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
166 Warning 1681 Integer display width is deprecated and will be removed in a future release.
167 Warning 1681 Integer display width is deprecated and will be removed in a future release.
168 Warning 1681 Integer display width is deprecated and will be removed in a future release.
169 Warning 1681 Integer display width is deprecated and will be removed in a future release.
170
171 Starting SNAPSHOTSTART backup
172 Backup started
173 "Update tables during backup"
174
175 "Wait for backup to complete"
176 Waiting for backup to complete
177 Backup completed
178 "Drop tables after backup completes"
179 "Restoring metadata"
180 "Restoring backup on node 1"
181 "Restoring backup on node 2"
182 "Print restored rows"
183 use test;
184 select * from t0 order by id;
185 id val
186 1 1
187 2 2
188 3 3
189 4 4
190 5 5
191 6 6
192 7 7
193 8 8
194 9 9
195 10 NULL
196 select * from t1 order by val;
197 val
198 NULL
199 1
200 2
201 3
202 4
203 5
204 6
205 7
206 8
207 9
208 select * from t2 order by id;
209 id
210 1
211 2
212 3
213 4
214 5
215 6
216 7
217 8
218 9
219 10
220 select * from t3 order by id;
221 id val
222 1 9
223 2 8
224 3 7
225 4 6
226 5 5
227 6 4
228 7 3
229 8 2
230 9 1
231 10 NULL
232 select * from t4 order by id;
233 id val
234 1 11001
235 2 11001
236 3 11001
237 4 11001
238 5 11001
239 6 11001
240 7 11001
241 8 11001
242 9 11001
243 10 11001
244 select id, sha1(val) from t5 order by id;
245 id sha1(val)
246 1 0b35a3e0949353117c55151be416c64481dc9778
247 2 0f5f3d3783159438eff81e6b3c8911480daf7eac
248 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
249 4 ea7dffff542a062f6e41c69afac9576d7e97634c
250 5 8a96558c6361531c5f387582e5f6cd732332262b
251 6 4a8284d4be6c4c063a910760610c8754ca1234a3
252 7 c1bd312a4dd67884e66d15671d38c854e99c8021
253 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
254 9 139101d8480a9a68e4e1256ed300aad365725fbc
255 10 NULL
256 select * from t6 order by id;
257 id val
258 1 1
259 2 2
260 3 3
261 4 4
262 5 5
263 6 6
264 7 7
265 8 8
266 9 9
267 10 NULL
268 select * from t7 order by id;
269 id val1 val2
270 1 9 9
271 2 8 8
272 3 7 7
273 4 6 6
274 5 5 5
275 6 4 4
276 7 3 3
277 8 2 2
278 9 1 1
279 10 10 NULL
280 select id, sha1(val) from t8 order by id;
281 id sha1(val)
282 1 025bd54db3f70cdac283a9653518c14f3d331602
283 2 360252745cb517637959a9ba6cb7a789cf05fa98
284 3 e315b8015984d48b3d1777787d8b629bd77454cf
285 4 946a83f98e3f05c3d94f0c7f2e7131324245797c
286 5 66f223928b25272f115396aa099fb38efbfe3885
287 6 125d03fac5bb972ef45466e36d25fd219bf09b36
288 7 cf47dcc87c1ca726f74a86a4aac57d453703facc
289 8 f8f5538687ac9a4294a44de553d46dd798524504
290 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
291 10 NULL
292 select * from t9 order by auto;
293 auto string vstring tiny short medium long_int longlong real_float real_double real_decimal utiny ushort umedium ulong ulonglong bits options flags date_field year_field time_field date_time
294 1 9999 9999 -9 -9 -9 -9 -9 9.9 9.9000 9.9000 9 00009 9 9 9  one one 1999-09-09 1999 09:09:09 1999-09-09 09:09:09
295 2 8888 8888 -8 -8 -8 -8 -8 8.8 8.8000 8.8000 8 00008 8 8 8  one one 1988-08-08 1988 08:08:08 1988-08-08 08:08:08
296 3 7777 7777 -7 -7 -7 -7 -7 7.7 7.7000 7.7000 7 00007 7 7 7  one one 1977-07-07 1977 07:07:07 1977-07-07 07:07:07
297 4 6666 6666 -6 -6 -6 -6 -6 6.6 6.6000 6.6000 6 00006 6 6 6  one one 1966-06-06 1966 06:06:06 1966-06-06 06:06:06
298 5 5555 5555 -5 -5 -5 -5 -5 5.5 5.5000 5.5000 5 00005 5 5 5  one one 1955-05-05 1955 05:05:05 1955-05-05 05:05:05
299 6 4444 4444 -4 -4 -4 -4 -4 4.4 4.4000 4.4000 4 00004 4 4 4  one one 1944-04-04 1944 04:04:04 1944-04-04 04:04:04
300 7 3333 3333 -3 -3 -3 -3 -3 3.3 3.3000 3.3000 3 00003 3 3 3  one one 1933-03-03 1933 03:03:03 1933-03-03 03:03:03
301 8 2222 2222 -2 -2 -2 -2 -2 2.2 2.2000 2.2000 2 00002 2 2 2  one one 1922-02-02 1922 02:02:02 1922-02-02 02:02:02
302 9 1111 1111 -1 -1 -1 -1 -1 1.1 1.1000 1.1000 1 00001 1 1 1  one one 1911-01-01 1911 01:01:01 1911-01-01 01:01:01
303 10 NULL NULL 10 10 10 10 10 10.1 NULL NULL 10 00010 10 10 10 NULL two two NULL NULL NULL NULL
304 "Drop tables after backup completes"
305 Case 3: multithreaded backup + single-threaded restore
306 "Create tables for backup"
307 Warnings:
308 Warning 1681 Integer display width is deprecated and will be removed in a future release.
309 Warning 1681 Integer display width is deprecated and will be removed in a future release.
310 Warning 1681 Integer display width is deprecated and will be removed in a future release.
311 Warning 1681 Integer display width is deprecated and will be removed in a future release.
312 Warning 1681 Integer display width is deprecated and will be removed in a future release.
313 Warning 1681 Integer display width is deprecated and will be removed in a future release.
314 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
315 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
316 Warning 1681 Integer display width is deprecated and will be removed in a future release.
317 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
318 Warning 1681 Integer display width is deprecated and will be removed in a future release.
319 Warning 1681 Integer display width is deprecated and will be removed in a future release.
320 Warning 1681 Integer display width is deprecated and will be removed in a future release.
321 Warning 1681 Integer display width is deprecated and will be removed in a future release.
322
323 Starting backup
324 Backup started
325 "Update tables during backup"
326
327 "Wait for backup to complete"
328 Waiting for backup to complete
329 Backup completed
330 "Drop tables after backup completes"
331 "Restoring metadata"
332 "Restoring multithreaded backup parts serially on node 1"
333 "Restoring multithreaded backup parts serially on node 2"
334 "Print restored rows"
335 use test;
336 select * from t0 order by id;
337 id val
338 1 1
339 2 2
340 3 3
341 4 4
342 5 5
343 6 6
344 7 7
345 8 8
346 9 9
347 10 12345
348 select * from t1 order by val;
349 val
350 NULL
351 2
352 3
353 4
354 5
355 6
356 7
357 8
358 9
359 11
360 select * from t2 order by id;
361 id
362 1
363 3
364 4
365 5
366 6
367 7
368 8
369 9
370 10
371 22
372 select * from t3 order by id;
373 id val
374 1 9
375 2 8
376 3 33
377 4 6
378 5 5
379 6 4
380 7 3
381 8 2
382 9 1
383 10 NULL
384 select * from t4 order by id;
385 id val
386 1 11001
387 2 11001
388 3 11001
389 4 44
390 5 11001
391 6 11001
392 7 11001
393 8 11001
394 9 11001
395 10 11001
396 select id, sha1(val) from t5 order by id;
397 id sha1(val)
398 1 0b35a3e0949353117c55151be416c64481dc9778
399 2 0f5f3d3783159438eff81e6b3c8911480daf7eac
400 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
401 4 ea7dffff542a062f6e41c69afac9576d7e97634c
402 5 266d8973914802f093f698a58224566ca2a664bc
403 6 4a8284d4be6c4c063a910760610c8754ca1234a3
404 7 c1bd312a4dd67884e66d15671d38c854e99c8021
405 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
406 9 139101d8480a9a68e4e1256ed300aad365725fbc
407 10 NULL
408 select * from t6 order by id;
409 id val
410 1 1
411 2 2
412 3 3
413 4 4
414 5 5
415 6 66
416 7 7
417 8 8
418 9 9
419 10 NULL
420 select * from t7 order by id;
421 id val1 val2
422 1 9 9
423 2 8 8
424 3 7 7
425 4 6 6
426 5 5 5
427 6 4 4
428 7 77 3
429 8 2 2
430 9 1 1
431 10 10 NULL
432 select id, sha1(val) from t8 order by id;
433 id sha1(val)
434 1 025bd54db3f70cdac283a9653518c14f3d331602
435 2 360252745cb517637959a9ba6cb7a789cf05fa98
436 3 e315b8015984d48b3d1777787d8b629bd77454cf
437 4 946a83f98e3f05c3d94f0c7f2e7131324245797c
438 5 66f223928b25272f115396aa099fb38efbfe3885
439 6 125d03fac5bb972ef45466e36d25fd219bf09b36
440 7 cf47dcc87c1ca726f74a86a4aac57d453703facc
441 8 61984ed58e8de9ab388e62b54ced499e7336e82e
442 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
443 10 NULL
444 select * from t9 order by auto;
445 auto string vstring tiny short medium long_int longlong real_float real_double real_decimal utiny ushort umedium ulong ulonglong bits options flags date_field year_field time_field date_time
446 1 bbbb bbbb -22 -22 -22 -22 -22 22.2 22.2200 22.2200 22 00022 22 22 22  two two 1922-02-22 1922 22:22:22 1922-02-22 22:22:22
447 2 8888 8888 -8 -8 -8 -8 -8 8.8 8.8000 8.8000 8 00008 8 8 8  one one 1988-08-08 1988 08:08:08 1988-08-08 08:08:08
448 3 7777 7777 -7 -7 -7 -7 -7 7.7 7.7000 7.7000 7 00007 7 7 7  one one 1977-07-07 1977 07:07:07 1977-07-07 07:07:07
449 4 6666 6666 -6 -6 -6 -6 -6 6.6 6.6000 6.6000 6 00006 6 6 6  one one 1966-06-06 1966 06:06:06 1966-06-06 06:06:06
450 5 5555 5555 -5 -5 -5 -5 -5 5.5 5.5000 5.5000 5 00005 5 5 5  one one 1955-05-05 1955 05:05:05 1955-05-05 05:05:05
451 6 4444 4444 -4 -4 -4 -4 -4 4.4 4.4000 4.4000 4 00004 4 4 4  one one 1944-04-04 1944 04:04:04 1944-04-04 04:04:04
452 7 3333 3333 -3 -3 -3 -3 -3 3.3 3.3000 3.3000 3 00003 3 3 3  one one 1933-03-03 1933 03:03:03 1933-03-03 03:03:03
453 8 2222 2222 -2 -2 -2 -2 -2 2.2 2.2000 2.2000 2 00002 2 2 2  one one 1922-02-02 1922 02:02:02 1922-02-02 02:02:02
454 9 1111 1111 -1 -1 -1 -1 -1 1.1 1.1000 1.1000 1 00001 1 1 1  one one 1911-01-01 1911 01:01:01 1911-01-01 01:01:01
455 10 NULL NULL 10 10 10 10 10 10.1 NULL NULL 10 00010 10 10 10 NULL two two NULL NULL NULL NULL
456 "Drop tables after backup completes"
457 Case 4: multithreaded snapshotstart backup + single-threaded restore
458 "Create tables for backup"
459 Warnings:
460 Warning 1681 Integer display width is deprecated and will be removed in a future release.
461 Warning 1681 Integer display width is deprecated and will be removed in a future release.
462 Warning 1681 Integer display width is deprecated and will be removed in a future release.
463 Warning 1681 Integer display width is deprecated and will be removed in a future release.
464 Warning 1681 Integer display width is deprecated and will be removed in a future release.
465 Warning 1681 Integer display width is deprecated and will be removed in a future release.
466 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
467 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
468 Warning 1681 Integer display width is deprecated and will be removed in a future release.
469 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
470 Warning 1681 Integer display width is deprecated and will be removed in a future release.
471 Warning 1681 Integer display width is deprecated and will be removed in a future release.
472 Warning 1681 Integer display width is deprecated and will be removed in a future release.
473 Warning 1681 Integer display width is deprecated and will be removed in a future release.
474
475 Starting SNAPSHOTSTART backup
476 Backup started
477 "Update tables during backup"
478
479 "Wait for backup to complete"
480 Waiting for backup to complete
481 Backup completed
482 "Drop tables after backup completes"
483 "Restoring metadata"
484 "Restoring multithreaded backup parts serially on node 1"
485 "Restoring multithreaded backup parts serially on node 2"
486 "Print restored rows"
487 use test;
488 select * from t0 order by id;
489 id val
490 1 1
491 2 2
492 3 3
493 4 4
494 5 5
495 6 6
496 7 7
497 8 8
498 9 9
499 10 NULL
500 select * from t1 order by val;
501 val
502 NULL
503 1
504 2
505 3
506 4
507 5
508 6
509 7
510 8
511 9
512 select * from t2 order by id;
513 id
514 1
515 2
516 3
517 4
518 5
519 6
520 7
521 8
522 9
523 10
524 select * from t3 order by id;
525 id val
526 1 9
527 2 8
528 3 7
529 4 6
530 5 5
531 6 4
532 7 3
533 8 2
534 9 1
535 10 NULL
536 select * from t4 order by id;
537 id val
538 1 11001
539 2 11001
540 3 11001
541 4 11001
542 5 11001
543 6 11001
544 7 11001
545 8 11001
546 9 11001
547 10 11001
548 select id, sha1(val) from t5 order by id;
549 id sha1(val)
550 1 0b35a3e0949353117c55151be416c64481dc9778
551 2 0f5f3d3783159438eff81e6b3c8911480daf7eac
552 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
553 4 ea7dffff542a062f6e41c69afac9576d7e97634c
554 5 8a96558c6361531c5f387582e5f6cd732332262b
555 6 4a8284d4be6c4c063a910760610c8754ca1234a3
556 7 c1bd312a4dd67884e66d15671d38c854e99c8021
557 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
558 9 139101d8480a9a68e4e1256ed300aad365725fbc
559 10 NULL
560 select * from t6 order by id;
561 id val
562 1 1
563 2 2
564 3 3
565 4 4
566 5 5
567 6 6
568 7 7
569 8 8
570 9 9
571 10 NULL
572 select * from t7 order by id;
573 id val1 val2
574 1 9 9
575 2 8 8
576 3 7 7
577 4 6 6
578 5 5 5
579 6 4 4
580 7 3 3
581 8 2 2
582 9 1 1
583 10 10 NULL
584 select id, sha1(val) from t8 order by id;
585 id sha1(val)
586 1 025bd54db3f70cdac283a9653518c14f3d331602
587 2 360252745cb517637959a9ba6cb7a789cf05fa98
588 3 e315b8015984d48b3d1777787d8b629bd77454cf
589 4 946a83f98e3f05c3d94f0c7f2e7131324245797c
590 5 66f223928b25272f115396aa099fb38efbfe3885
591 6 125d03fac5bb972ef45466e36d25fd219bf09b36
592 7 cf47dcc87c1ca726f74a86a4aac57d453703facc
593 8 f8f5538687ac9a4294a44de553d46dd798524504
594 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
595 10 NULL
596 select * from t9 order by auto;
597 auto string vstring tiny short medium long_int longlong real_float real_double real_decimal utiny ushort umedium ulong ulonglong bits options flags date_field year_field time_field date_time
598 1 9999 9999 -9 -9 -9 -9 -9 9.9 9.9000 9.9000 9 00009 9 9 9  one one 1999-09-09 1999 09:09:09 1999-09-09 09:09:09
599 2 8888 8888 -8 -8 -8 -8 -8 8.8 8.8000 8.8000 8 00008 8 8 8  one one 1988-08-08 1988 08:08:08 1988-08-08 08:08:08
600 3 7777 7777 -7 -7 -7 -7 -7 7.7 7.7000 7.7000 7 00007 7 7 7  one one 1977-07-07 1977 07:07:07 1977-07-07 07:07:07
601 4 6666 6666 -6 -6 -6 -6 -6 6.6 6.6000 6.6000 6 00006 6 6 6  one one 1966-06-06 1966 06:06:06 1966-06-06 06:06:06
602 5 5555 5555 -5 -5 -5 -5 -5 5.5 5.5000 5.5000 5 00005 5 5 5  one one 1955-05-05 1955 05:05:05 1955-05-05 05:05:05
603 6 4444 4444 -4 -4 -4 -4 -4 4.4 4.4000 4.4000 4 00004 4 4 4  one one 1944-04-04 1944 04:04:04 1944-04-04 04:04:04
604 7 3333 3333 -3 -3 -3 -3 -3 3.3 3.3000 3.3000 3 00003 3 3 3  one one 1933-03-03 1933 03:03:03 1933-03-03 03:03:03
605 8 2222 2222 -2 -2 -2 -2 -2 2.2 2.2000 2.2000 2 00002 2 2 2  one one 1922-02-02 1922 02:02:02 1922-02-02 02:02:02
606 9 1111 1111 -1 -1 -1 -1 -1 1.1 1.1000 1.1000 1 00001 1 1 1  one one 1911-01-01 1911 01:01:01 1911-01-01 01:01:01
607 10 NULL NULL 10 10 10 10 10 10.1 NULL NULL 10 00010 10 10 10 NULL two two NULL NULL NULL NULL
608 "Drop tables after backup completes"
609 Case 5: restore backup with missing part