Debian Codegraph @

mysql-test/suite/galera/t/galera_var_wsrep_mode.test

raw
1 --source include/galera_cluster.inc
2
3 # default
4 SELECT @@wsrep_mode;
5
6 SET GLOBAL wsrep_mode=DEFAULT;
7 SELECT @@wsrep_mode;
8
9 --error ER_GLOBAL_VARIABLE
10 SET SESSION wsrep_mode=DEFAULT;
11 SELECT @@global.wsrep_mode;
12 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
13 SELECT @@session.wsrep_mode;
14
15 #
16 # Incorrect input
17 #
18 --error ER_WRONG_VALUE_FOR_VAR
19 SET GLOBAL wsrep_mode=A;
20 --error ER_WRONG_VALUE_FOR_VAR
21 SET GLOBAL wsrep_mode='A';
22 --error ER_WRONG_VALUE_FOR_VAR
23 SET GLOBAL wsrep_mode=NULL;
24 --error ER_WRONG_VALUE_FOR_VAR
25 SET GLOBAL wsrep_mode=128;
26 --error ER_PARSE_ERROR
27 SET GLOBAL wsrep_mode=REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM;
28 #
29 # Correct input
30 #
31 SET GLOBAL wsrep_mode=1;
32 SELECT @@wsrep_mode;
33 SET GLOBAL wsrep_mode=32;
34 SELECT @@wsrep_mode;
35 SET GLOBAL wsrep_mode='';
36 SELECT @@wsrep_mode;
37 SET GLOBAL wsrep_mode=STRICT_REPLICATION;
38 SELECT @@wsrep_mode;
39 SET GLOBAL wsrep_mode=BINLOG_ROW_FORMAT_ONLY;
40 SELECT @@wsrep_mode;
41 SET GLOBAL wsrep_mode=REQUIRED_PRIMARY_KEY;
42 SELECT @@wsrep_mode;
43 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
44 SELECT @@wsrep_mode;
45 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
46 SELECT @@wsrep_mode;
47 SET GLOBAL wsrep_mode=DISALLOW_LOCAL_GTID;
48 SELECT @@wsrep_mode;
49 SET GLOBAL wsrep_mode='STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY';
50 SELECT @@wsrep_mode;
51 SET GLOBAL wsrep_mode='STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY,REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA,DISALLOW_LOCAL_GTID';
52 SELECT @@wsrep_mode;
53 SET GLOBAL wsrep_mode='BINLOG_ROW_FORMAT_ONLY,STRICT_REPLICATION';
54 SELECT @@wsrep_mode;
55 SET GLOBAL wsrep_mode='STRICT_REPLICATION,REQUIRED_PRIMARY_KEY,REPLICATE_ARIA,DISALLOW_LOCAL_GTID';
56 SELECT @@wsrep_mode;
57
58 # reset
59 SET GLOBAL wsrep_mode=DEFAULT;