Debian Codegraph @

mysql-test/suite/sys_vars/r/wsrep_gtid_domain_id_basic.result

raw
1 #
2 # wsrep_gtid_domain_id
3 #
4 # save the initial value
5 SET @wsrep_gtid_domain_id_global_saved = @@global.wsrep_gtid_domain_id;
6 # default
7 SELECT @@global.wsrep_gtid_domain_id;
8 @@global.wsrep_gtid_domain_id
9 0
10
11 # scope
12 SELECT @@session.wsrep_gtid_domain_id;
13 ERROR HY000: Variable 'wsrep_gtid_domain_id' is a GLOBAL variable
14 SET @@global.wsrep_gtid_domain_id=1;
15 SELECT @@global.wsrep_gtid_domain_id;
16 @@global.wsrep_gtid_domain_id
17 1
18
19 # valid values
20 SET @@global.wsrep_gtid_domain_id=10;
21 SELECT @@global.wsrep_gtid_domain_id;
22 @@global.wsrep_gtid_domain_id
23 10
24 SET @@global.wsrep_gtid_domain_id=0;
25 SELECT @@global.wsrep_gtid_domain_id;
26 @@global.wsrep_gtid_domain_id
27 0
28 SET @@global.wsrep_gtid_domain_id=default;
29 SELECT @global.wsrep_gtid_domain_id;
30 @global.wsrep_gtid_domain_id
31 NULL
32
33 # invalid values
34 SET @@global.wsrep_gtid_domain_id=NULL;
35 ERROR 42000: Incorrect argument type to variable 'wsrep_gtid_domain_id'
36 SET @@global.wsrep_gtid_domain_id='junk';
37 ERROR 42000: Incorrect argument type to variable 'wsrep_gtid_domain_id'
38 SET @@global.wsrep_gtid_domain_id=-1;
39 Warnings:
40 Warning 1292 Truncated incorrect wsrep_gtid_domain_id value: '-1'
41 SELECT @global.wsrep_gtid_domain_id;
42 @global.wsrep_gtid_domain_id
43 NULL
44
45 # restore the initial value
46 SET @@global.wsrep_gtid_domain_id = @wsrep_gtid_domain_id_global_saved;
47 # End of test