Debian Codegraph @

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

raw
1
2 # Test for BUG#28908 Replication: set global server_id is not setting the session server_id
3
4 -- source include/have_log_bin.inc
5
6 let $saved_server_id=`select @@server_id`;
7 set global server_id=1;
8 reset master;
9
10 -- disable_warnings
11 drop table if exists t1,t2,t3;
12 -- enable_warnings
13
14 --let $i=3
15 while ($i)
16 {
17 RESET MASTER;
18 --eval set global server_id=$i
19 --eval create table t$i (a int)
20
21 --let $row_number= 4
22 --let $binlog_server_id= query_get_value(SHOW BINLOG EVENTS, Server_id, $row_number)
23 --let $server_id= `SELECT @@server_id`
24
25 --let $assert_text= Server Ids must match ($binlog_server_id == $server_id)
26 --let $assert_cond= $binlog_server_id = $server_id
27 --source include/assert.inc
28
29 --dec $i
30 }
31
32 # cleanup
33 eval set global server_id=$saved_server_id;
34 drop table t1,t2,t3;