Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_alter_column.test

raw
1 --source include/have_ndb.inc
2 --source suite/ndb_rpl/ndb_master-slave.inc
3
4 #
5 # Test rename column
6 #
7 --connection master
8 CREATE TABLE t1 (a INT KEY, b INT) ROW_FORMAT=DYNAMIC ENGINE=NDB;
9
10 INSERT INTO t1 VALUES (1,1),(2,2),(3,3);
11
12 ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE b c INT;
13
14 --sync_slave_with_master
15 connection slave;
16 SELECT * FROM t1 ORDER BY a;
17
18 connection master;
19
20 INSERT INTO t1 VALUES (6,6),(7,7),(8,8);
21 SELECT * FROM t1 ORDER BY a;
22
23 --sync_slave_with_master
24 connection slave;
25 SELECT * FROM t1 ORDER BY a;
26
27 # cleanup
28 --connection master
29 DROP TABLE t1;
30 -- source include/rpl_end.inc