Debian Codegraph @

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

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