1 include/master-slave.inc
3 create database mysqltest;
4 create table mysqltest.t1 ( n int);
5 alter table mysqltest.t1 add m int;
6 insert into mysqltest.t1 values (1,2);
7 create table mysqltest.t2 (n int);
8 insert into mysqltest.t2 values (45);
9 rename table mysqltest.t2 to mysqltest.t3, mysqltest.t1 to mysqltest.t2;
10 select * from mysqltest.t2;
13 select * from mysqltest.t3;
16 drop database mysqltest;
18 # BUG#56226 Table map set to 0 after altering MyISAM table
20 SET SESSION binlog_format='ROW';
22 CREATE TABLE t1 (a INT, b INT) ENGINE MyISAM;
23 CREATE TABLE t2 (a VARCHAR(255), b VARCHAR(255)) ENGINE MyISAM;
24 CREATE TRIGGER trg_t1ai
25 AFTER INSERT ON t1 FOR EACH ROW
27 INSERT INTO t2 (a) VALUES (NEW.a);
29 ALTER TABLE t1 CHANGE b c INT;
30 ALTER TABLE t2 CHANGE b c VARCHAR(255);
32 INSERT INTO t1 (a) VALUES(2);
33 include/diff_tables.inc [master:t1, slave:t1]
34 include/diff_tables.inc [master:t2, slave:t2]