Debian Codegraph @

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

raw
1 -- source include/have_multi_ndb.inc
2 -- source include/have_binlog_format_mixed_or_row.inc
3
4 --disable_warnings
5 connection server2;
6 drop table if exists t1,t2,t3;
7 reset master;
8 connection server1;
9 drop table if exists t1,t2,t3;
10 reset master;
11 --enable_warnings
12
13 # basic SQL_LOG_BIN functionality
14 # see updates from one thread but not the other
15 connect (con1,localhost,root,,);
16 connect (con2,localhost,root,,);
17 # do some stuff with SQL_LOG_BIN=0
18 connection con2;
19 set SQL_LOG_BIN=0;
20 create database mysqltest;
21 use mysqltest;
22 create table t1 (a int key, b int) engine=ndb;
23 create table t2 (a int key, b int) engine=ndb;
24 insert into t1 values (1,1);
25 alter table t1 add c int;
26 # we should not see it in the local server
27 -- source include/show_binlog_events.inc
28 reset master;
29 # we should not see it in another server
30 connection server2;
31 use mysqltest;
32 insert into t2 values (1,1);
33 -- source include/show_binlog_events.inc
34 reset master;
35 # but if you do stuff in "default" client setting
36 connection con1;
37 use mysqltest;
38 drop table t1;
39 drop table t2;
40 create table t1 (d int key, e int) engine=ndb;
41 create table t2 (d int key, e int) engine=ndb;
42 insert into t1 values (1,1);
43 -- source include/show_binlog_events.inc
44 # and in another server
45 connection server2;
46 use mysqltest;
47 insert into t2 values (1,1);
48 -- source include/show_binlog_events.inc
49 drop database mysqltest;