Debian Codegraph @

mysql-test/suite/rpl/t/rpl_multi_engine.test

raw
1 # See if replication between MyISAM, MEMORY and InnoDB works.
2
3 -- source include/master-slave.inc
4
5 connection slave;
6 -- source include/have_innodb.inc
7
8 connection master;
9 -- source include/have_innodb.inc
10 --disable_warnings
11 drop table if exists t1;
12 --enable_warnings
13
14 CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc
15 VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT
16 0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
17 ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY(id));
18
19 sync_slave_with_master;
20
21 # MyISAM to MyISAM then InnoDB then MEMORY
22
23 connection master;
24 alter table t1 engine=myisam;
25 show create table t1;
26 sync_slave_with_master;
27
28 connection slave;
29 alter table t1 engine=myisam;
30 show create table t1;
31
32 --source include/rpl_multi_engine.inc
33
34 connection slave;
35 alter table t1 engine=innodb;
36 show create table t1;
37
38 --source include/rpl_multi_engine.inc
39
40 connection slave;
41 alter table t1 engine=memory;
42 show create table t1;
43
44 --source include/rpl_multi_engine.inc
45
46 # MEMORY to ...
47
48 connection master;
49 alter table t1 engine=memory;
50 show create table t1;
51 sync_slave_with_master;
52
53 connection slave;
54 alter table t1 engine=myisam;
55 show create table t1;
56
57 --source include/rpl_multi_engine.inc
58
59 connection slave;
60 alter table t1 engine=innodb;
61 show create table t1;
62
63 --source include/rpl_multi_engine.inc
64
65 connection slave;
66 alter table t1 engine=memory;
67 show create table t1;
68
69 --source include/rpl_multi_engine.inc
70
71 # InnoDB to ...
72
73 connection master;
74 alter table t1 engine=innodb;
75 show create table t1;
76 sync_slave_with_master;
77
78 connection slave;
79 alter table t1 engine=myisam;
80 show create table t1;
81
82 --source include/rpl_multi_engine.inc
83
84 connection slave;
85 alter table t1 engine=innodb;
86 show create table t1;
87
88 --source include/rpl_multi_engine.inc
89
90 connection slave;
91 alter table t1 engine=memory;
92 show create table t1;
93
94 --source include/rpl_multi_engine.inc
95
96 # cleanup
97 connection master;
98 DROP TABLE t1;
99 sync_slave_with_master;
100
101 # End of 5.1 test case
102 --source include/rpl_end.inc