Debian Codegraph @

mysql-test/suite/galera/r/galera_var_wsrep_mode.result

raw
1 connection node_2;
2 connection node_1;
3 SELECT @@wsrep_mode;
4 @@wsrep_mode
5
6 SET GLOBAL wsrep_mode=DEFAULT;
7 SELECT @@wsrep_mode;
8 @@wsrep_mode
9
10 SET SESSION wsrep_mode=DEFAULT;
11 ERROR HY000: Variable 'wsrep_mode' is a GLOBAL variable and should be set with SET GLOBAL
12 SELECT @@global.wsrep_mode;
13 @@global.wsrep_mode
14
15 SELECT @@session.wsrep_mode;
16 ERROR HY000: Variable 'wsrep_mode' is a GLOBAL variable
17 SET GLOBAL wsrep_mode=A;
18 ERROR 42000: Variable 'wsrep_mode' can't be set to the value of 'A'
19 SET GLOBAL wsrep_mode='A';
20 ERROR 42000: Variable 'wsrep_mode' can't be set to the value of 'A'
21 SET GLOBAL wsrep_mode=NULL;
22 ERROR 42000: Variable 'wsrep_mode' can't be set to the value of 'NULL'
23 SET GLOBAL wsrep_mode=128;
24 ERROR 42000: Variable 'wsrep_mode' can't be set to the value of '128'
25 SET GLOBAL wsrep_mode=REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM;
26 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
27 SET GLOBAL wsrep_mode=1;
28 SELECT @@wsrep_mode;
29 @@wsrep_mode
30 STRICT_REPLICATION
31 SET GLOBAL wsrep_mode=32;
32 SELECT @@wsrep_mode;
33 @@wsrep_mode
34 DISALLOW_LOCAL_GTID
35 SET GLOBAL wsrep_mode='';
36 SELECT @@wsrep_mode;
37 @@wsrep_mode
38
39 SET GLOBAL wsrep_mode=STRICT_REPLICATION;
40 SELECT @@wsrep_mode;
41 @@wsrep_mode
42 STRICT_REPLICATION
43 SET GLOBAL wsrep_mode=BINLOG_ROW_FORMAT_ONLY;
44 SELECT @@wsrep_mode;
45 @@wsrep_mode
46 BINLOG_ROW_FORMAT_ONLY
47 SET GLOBAL wsrep_mode=REQUIRED_PRIMARY_KEY;
48 SELECT @@wsrep_mode;
49 @@wsrep_mode
50 REQUIRED_PRIMARY_KEY
51 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
52 SELECT @@wsrep_mode;
53 @@wsrep_mode
54 REPLICATE_MYISAM
55 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
56 SELECT @@wsrep_mode;
57 @@wsrep_mode
58 REPLICATE_ARIA
59 SET GLOBAL wsrep_mode=DISALLOW_LOCAL_GTID;
60 SELECT @@wsrep_mode;
61 @@wsrep_mode
62 DISALLOW_LOCAL_GTID
63 SET GLOBAL wsrep_mode='STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY';
64 SELECT @@wsrep_mode;
65 @@wsrep_mode
66 STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY
67 SET GLOBAL wsrep_mode='STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY,REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA,DISALLOW_LOCAL_GTID';
68 SELECT @@wsrep_mode;
69 @@wsrep_mode
70 STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY,REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA,DISALLOW_LOCAL_GTID
71 SET GLOBAL wsrep_mode='BINLOG_ROW_FORMAT_ONLY,STRICT_REPLICATION';
72 SELECT @@wsrep_mode;
73 @@wsrep_mode
74 STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY
75 SET GLOBAL wsrep_mode='STRICT_REPLICATION,REQUIRED_PRIMARY_KEY,REPLICATE_ARIA,DISALLOW_LOCAL_GTID';
76 SELECT @@wsrep_mode;
77 @@wsrep_mode
78 STRICT_REPLICATION,REQUIRED_PRIMARY_KEY,REPLICATE_ARIA,DISALLOW_LOCAL_GTID
79 SET GLOBAL wsrep_mode=DEFAULT;