Debian Codegraph @

mysql-test/suite/ndb_binlog/t/ndb_binlog_variant_ddl.test

raw
1 ########################################################
2 # Test distribution of schema operations with a config
3 # having different binlog variants in the mysqld's
4
5 ########################################################
6 -- source include/have_ndb.inc
7 -- source include/have_binlog_format_row.inc
8
9 # Setup connections
10 connect(mysqld1,127.0.0.1,root,,test,$MASTER_MYPORT);
11 connect(mysqld2,127.0.0.1,root,,test,$MASTER_MYPORT1);
12 connect(mysqld3,127.0.0.1,root,,test,$MASTER_MYPORT2);
13 connect(mysqld4,127.0.0.1,root,,test,$MASTER_MYPORT3);
14
15 connection mysqld1;
16 show variables like '%log_update%';
17
18 connection mysqld2;
19 show variables like '%log_update%';
20
21 connection mysqld3;
22 show variables like '%log_update%';
23
24 connection mysqld4;
25 show variables like '%log_update%';
26
27 connection mysqld1;
28 let $i=100;
29 while ($i)
30 {
31 eval create table t1(a int) engine=ndb;
32 eval drop table t1;
33 dec $i;
34 }
35
36 # No lingering 't1' tables on any mysqlds:
37
38 connection mysqld1;
39 --error ER_BAD_TABLE_ERROR
40 drop table t1;
41
42 connection mysqld2;
43 --error ER_BAD_TABLE_ERROR
44 drop table t1;
45
46 connection mysqld3;
47 --error ER_BAD_TABLE_ERROR
48 drop table t1;
49
50 connection mysqld4;
51 --error ER_BAD_TABLE_ERROR
52 drop table t1;