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