Debian Codegraph @

mysql-test/suite/binlog/t/binlog_server_id.test

raw
1 # Test for BUG#28908 Replication: set global server_id is not setting the session server_id
2
3 -- source include/have_log_bin.inc
4
5 let $saved_server_id=`select @@server_id`;
6 set global server_id=1;
7 reset master;
8
9 -- disable_warnings
10 drop table if exists t1,t2,t3;
11 -- enable_warnings
12
13 create table t1 (a int);
14 select @@server_id;
15 source include/show_binlog_events2.inc;
16
17 set global server_id=2;
18 create table t2 (b int);
19 select @@server_id;
20 source include/show_binlog_events2.inc;
21
22 set global server_id=3;
23 create table t3 (c int);
24 select @@server_id;
25 source include/show_binlog_events2.inc;
26
27 # cleanup
28 eval set global server_id=$saved_server_id;
29 drop table t1,t2,t3;