Debian Codegraph @

mysql-test/suite/mariabackup/aria_backup.result

raw
1 ###
2 # Test for backup to stream
3 #####
4 ###
5 # Test for mix of online/offline backup tables
6 #####
7 CREATE TABLE t_default(i INT PRIMARY KEY)
8 ENGINE ARIA;
9 INSERT INTO t_default VALUES (1);
10 CREATE TABLE t_tr_p_ch(i INT PRIMARY KEY)
11 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
12 INSERT INTO t_tr_p_ch VALUES (1);
13 CREATE TABLE t_tr_p_nch(i INT PRIMARY KEY)
14 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=0;
15 INSERT INTO t_tr_p_nch VALUES (1);
16 CREATE TABLE t_p_ch(i INT PRIMARY KEY)
17 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
18 INSERT INTO t_p_ch VALUES (1);
19 CREATE TABLE t_p_nch(i INT PRIMARY KEY)
20 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=PAGE PAGE_CHECKSUM=0;
21 INSERT INTO t_p_nch VALUES (1);
22 CREATE TABLE t_fixed(i INT PRIMARY KEY)
23 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=FIXED PAGE_CHECKSUM=1;
24 INSERT INTO t_fixed VALUES (1);
25 CREATE TABLE t_dyn(i INT PRIMARY KEY)
26 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=DYNAMIC PAGE_CHECKSUM=1;
27 INSERT INTO t_dyn VALUES (1);
28 # Test for partitioned table
29 CREATE TABLE t_part_online(i INT PRIMARY KEY)
30 ENGINE ARIA TRANSACTIONAL = 1 PAGE_CHECKSUM = 1
31 PARTITION BY RANGE( i ) (
32 PARTITION p0 VALUES LESS THAN (10),
33 PARTITION p1 VALUES LESS THAN (20),
34 PARTITION p2 VALUES LESS THAN (30)
35 );
36 INSERT INTO t_part_online VALUES(5);
37 INSERT INTO t_part_online VALUES(15);
38 INSERT INTO t_part_online VALUES(25);
39 SELECT * FROM t_part_online;
40 i
41 5
42 15
43 25
44 CREATE TABLE t_part_offline(i INT)
45 ENGINE ARIA TRANSACTIONAL = 0 PAGE_CHECKSUM = 0
46 PARTITION BY RANGE( i ) (
47 PARTITION p0 VALUES LESS THAN (10),
48 PARTITION p1 VALUES LESS THAN (20),
49 PARTITION p2 VALUES LESS THAN (30)
50 );
51 INSERT INTO t_part_offline VALUES(5);
52 INSERT INTO t_part_offline VALUES(15);
53 INSERT INTO t_part_offline VALUES(25);
54 # Test for filename to tablename mapping
55 CREATE TABLE `t 1 t-1`(i INT PRIMARY KEY)
56 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
57 INSERT INTO `t 1 t-1` VALUES (1);
58 CREATE TABLE `t-part online`(i INT PRIMARY KEY)
59 ENGINE ARIA TRANSACTIONAL = 1 PAGE_CHECKSUM = 1
60 PARTITION BY RANGE( i ) (
61 PARTITION p0 VALUES LESS THAN (10),
62 PARTITION p1 VALUES LESS THAN (20),
63 PARTITION p2 VALUES LESS THAN (30)
64 );
65 INSERT INTO `t-part online` VALUES(5);
66 INSERT INTO `t-part online` VALUES(15);
67 INSERT INTO `t-part online` VALUES(25);
68 ###
69 # Test for redo log files backup;
70 #####
71 CREATE TABLE t_logs_1(i INT)
72 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
73 CREATE TABLE t_logs_2 LIKE t_logs_1;
74 CREATE TABLE t_bulk_ins LIKE t_logs_1;
75 INSERT INTO t_logs_1 VALUES
76 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
77 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
78 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
79 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
80 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
81 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
82 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
83 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
84 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
85 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9);
86 # Generate several log files
87 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
88 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
89 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
90 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
91 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
92 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
93 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
94 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
95 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
96 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
97 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
98 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
99 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
100 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
101 ###
102 # Test for DML during backup for online backup
103 #####
104 CREATE TABLE t_dml_ins(i INT PRIMARY KEY)
105 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
106 INSERT INTO t_dml_ins VALUES(1);
107 CREATE TABLE t_dml_upd(i INT PRIMARY KEY)
108 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
109 INSERT INTO t_dml_upd VALUES(1);
110 CREATE TABLE t_dml_del(i INT PRIMARY KEY)
111 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
112 INSERT INTO t_dml_del VALUES(1);
113 ###
114 # Test for DDL during backup for online backup
115 #####
116 CREATE DATABASE test_for_db_drop;
117 CREATE TABLE test_for_db_drop.t(i INT PRIMARY KEY) ENGINE ARIA;
118 CREATE TABLE t_db_create(i INT PRIMARY KEY) ENGINE ARIA;
119 SHOW DATABASES;
120 Database
121 information_schema
122 mtr
123 mysql
124 performance_schema
125 sys
126 test
127 test_for_db_drop
128 CREATE TABLE t_alter(i INT PRIMARY KEY) ENGINE ARIA;
129 INSERT INTO t_alter VALUES (1);
130 CREATE TABLE t_trunc(i INT PRIMARY KEY) ENGINE ARIA;
131 INSERT INTO t_trunc VALUES (1);
132 CREATE TABLE t_ch_i (i int(10), index(i) ) ENGINE=Aria;
133 INSERT INTO t_ch_i VALUES(1);
134 CREATE TABLE t_change_engine(i INT PRIMARY KEY) ENGINE InnoDB;
135 INSERT INTO t_change_engine VALUES (1);
136 CREATE TABLE t_rename(i INT PRIMARY KEY) ENGINE ARIA;
137 CREATE DATABASE test_for_rename;
138 CREATE TABLE t_rename_2(i INT PRIMARY KEY) ENGINE ARIA;
139 CREATE TABLE t_rename_3(i INT PRIMARY KEY) ENGINE ARIA;
140 CREATE TABLE t_rename_4(i INT PRIMARY KEY) ENGINE ARIA;
141 CREATE TABLE t_delete(i INT PRIMARY KEY) ENGINE ARIA;
142 CREATE TABLE t_delete_2(i INT PRIMARY KEY) ENGINE ARIA;
143 CREATE TABLE t_rename_alter(i INT PRIMARY KEY) ENGINE ARIA;
144 CREATE TABLE t_rename_create(i INT PRIMARY KEY) ENGINE ARIA;
145 CREATE TABLE t_part_create(i INT PRIMARY KEY) ENGINE ARIA;
146 CREATE TABLE t_part_add_part(i INT PRIMARY KEY) ENGINE ARIA;
147 CREATE TABLE t_part_change_eng(i INT PRIMARY KEY) ENGINE ARIA PARTITION BY HASH(i) PARTITIONS 2;
148 CREATE TABLE t_part_change_eng_2(i INT PRIMARY KEY) ENGINE InnoDB PARTITION BY HASH(i) PARTITIONS 2;
149 CREATE TABLE t_part_change_eng_3(i INT PRIMARY KEY) ENGINE Aria;
150 CREATE TABLE t_part_alter(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
151 CREATE TABLE t_part_alter_2(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 3;
152 CREATE TABLE t_part_drop(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
153 CREATE TABLE t_part_rename(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
154 CREATE TABLE t_part_rename_3(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
155 CREATE TABLE t_part_rm_part(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
156 SET SESSION debug_dbug="+d,maria_flush_whole_log";
157 SET GLOBAL aria_checkpoint_interval=10000;
158 ### Backup to stream
159 # xtrabackup prepare
160 # shutdown server
161 # remove datadir
162 # xtrabackup move back
163 # restart
164 ### Result for DDL test
165 SHOW CREATE TABLE t_alter;
166 Table Create Table
167 t_alter CREATE TABLE `t_alter` (
168 `i` int(11) NOT NULL,
169 `c` int(11) DEFAULT NULL,
170 PRIMARY KEY (`i`)
171 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
172 SELECT * FROM t_alter;
173 i c
174 1 NULL
175 SHOW CREATE TABLE t_change_engine;
176 Table Create Table
177 t_change_engine CREATE TABLE `t_change_engine` (
178 `i` int(11) NOT NULL,
179 PRIMARY KEY (`i`)
180 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
181 SELECT * FROM t_change_engine;
182 i
183 1
184 SELECT * FROM t_trunc;
185 i
186 1
187 SELECT * FROM t_ch_i;
188 i
189 1
190 SELECT * FROM t_rename_new;
191 i
192 SELECT * FROM test_for_rename.t_rename_new_2;
193 i
194 SELECT * FROM t_rename_new_new_3;
195 i
196 SELECT * FROM t_rename_new_4;
197 i
198 SELECT * FROM t_delete;
199 ERROR 42S02: Table 'test.t_delete' doesn't exist
200 SHOW CREATE TABLE t_delete_2;
201 Table Create Table
202 t_delete_2 CREATE TABLE `t_delete_2` (
203 `i` int(11) NOT NULL,
204 PRIMARY KEY (`i`)
205 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
206 SELECT * FROM t_rename_alter_2;
207 i c
208 SELECT * FROM t_rename_create;
209 d
210 SELECT * FROM t_rename_create_new;
211 i
212 SHOW CREATE TABLE t_part_create_2;
213 Table Create Table
214 t_part_create_2 CREATE TABLE `t_part_create_2` (
215 `i` int(11) DEFAULT NULL
216 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
217 PARTITION BY HASH (`i`)
218 PARTITIONS 2
219 SELECT * FROM t_part_create_2;
220 i
221 SHOW CREATE TABLE t_part_add_part;
222 Table Create Table
223 t_part_add_part CREATE TABLE `t_part_add_part` (
224 `i` int(11) NOT NULL,
225 PRIMARY KEY (`i`)
226 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
227 PARTITION BY HASH (`i`)
228 PARTITIONS 2
229 SELECT * FROM t_part_add_part;
230 i
231 SHOW CREATE TABLE t_part_change_eng;
232 Table Create Table
233 t_part_change_eng CREATE TABLE `t_part_change_eng` (
234 `i` int(11) NOT NULL,
235 PRIMARY KEY (`i`)
236 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
237 PARTITION BY HASH (`i`)
238 PARTITIONS 2
239 SELECT * FROM t_part_change_eng;
240 i
241 SHOW CREATE TABLE t_part_change_eng_2;
242 Table Create Table
243 t_part_change_eng_2 CREATE TABLE `t_part_change_eng_2` (
244 `i` int(11) NOT NULL,
245 PRIMARY KEY (`i`)
246 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
247 PARTITION BY HASH (`i`)
248 PARTITIONS 2
249 SELECT * FROM t_part_change_eng_2;
250 i
251 SELECT * FROM t_part_alter;
252 i c
253 SHOW CREATE TABLE t_part_alter_2;
254 Table Create Table
255 t_part_alter_2 CREATE TABLE `t_part_alter_2` (
256 `i` int(11) NOT NULL,
257 PRIMARY KEY (`i`)
258 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
259 PARTITION BY HASH (`i`)
260 PARTITIONS 2
261 SELECT * FROM t_part_alter_2;
262 i
263 SELECT * FROM t_part_drop;
264 ERROR 42S02: Table 'test.t_part_drop' doesn't exist
265 SELECT * FROM t_part_rename;
266 ERROR 42S02: Table 'test.t_part_rename' doesn't exist
267 SELECT * FROM t_part_rename_2;
268 i
269 SELECT * FROM t_part_rename_3;
270 ERROR 42S02: Table 'test.t_part_rename_3' doesn't exist
271 SELECT * FROM test_for_rename.t_part_rename_4;
272 i
273 SHOW CREATE TABLE t_part_rm_part;
274 Table Create Table
275 t_part_rm_part CREATE TABLE `t_part_rm_part` (
276 `i` int(11) NOT NULL,
277 `c` int(11) DEFAULT NULL,
278 PRIMARY KEY (`i`)
279 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
280 SELECT * FROM t_part_rm_part;
281 i c
282 SHOW DATABASES;
283 Database
284 information_schema
285 mtr
286 mysql
287 performance_schema
288 sys
289 test
290 test_for_db_create
291 test_for_rename
292 ### Clean up for DDL test
293 DROP DATABASE test_for_db_create;
294 DROP TABLE t_db_create;
295 DROP TABLE t_change_engine;
296 DROP TABLE t_alter;
297 DROP TABLE t_trunc;
298 DROP TABLE t_ch_i;
299 DROP TABLE t_rename_new;
300 DROP TABLE t_rename_new_new_3;
301 DROP TABLE t_rename_new_4;
302 DROP TABLE t_delete_2;
303 DROP TABLE t_rename_alter_2;
304 DROP TABLE t_rename_create;
305 DROP TABLE t_rename_create_new;
306 DROP TABLE t_part_create;
307 DROP TABLE t_part_create_2;
308 DROP TABLE t_part_add_part;
309 DROP TABLE t_part_change_eng;
310 DROP TABLE t_part_change_eng_2;
311 DROP TABLE t_part_change_eng_3;
312 DROP TABLE t_part_alter;
313 DROP TABLE t_part_alter_2;
314 DROP TABLE t_part_rename_2;
315 DROP TABLE t_part_rm_part;
316 DROP DATABASE test_for_rename;
317 ### Result for DML test
318 SELECT * FROM t_dml_ins;
319 i
320 1
321 2
322 SELECT * FROM t_dml_upd;
323 i
324 2
325 SELECT * FROM t_dml_del;
326 i
327 ### Clean up for DML test
328 DROP TABLE t_dml_ins;
329 DROP TABLE t_dml_upd;
330 DROP TABLE t_dml_del;
331 ### Result for redo log files backup
332 # ok
333 # ok
334 # ok
335 ### Cleanup for redo log files backup
336 DROP TABLE t_logs_1;
337 DROP TABLE t_logs_2;
338 DROP TABLE t_bulk_ins;
339 ### Result for online/offline tables test
340 SELECT * FROM t_default;
341 i
342 1
343 SELECT * FROM t_tr_p_ch;
344 i
345 1
346 SELECT * FROM t_tr_p_nch;
347 i
348 1
349 SELECT * FROM t_p_ch;
350 i
351 1
352 SELECT * FROM t_p_nch;
353 i
354 1
355 SELECT * FROM t_fixed;
356 i
357 1
358 SELECT * FROM t_dyn;
359 i
360 1
361 SELECT * FROM t_part_online;
362 i
363 5
364 15
365 25
366 SELECT * FROM t_part_offline;
367 i
368 5
369 15
370 25
371 SELECT * FROM `t 1 t-1`;
372 i
373 1
374 SELECT * FROM `t-part online`;
375 i
376 5
377 15
378 25
379 ### Cleanup for online/offline tables test
380 DROP TABLE t_default;
381 DROP TABLE t_tr_p_ch;
382 DROP TABLE t_tr_p_nch;
383 DROP TABLE t_p_ch;
384 DROP TABLE t_p_nch;
385 DROP TABLE t_fixed;
386 DROP TABLE t_dyn;
387 DROP TABLE t_part_online;
388 DROP TABLE t_part_offline;
389 DROP TABLE `t 1 t-1`;
390 DROP TABLE `t-part online`;
391 ###
392 # Test for backup to directory
393 #####
394 ###
395 # Test for mix of online/offline backup tables
396 #####
397 CREATE TABLE t_default(i INT PRIMARY KEY)
398 ENGINE ARIA;
399 INSERT INTO t_default VALUES (1);
400 CREATE TABLE t_tr_p_ch(i INT PRIMARY KEY)
401 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
402 INSERT INTO t_tr_p_ch VALUES (1);
403 CREATE TABLE t_tr_p_nch(i INT PRIMARY KEY)
404 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=0;
405 INSERT INTO t_tr_p_nch VALUES (1);
406 CREATE TABLE t_p_ch(i INT PRIMARY KEY)
407 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
408 INSERT INTO t_p_ch VALUES (1);
409 CREATE TABLE t_p_nch(i INT PRIMARY KEY)
410 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=PAGE PAGE_CHECKSUM=0;
411 INSERT INTO t_p_nch VALUES (1);
412 CREATE TABLE t_fixed(i INT PRIMARY KEY)
413 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=FIXED PAGE_CHECKSUM=1;
414 INSERT INTO t_fixed VALUES (1);
415 CREATE TABLE t_dyn(i INT PRIMARY KEY)
416 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=DYNAMIC PAGE_CHECKSUM=1;
417 INSERT INTO t_dyn VALUES (1);
418 # Test for partitioned table
419 CREATE TABLE t_part_online(i INT PRIMARY KEY)
420 ENGINE ARIA TRANSACTIONAL = 1 PAGE_CHECKSUM = 1
421 PARTITION BY RANGE( i ) (
422 PARTITION p0 VALUES LESS THAN (10),
423 PARTITION p1 VALUES LESS THAN (20),
424 PARTITION p2 VALUES LESS THAN (30)
425 );
426 INSERT INTO t_part_online VALUES(5);
427 INSERT INTO t_part_online VALUES(15);
428 INSERT INTO t_part_online VALUES(25);
429 SELECT * FROM t_part_online;
430 i
431 5
432 15
433 25
434 CREATE TABLE t_part_offline(i INT)
435 ENGINE ARIA TRANSACTIONAL = 0 PAGE_CHECKSUM = 0
436 PARTITION BY RANGE( i ) (
437 PARTITION p0 VALUES LESS THAN (10),
438 PARTITION p1 VALUES LESS THAN (20),
439 PARTITION p2 VALUES LESS THAN (30)
440 );
441 INSERT INTO t_part_offline VALUES(5);
442 INSERT INTO t_part_offline VALUES(15);
443 INSERT INTO t_part_offline VALUES(25);
444 # Test for filename to tablename mapping
445 CREATE TABLE `t 1 t-1`(i INT PRIMARY KEY)
446 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
447 INSERT INTO `t 1 t-1` VALUES (1);
448 CREATE TABLE `t-part online`(i INT PRIMARY KEY)
449 ENGINE ARIA TRANSACTIONAL = 1 PAGE_CHECKSUM = 1
450 PARTITION BY RANGE( i ) (
451 PARTITION p0 VALUES LESS THAN (10),
452 PARTITION p1 VALUES LESS THAN (20),
453 PARTITION p2 VALUES LESS THAN (30)
454 );
455 INSERT INTO `t-part online` VALUES(5);
456 INSERT INTO `t-part online` VALUES(15);
457 INSERT INTO `t-part online` VALUES(25);
458 ###
459 # Test for redo log files backup;
460 #####
461 CREATE TABLE t_logs_1(i INT)
462 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
463 CREATE TABLE t_logs_2 LIKE t_logs_1;
464 CREATE TABLE t_bulk_ins LIKE t_logs_1;
465 INSERT INTO t_logs_1 VALUES
466 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
467 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
468 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
469 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
470 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
471 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
472 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
473 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
474 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
475 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9);
476 # Generate several log files
477 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
478 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
479 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
480 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
481 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
482 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
483 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
484 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
485 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
486 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
487 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
488 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
489 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
490 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
491 ###
492 # Test for DML during backup for online backup
493 #####
494 CREATE TABLE t_dml_ins(i INT PRIMARY KEY)
495 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
496 INSERT INTO t_dml_ins VALUES(1);
497 CREATE TABLE t_dml_upd(i INT PRIMARY KEY)
498 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
499 INSERT INTO t_dml_upd VALUES(1);
500 CREATE TABLE t_dml_del(i INT PRIMARY KEY)
501 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
502 INSERT INTO t_dml_del VALUES(1);
503 ###
504 # Test for DDL during backup for online backup
505 #####
506 CREATE DATABASE test_for_db_drop;
507 CREATE TABLE test_for_db_drop.t(i INT PRIMARY KEY) ENGINE ARIA;
508 CREATE TABLE t_db_create(i INT PRIMARY KEY) ENGINE ARIA;
509 SHOW DATABASES;
510 Database
511 information_schema
512 mtr
513 mysql
514 performance_schema
515 sys
516 test
517 test_for_db_drop
518 CREATE TABLE t_alter(i INT PRIMARY KEY) ENGINE ARIA;
519 INSERT INTO t_alter VALUES (1);
520 CREATE TABLE t_trunc(i INT PRIMARY KEY) ENGINE ARIA;
521 INSERT INTO t_trunc VALUES (1);
522 CREATE TABLE t_ch_i (i int(10), index(i) ) ENGINE=Aria;
523 INSERT INTO t_ch_i VALUES(1);
524 CREATE TABLE t_change_engine(i INT PRIMARY KEY) ENGINE InnoDB;
525 INSERT INTO t_change_engine VALUES (1);
526 CREATE TABLE t_rename(i INT PRIMARY KEY) ENGINE ARIA;
527 CREATE DATABASE test_for_rename;
528 CREATE TABLE t_rename_2(i INT PRIMARY KEY) ENGINE ARIA;
529 CREATE TABLE t_rename_3(i INT PRIMARY KEY) ENGINE ARIA;
530 CREATE TABLE t_rename_4(i INT PRIMARY KEY) ENGINE ARIA;
531 CREATE TABLE t_delete(i INT PRIMARY KEY) ENGINE ARIA;
532 CREATE TABLE t_delete_2(i INT PRIMARY KEY) ENGINE ARIA;
533 CREATE TABLE t_rename_alter(i INT PRIMARY KEY) ENGINE ARIA;
534 CREATE TABLE t_rename_create(i INT PRIMARY KEY) ENGINE ARIA;
535 CREATE TABLE t_part_create(i INT PRIMARY KEY) ENGINE ARIA;
536 CREATE TABLE t_part_add_part(i INT PRIMARY KEY) ENGINE ARIA;
537 CREATE TABLE t_part_change_eng(i INT PRIMARY KEY) ENGINE ARIA PARTITION BY HASH(i) PARTITIONS 2;
538 CREATE TABLE t_part_change_eng_2(i INT PRIMARY KEY) ENGINE InnoDB PARTITION BY HASH(i) PARTITIONS 2;
539 CREATE TABLE t_part_change_eng_3(i INT PRIMARY KEY) ENGINE Aria;
540 CREATE TABLE t_part_alter(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
541 CREATE TABLE t_part_alter_2(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 3;
542 CREATE TABLE t_part_drop(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
543 CREATE TABLE t_part_rename(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
544 CREATE TABLE t_part_rename_3(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
545 CREATE TABLE t_part_rm_part(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
546 SET SESSION debug_dbug="+d,maria_flush_whole_log";
547 SET GLOBAL aria_checkpoint_interval=10000;
548 ### Backup to dir
549 # xtrabackup prepare
550 # shutdown server
551 # remove datadir
552 # xtrabackup move back
553 # restart
554 ### Result for DDL test
555 SHOW CREATE TABLE t_alter;
556 Table Create Table
557 t_alter CREATE TABLE `t_alter` (
558 `i` int(11) NOT NULL,
559 `c` int(11) DEFAULT NULL,
560 PRIMARY KEY (`i`)
561 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
562 SELECT * FROM t_alter;
563 i c
564 1 NULL
565 SHOW CREATE TABLE t_change_engine;
566 Table Create Table
567 t_change_engine CREATE TABLE `t_change_engine` (
568 `i` int(11) NOT NULL,
569 PRIMARY KEY (`i`)
570 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
571 SELECT * FROM t_change_engine;
572 i
573 1
574 SELECT * FROM t_trunc;
575 i
576 1
577 SELECT * FROM t_ch_i;
578 i
579 1
580 SELECT * FROM t_rename_new;
581 i
582 SELECT * FROM test_for_rename.t_rename_new_2;
583 i
584 SELECT * FROM t_rename_new_new_3;
585 i
586 SELECT * FROM t_rename_new_4;
587 i
588 SELECT * FROM t_delete;
589 ERROR 42S02: Table 'test.t_delete' doesn't exist
590 SHOW CREATE TABLE t_delete_2;
591 Table Create Table
592 t_delete_2 CREATE TABLE `t_delete_2` (
593 `i` int(11) NOT NULL,
594 PRIMARY KEY (`i`)
595 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
596 SELECT * FROM t_rename_alter_2;
597 i c
598 SELECT * FROM t_rename_create;
599 d
600 SELECT * FROM t_rename_create_new;
601 i
602 SHOW CREATE TABLE t_part_create_2;
603 Table Create Table
604 t_part_create_2 CREATE TABLE `t_part_create_2` (
605 `i` int(11) DEFAULT NULL
606 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
607 PARTITION BY HASH (`i`)
608 PARTITIONS 2
609 SELECT * FROM t_part_create_2;
610 i
611 SHOW CREATE TABLE t_part_add_part;
612 Table Create Table
613 t_part_add_part CREATE TABLE `t_part_add_part` (
614 `i` int(11) NOT NULL,
615 PRIMARY KEY (`i`)
616 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
617 PARTITION BY HASH (`i`)
618 PARTITIONS 2
619 SELECT * FROM t_part_add_part;
620 i
621 SHOW CREATE TABLE t_part_change_eng;
622 Table Create Table
623 t_part_change_eng CREATE TABLE `t_part_change_eng` (
624 `i` int(11) NOT NULL,
625 PRIMARY KEY (`i`)
626 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
627 PARTITION BY HASH (`i`)
628 PARTITIONS 2
629 SELECT * FROM t_part_change_eng;
630 i
631 SHOW CREATE TABLE t_part_change_eng_2;
632 Table Create Table
633 t_part_change_eng_2 CREATE TABLE `t_part_change_eng_2` (
634 `i` int(11) NOT NULL,
635 PRIMARY KEY (`i`)
636 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
637 PARTITION BY HASH (`i`)
638 PARTITIONS 2
639 SELECT * FROM t_part_change_eng_2;
640 i
641 SELECT * FROM t_part_alter;
642 i c
643 SHOW CREATE TABLE t_part_alter_2;
644 Table Create Table
645 t_part_alter_2 CREATE TABLE `t_part_alter_2` (
646 `i` int(11) NOT NULL,
647 PRIMARY KEY (`i`)
648 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
649 PARTITION BY HASH (`i`)
650 PARTITIONS 2
651 SELECT * FROM t_part_alter_2;
652 i
653 SELECT * FROM t_part_drop;
654 ERROR 42S02: Table 'test.t_part_drop' doesn't exist
655 SELECT * FROM t_part_rename;
656 ERROR 42S02: Table 'test.t_part_rename' doesn't exist
657 SELECT * FROM t_part_rename_2;
658 i
659 SELECT * FROM t_part_rename_3;
660 ERROR 42S02: Table 'test.t_part_rename_3' doesn't exist
661 SELECT * FROM test_for_rename.t_part_rename_4;
662 i
663 SHOW CREATE TABLE t_part_rm_part;
664 Table Create Table
665 t_part_rm_part CREATE TABLE `t_part_rm_part` (
666 `i` int(11) NOT NULL,
667 `c` int(11) DEFAULT NULL,
668 PRIMARY KEY (`i`)
669 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
670 SELECT * FROM t_part_rm_part;
671 i c
672 SHOW DATABASES;
673 Database
674 information_schema
675 mtr
676 mysql
677 performance_schema
678 sys
679 test
680 test_for_db_create
681 test_for_rename
682 ### Clean up for DDL test
683 DROP DATABASE test_for_db_create;
684 DROP TABLE t_db_create;
685 DROP TABLE t_change_engine;
686 DROP TABLE t_alter;
687 DROP TABLE t_trunc;
688 DROP TABLE t_ch_i;
689 DROP TABLE t_rename_new;
690 DROP TABLE t_rename_new_new_3;
691 DROP TABLE t_rename_new_4;
692 DROP TABLE t_delete_2;
693 DROP TABLE t_rename_alter_2;
694 DROP TABLE t_rename_create;
695 DROP TABLE t_rename_create_new;
696 DROP TABLE t_part_create;
697 DROP TABLE t_part_create_2;
698 DROP TABLE t_part_add_part;
699 DROP TABLE t_part_change_eng;
700 DROP TABLE t_part_change_eng_2;
701 DROP TABLE t_part_change_eng_3;
702 DROP TABLE t_part_alter;
703 DROP TABLE t_part_alter_2;
704 DROP TABLE t_part_rename_2;
705 DROP TABLE t_part_rm_part;
706 DROP DATABASE test_for_rename;
707 ### Result for DML test
708 SELECT * FROM t_dml_ins;
709 i
710 1
711 2
712 SELECT * FROM t_dml_upd;
713 i
714 2
715 SELECT * FROM t_dml_del;
716 i
717 ### Clean up for DML test
718 DROP TABLE t_dml_ins;
719 DROP TABLE t_dml_upd;
720 DROP TABLE t_dml_del;
721 ### Result for redo log files backup
722 # ok
723 # ok
724 # ok
725 ### Cleanup for redo log files backup
726 DROP TABLE t_logs_1;
727 DROP TABLE t_logs_2;
728 DROP TABLE t_bulk_ins;
729 ### Result for online/offline tables test
730 SELECT * FROM t_default;
731 i
732 1
733 SELECT * FROM t_tr_p_ch;
734 i
735 1
736 SELECT * FROM t_tr_p_nch;
737 i
738 1
739 SELECT * FROM t_p_ch;
740 i
741 1
742 SELECT * FROM t_p_nch;
743 i
744 1
745 SELECT * FROM t_fixed;
746 i
747 1
748 SELECT * FROM t_dyn;
749 i
750 1
751 SELECT * FROM t_part_online;
752 i
753 5
754 15
755 25
756 SELECT * FROM t_part_offline;
757 i
758 5
759 15
760 25
761 SELECT * FROM `t 1 t-1`;
762 i
763 1
764 SELECT * FROM `t-part online`;
765 i
766 5
767 15
768 25
769 ### Cleanup for online/offline tables test
770 DROP TABLE t_default;
771 DROP TABLE t_tr_p_ch;
772 DROP TABLE t_tr_p_nch;
773 DROP TABLE t_p_ch;
774 DROP TABLE t_p_nch;
775 DROP TABLE t_fixed;
776 DROP TABLE t_dyn;
777 DROP TABLE t_part_online;
778 DROP TABLE t_part_offline;
779 DROP TABLE `t 1 t-1`;
780 DROP TABLE `t-part online`;