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
5let $saved_server_id=`select @@server_id`;
6set global server_id=1;
7reset master;
8
9-- disable_warnings
10drop table if exists t1,t2,t3;
11-- enable_warnings
12
13create table t1 (a int);
14select @@server_id;
15source include/show_binlog_events2.inc;
16
17set global server_id=2;
18create table t2 (b int);
19select @@server_id;
20source include/show_binlog_events2.inc;
21
22set global server_id=3;
23create table t3 (c int);
24select @@server_id;
25source include/show_binlog_events2.inc;
26
27# cleanup
28eval set global server_id=$saved_server_id;
29drop table t1,t2,t3;
30