Debian Codegraph @

mysql-test/suite/wsrep/t/wsrep_forced_binlog_format.test

raw
1 --source include/have_innodb.inc
2 --source include/have_wsrep_provider.inc
3 --source include/have_binlog_format_row.inc
4
5 --echo #
6 --echo # wsrep_forced_binlog_format
7 --echo #
8
9 --echo # save the initial value
10 SET @wsrep_forced_binlog_format_global_saved = @@global.wsrep_forced_binlog_format;
11
12 --echo # default
13 SELECT @@global.wsrep_forced_binlog_format;
14
15 --echo
16 --echo # scope
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 SELECT @@session.wsrep_forced_binlog_format;
19 SET @@global.wsrep_forced_binlog_format=STATEMENT;
20 SELECT @@global.wsrep_forced_binlog_format;
21
22 --echo
23 --echo # valid values
24 SET @@global.wsrep_forced_binlog_format=STATEMENT;
25 SELECT @@global.wsrep_forced_binlog_format;
26 SET @@global.wsrep_forced_binlog_format=ROW;
27 SELECT @@global.wsrep_forced_binlog_format;
28 SET @@global.wsrep_forced_binlog_format=MIXED;
29 SELECT @@global.wsrep_forced_binlog_format;
30 SET @@global.wsrep_forced_binlog_format=NONE;
31 SELECT @@global.wsrep_forced_binlog_format;
32 SET @@global.wsrep_forced_binlog_format=default;
33 SELECT @@global.wsrep_forced_binlog_format;
34
35 --echo
36 --echo # invalid values
37 --error ER_WRONG_VALUE_FOR_VAR
38 SET @@global.wsrep_forced_binlog_format=NULL;
39 --error ER_WRONG_VALUE_FOR_VAR
40 SET @@global.wsrep_forced_binlog_format='junk';
41 --error ER_WRONG_VALUE_FOR_VAR
42 SET @@global.wsrep_forced_binlog_format=ON;
43
44 --echo
45 --echo # restore the initial value
46 SET @@global.wsrep_forced_binlog_format = @wsrep_forced_binlog_format_global_saved;
47
48 --echo # End of test