Debian Codegraph @

mysql-test/suite/mariabackup/ddl_for_common_engine.result

raw
1 CREATE TABLE t1 (a INT NOT NULL) ENGINE=CSV;
2 CREATE TABLE t2 (a INT NOT NULL) ENGINE=CSV;
3 CREATE TABLE t3 (a INT NOT NULL) ENGINE=CSV;
4 ### Backup to dir
5 # xtrabackup prepare
6 # shutdown server
7 # remove datadir
8 # xtrabackup move back
9 # restart
10 SELECT * FROM t4;
11 a
12 SELECT * FROM t2;
13 ERROR 42S02: Table 'test.t2' doesn't exist
14 SELECT * FROM t3;
15 ERROR 42S02: Table 'test.t3' doesn't exist
16 SELECT * FROM t5;
17 a
18 SELECT * FROM t1;
19 a
20 DROP TABLE t4, t5, t1;
21 CREATE TABLE t1_m1 (a INT NOT NULL) ENGINE=MyISAM;
22 CREATE TABLE t1_m2 (a INT NOT NULL) ENGINE=MyISAM;
23 CREATE TABLE t1 (a INT NOT NULL) ENGINE=MERGE UNION=(t1_m1, t1_m2) INSERT_METHOD=LAST;
24 CREATE TABLE t2_m1 (a INT NOT NULL) ENGINE=MyISAM;
25 CREATE TABLE t2_m2 (a INT NOT NULL) ENGINE=MyISAM;
26 CREATE TABLE t2 (a INT NOT NULL) ENGINE=MERGE UNION=(t2_m1, t2_m2) INSERT_METHOD=LAST;
27 CREATE TABLE t3_m1 (a INT NOT NULL) ENGINE=MyISAM;
28 CREATE TABLE t3_m2 (a INT NOT NULL) ENGINE=MyISAM;
29 CREATE TABLE t3 (a INT NOT NULL) ENGINE=MERGE UNION=(t3_m1, t3_m2) INSERT_METHOD=LAST;
30 ### Backup to dir
31 # xtrabackup prepare
32 # shutdown server
33 # remove datadir
34 # xtrabackup move back
35 # restart
36 SELECT * FROM t4;
37 a
38 SELECT * FROM t2;
39 ERROR 42S02: Table 'test.t2' doesn't exist
40 SELECT * FROM t3;
41 ERROR 42S02: Table 'test.t3' doesn't exist
42 SELECT * FROM t5;
43 a
44 SELECT * FROM t1;
45 a
46 DROP TABLE t4, t5, t1;
47 DROP TABLE t1_m1, t1_m2, t2_m1, t2_m2, t3_m1, t3_m2;
48 CREATE TABLE t1 (a INT NOT NULL) ENGINE=MyISAM;
49 CREATE TABLE t2 (a INT NOT NULL) ENGINE=MyISAM;
50 CREATE TABLE t3 (a INT NOT NULL) ENGINE=MyISAM;
51 ### Backup to dir
52 # xtrabackup prepare
53 # shutdown server
54 # remove datadir
55 # xtrabackup move back
56 # restart
57 SELECT * FROM t4;
58 a
59 SELECT * FROM t2;
60 ERROR 42S02: Table 'test.t2' doesn't exist
61 SELECT * FROM t3;
62 ERROR 42S02: Table 'test.t3' doesn't exist
63 SELECT * FROM t5;
64 a
65 SELECT * FROM t1;
66 a
67 DROP TABLE t4, t5, t1;