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