Debian Codegraph @

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

raw
1 --source include/have_ndb.inc
2 --source include/have_binlog_format_mixed_or_row.inc
3 --source suite/ndb_rpl/ndb_master-slave.inc
4 --source include/have_debug.inc
5
6 connection master;
7
8 CREATE TABLE t ( pk INT, PRIMARY KEY (pk) ) ENGINE=ndbcluster;
9 CREATE TABLE t1 ( pk INT, PRIMARY KEY (pk) ) ENGINE=ndbcluster;
10 CREATE TABLE t2 ( pk INT, PRIMARY KEY (pk) ) ENGINE=ndbcluster;
11 CREATE TABLE t3 ( pk INT, PRIMARY KEY (pk) ) ENGINE=ndbcluster;
12
13 INSERT INTO t (pk) VALUES (1);
14 INSERT INTO t1 (pk) VALUES (1);
15 INSERT INTO t2 (pk) VALUES (1);
16 INSERT INTO t3 (pk) VALUES (1);
17
18 --sync_slave_with_master
19 # connect to slave and ensure data it there.
20 --connection slave
21 select * from t1;
22
23 --connection master
24
25 INSERT INTO t (pk) VALUES (12);
26
27 let $table=t1;
28 source ndb_rpl_alter_wide_table.inc;
29
30 let $table=t2;
31 source ndb_rpl_alter_wide_table.inc;
32
33 --sync_slave_with_master
34 # connect to slave and ensure data it there.
35 --connection slave
36 select * from t2;
37
38 --connection master
39 DROP TABLE t1;
40 ALTER TABLE t3 ALGORITHM=INPLACE, ADD COLUMN (c1 INT);
41 DROP TABLE t;
42 DROP TABLE t2;
43 DROP TABLE t3;
44
45 --connection master
46
47 --source include/rpl_end.inc