Debian Codegraph @

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

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