Debian Codegraph @

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

raw
1 #
2 # wsrep_gtid_mode
3 #
4 # save the initial value
5 SET @wsrep_gtid_mode_global_saved = @@global.wsrep_gtid_mode;
6 # default
7 SELECT @@global.wsrep_gtid_mode;
8 @@global.wsrep_gtid_mode
9 0
10 SELECT @@session.wsrep_gtid_mode;
11 ERROR HY000: Variable 'wsrep_gtid_mode' is a GLOBAL variable
12
13 # scope and valid values
14 SET @@global.wsrep_gtid_mode=OFF;
15 SELECT @@global.wsrep_gtid_mode;
16 @@global.wsrep_gtid_mode
17 0
18 SET @@global.wsrep_gtid_mode=ON;
19 SELECT @@global.wsrep_gtid_mode;
20 @@global.wsrep_gtid_mode
21 1
22
23 # invalid values
24 SET @@global.wsrep_gtid_mode=NULL;
25 ERROR 42000: Variable 'wsrep_gtid_mode' can't be set to the value of 'NULL'
26 SET @@global.wsrep_gtid_mode='junk';
27 ERROR 42000: Variable 'wsrep_gtid_mode' can't be set to the value of 'junk'
28
29 # restore the initial value
30 SET @@global.wsrep_gtid_mode = @wsrep_gtid_mode_global_saved;
31 # End of test