1#
2# wsrep_on
3#
4# save the initial values
5SET @wsrep_on_global_saved = @@global.wsrep_on;
6SET @wsrep_on_session_saved = @@session.wsrep_on;
7# default
8SELECT @@global.wsrep_on;
9@@global.wsrep_on
100
11SELECT @@session.wsrep_on;
12@@session.wsrep_on
130
14
15# scope and valid values
16SET @@global.wsrep_on=OFF;
17SELECT @@global.wsrep_on;
18@@global.wsrep_on
190
20SET @@global.wsrep_on=ON;
21SELECT @@global.wsrep_on;
22@@global.wsrep_on
231
24SET @@session.wsrep_on=OFF;
25SELECT @@session.wsrep_on;
26@@session.wsrep_on
270
28SET @@session.wsrep_on=ON;
29SELECT @@session.wsrep_on;
30@@session.wsrep_on
311
32SET @@session.wsrep_on=default;
33SELECT @@session.wsrep_on;
34@@session.wsrep_on
351
36
37# invalid values
38SET @@global.wsrep_on=NULL;
39ERROR 42000: Variable 'wsrep_on' can't be set to the value of 'NULL'
40SET @@global.wsrep_on='junk';
41ERROR 42000: Variable 'wsrep_on' can't be set to the value of 'junk'
42SET @@session.wsrep_on=NULL;
43ERROR 42000: Variable 'wsrep_on' can't be set to the value of 'NULL'
44SET @@session.wsrep_on='junk';
45ERROR 42000: Variable 'wsrep_on' can't be set to the value of 'junk'
46
47# restore the initial values
48SET @@global.wsrep_on = @wsrep_on_global_saved;
49SET @@session.wsrep_on = @wsrep_on_session_saved;
50# End of test
51