Debian Codegraph @

mysql-test/suite/galera/r/mdev-29775.result

raw
1 connection node_2;
2 connection node_1;
3 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
4 CREATE TABLE t (f0 CHAR(0)) ENGINE=MyISAM;
5 INSERT INTO t VALUES();
6 SELECT * FROM t;
7 f0
8 NULL
9 connection node_2;
10 SELECT * FROM t;
11 f0
12 NULL
13 DROP TABLE t;
14 connection node_1;
15 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
16 SET GLOBAL wsrep_forced_binlog_format=ROW;
17 CREATE TABLE t (f0 CHAR(0)) ENGINE=MyISAM;
18 INSERT INTO t VALUES();
19 SELECT * FROM t;
20 f0
21 NULL
22 connection node_2;
23 SELECT * FROM t;
24 f0
25 NULL
26 DROP TABLE t;
27 connection node_1;
28 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
29 CREATE TABLE t (f0 CHAR(0)) ENGINE=Aria;
30 INSERT INTO t VALUES();
31 SELECT * FROM t;
32 f0
33 NULL
34 connection node_2;
35 SELECT * FROM t;
36 f0
37 NULL
38 DROP TABLE t;
39 connection node_1;
40 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
41 SET GLOBAL wsrep_forced_binlog_format=ROW;
42 CREATE TABLE t (f0 CHAR(0)) ENGINE=Aria;
43 INSERT INTO t VALUES();
44 SELECT * FROM t;
45 f0
46 NULL
47 connection node_2;
48 SELECT * FROM t;
49 f0
50 NULL
51 DROP TABLE t;
52 connection node_1;
53 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
54 SET GLOBAL wsrep_forced_binlog_format=MIXED;
55 ERROR HY000: wsrep_forced_binlog_format=[MIXED|STATEMENT] can't be set if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA]
56 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
57 ERROR HY000: wsrep_forced_binlog_format=[MIXED|STATEMENT] can't be set if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA]
58 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
59 SET GLOBAL wsrep_forced_binlog_format=MIXED;
60 ERROR HY000: wsrep_forced_binlog_format=[MIXED|STATEMENT] can't be set if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA]
61 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
62 ERROR HY000: wsrep_forced_binlog_format=[MIXED|STATEMENT] can't be set if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA]
63 SET GLOBAL wsrep_mode=DEFAULT;
64 SET GLOBAL wsrep_forced_binlog_format=MIXED;
65 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
66 ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
67 SET GLOBAL wsrep_mode = REPLICATE_ARIA;
68 ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
69 SET GLOBAL wsrep_mode=DEFAULT;
70 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
71 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
72 ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
73 SET GLOBAL wsrep_mode = REPLICATE_ARIA;
74 ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
75 SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
76 SET GLOBAL wsrep_mode=DEFAULT;
77 SET GLOBAL wsrep_forced_binlog_format=MIXED;
78 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
79 ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
80 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
81 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
82 ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
83 SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
84 SET GLOBAL wsrep_mode=DEFAULT;