Debian Codegraph @

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

raw
1 source include/master-slave.inc;
2 create database mysqltest;
3
4 create table mysqltest.t1 (n int PRIMARY KEY);
5 alter table mysqltest.t1 add m int;
6 insert into mysqltest.t1 values (1,2);
7 create table mysqltest.t2 (n int PRIMARY KEY);
8 insert into mysqltest.t2 values (45);
9 rename table mysqltest.t2 to mysqltest.t3, mysqltest.t1 to mysqltest.t2;
10 --source include/rpl_sync.inc
11 select * from mysqltest.t2;
12 select * from mysqltest.t3;
13 connection master;
14 drop database mysqltest;
15 --source include/rpl_sync.inc
16
17 # End of 4.1 tests
18 --source include/rpl_end.inc