Debian Codegraph @

mysql-test/suite/mariabackup/ddl_for_common_engine.test

raw
1 # This test is just to ensure the DDL processing works for common engines like
2 # MyISAM, ARCHIVE, CSV etc. The more complex test for different cases is
3 # implemented in aria_backup.test.
4 --source include/have_archive.inc
5 --source include/have_csv.inc
6 --source include/have_debug.inc
7
8 --let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
9
10 --let $e_myisam = 1
11 --let $e_merge = 2
12 --let $e_csv = 3
13 --let $e_archive = 4
14 # 'rename' is not logged in $e_archive, return when fix
15 --let $e_var = $e_csv
16
17 while ($e_var) {
18 if ($e_var == $e_csv) {
19 --let $engine = CSV
20 }
21 if ($e_var == $e_archive) {
22 --let $engine = ARCHIVE
23 }
24 if ($e_var == $e_merge) {
25 --let $engine = MERGE
26 }
27 if ($e_var == $e_myisam) {
28 --let $engine = MyISAM
29 }
30
31 if ($e_var == $e_merge) {
32 CREATE TABLE t1_m1 (a INT NOT NULL) ENGINE=MyISAM;
33 CREATE TABLE t1_m2 (a INT NOT NULL) ENGINE=MyISAM;
34 CREATE TABLE t1 (a INT NOT NULL) ENGINE=MERGE UNION=(t1_m1, t1_m2) INSERT_METHOD=LAST;
35 CREATE TABLE t2_m1 (a INT NOT NULL) ENGINE=MyISAM;
36 CREATE TABLE t2_m2 (a INT NOT NULL) ENGINE=MyISAM;
37 CREATE TABLE t2 (a INT NOT NULL) ENGINE=MERGE UNION=(t2_m1, t2_m2) INSERT_METHOD=LAST;
38 CREATE TABLE t3_m1 (a INT NOT NULL) ENGINE=MyISAM;
39 CREATE TABLE t3_m2 (a INT NOT NULL) ENGINE=MyISAM;
40 CREATE TABLE t3 (a INT NOT NULL) ENGINE=MERGE UNION=(t3_m1, t3_m2) INSERT_METHOD=LAST;
41 }
42 if ($e_var != $e_merge) {
43 eval CREATE TABLE t1 (a INT NOT NULL) ENGINE=$engine;
44 eval CREATE TABLE t2 (a INT NOT NULL) ENGINE=$engine;
45 eval CREATE TABLE t3 (a INT NOT NULL) ENGINE=$engine;
46 }
47
48 --let after_ce_table_copy_test_t1=begin not atomic CREATE TABLE test.t4 LIKE test.t1; DROP TABLE test.t2; RENAME TABLE test.t3 TO test.t5; end
49
50 --mkdir $targetdir
51 --echo ### Backup to dir
52 --disable_result_log
53 --exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$targetdir --dbug=+d,mariabackup_events
54 --enable_result_log
55
56 --echo # xtrabackup prepare
57 --disable_result_log
58 --exec $XTRABACKUP --prepare --target-dir=$targetdir
59 --source include/restart_and_restore.inc
60 --enable_result_log
61 --rmdir $targetdir
62
63 SELECT * FROM t4;
64 --error ER_NO_SUCH_TABLE
65 SELECT * FROM t2;
66 --error ER_NO_SUCH_TABLE
67 SELECT * FROM t3;
68 SELECT * FROM t5;
69 SELECT * FROM t1;
70
71 DROP TABLE t4, t5, t1;
72
73 if ($e_var == $e_merge) {
74 DROP TABLE t1_m1, t1_m2, t2_m1, t2_m2, t3_m1, t3_m2;
75 }
76 --let after_ce_table_copy_test_t1=
77 --dec $e_var
78 }
79