1#
2# wsrep_forced_binlog_format
3#
4# save the initial value
5SET @wsrep_forced_binlog_format_global_saved = @@global.wsrep_forced_binlog_format;
6# default
7SELECT @@global.wsrep_forced_binlog_format;
8@@global.wsrep_forced_binlog_format
9NONE
10
11# scope
12SELECT @@session.wsrep_forced_binlog_format;
13ERROR HY000: Variable 'wsrep_forced_binlog_format' is a GLOBAL variable
14SET @@global.wsrep_forced_binlog_format=STATEMENT;
15SELECT @@global.wsrep_forced_binlog_format;
16@@global.wsrep_forced_binlog_format
17STATEMENT
18
19# valid values
20SET @@global.wsrep_forced_binlog_format=STATEMENT;
21SELECT @@global.wsrep_forced_binlog_format;
22@@global.wsrep_forced_binlog_format
23STATEMENT
24SET @@global.wsrep_forced_binlog_format=ROW;
25SELECT @@global.wsrep_forced_binlog_format;
26@@global.wsrep_forced_binlog_format
27ROW
28SET @@global.wsrep_forced_binlog_format=MIXED;
29SELECT @@global.wsrep_forced_binlog_format;
30@@global.wsrep_forced_binlog_format
31MIXED
32SET @@global.wsrep_forced_binlog_format=NONE;
33SELECT @@global.wsrep_forced_binlog_format;
34@@global.wsrep_forced_binlog_format
35NONE
36SET @@global.wsrep_forced_binlog_format=default;
37SELECT @@global.wsrep_forced_binlog_format;
38@@global.wsrep_forced_binlog_format
39NONE
40
41# invalid values
42SET @@global.wsrep_forced_binlog_format=NULL;
43ERROR 42000: Variable 'wsrep_forced_binlog_format' can't be set to the value of 'NULL'
44SET @@global.wsrep_forced_binlog_format='junk';
45ERROR 42000: Variable 'wsrep_forced_binlog_format' can't be set to the value of 'junk'
46SET @@global.wsrep_forced_binlog_format=ON;
47ERROR 42000: Variable 'wsrep_forced_binlog_format' can't be set to the value of 'ON'
48
49# restore the initial value
50SET @@global.wsrep_forced_binlog_format = @wsrep_forced_binlog_format_global_saved;
51# End of test
52