Debian Codegraph @

mysql-test/suite/sys_vars/t/wsrep_gtid_domain_id_basic.test

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_gtid_domain_id
5 --echo #
6
7 --echo # save the initial value
8 SET @wsrep_gtid_domain_id_global_saved = @@global.wsrep_gtid_domain_id;
9
10 --echo # default
11 SELECT @@global.wsrep_gtid_domain_id;
12
13 --echo
14 --echo # scope
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 SELECT @@session.wsrep_gtid_domain_id;
17 SET @@global.wsrep_gtid_domain_id=1;
18 SELECT @@global.wsrep_gtid_domain_id;
19
20 --echo
21 --echo # valid values
22 SET @@global.wsrep_gtid_domain_id=10;
23 SELECT @@global.wsrep_gtid_domain_id;
24 SET @@global.wsrep_gtid_domain_id=0;
25 SELECT @@global.wsrep_gtid_domain_id;
26 SET @@global.wsrep_gtid_domain_id=default;
27 SELECT @global.wsrep_gtid_domain_id;
28
29 --echo
30 --echo # invalid values
31 --error ER_WRONG_TYPE_FOR_VAR
32 SET @@global.wsrep_gtid_domain_id=NULL;
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET @@global.wsrep_gtid_domain_id='junk';
35 # expect warning : Truncated incorrect wsrep_gtid_domain_id value: '-1'
36 SET @@global.wsrep_gtid_domain_id=-1;
37 SELECT @global.wsrep_gtid_domain_id;
38
39 --echo
40 --echo # restore the initial value
41 SET @@global.wsrep_gtid_domain_id = @wsrep_gtid_domain_id_global_saved;
42
43 --echo # End of test