Debian Codegraph @

mysql-test/suite/wsrep/r/wsrep_forced_binlog_format.result

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