Debian Codegraph @

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

raw
1 #
2 # wsrep_osu_method
3 #
4 # save the initial value
5 SET @wsrep_osu_method_global_saved = @@global.wsrep_osu_method;
6 # default
7 SELECT @@global.wsrep_osu_method;
8 @@global.wsrep_osu_method
9 TOI
10
11 # scope
12 SELECT @@session.wsrep_osu_method;
13 @@session.wsrep_osu_method
14 TOI
15 SET @@global.wsrep_osu_method=TOI;
16 SELECT @@global.wsrep_osu_method;
17 @@global.wsrep_osu_method
18 TOI
19
20 # valid values
21 SET @@global.wsrep_osu_method=TOI;
22 SELECT @@global.wsrep_osu_method;
23 @@global.wsrep_osu_method
24 TOI
25 SET @@global.wsrep_osu_method=RSU;
26 SELECT @@global.wsrep_osu_method;
27 @@global.wsrep_osu_method
28 RSU
29 SET @@global.wsrep_osu_method="RSU";
30 SELECT @@global.wsrep_osu_method;
31 @@global.wsrep_osu_method
32 RSU
33 SET @@global.wsrep_osu_method=default;
34 SELECT @@global.wsrep_osu_method;
35 @@global.wsrep_osu_method
36 TOI
37 SET @@global.wsrep_osu_method=1;
38 SELECT @@global.wsrep_osu_method;
39 @@global.wsrep_osu_method
40 RSU
41
42 # invalid values
43 SET @@global.wsrep_osu_method=4;
44 ERROR 42000: Variable 'wsrep_OSU_method' can't be set to the value of '4'
45 SELECT @@global.wsrep_osu_method;
46 @@global.wsrep_osu_method
47 RSU
48 SET @@global.wsrep_osu_method=NULL;
49 ERROR 42000: Variable 'wsrep_OSU_method' can't be set to the value of 'NULL'
50 SELECT @@global.wsrep_osu_method;
51 @@global.wsrep_osu_method
52 RSU
53 SET @@global.wsrep_osu_method='junk';
54 ERROR 42000: Variable 'wsrep_OSU_method' can't be set to the value of 'junk'
55 SELECT @@global.wsrep_osu_method;
56 @@global.wsrep_osu_method
57 RSU
58
59 # restore the initial value
60 SET @@global.wsrep_osu_method = @wsrep_osu_method_global_saved;
61 # End of test