Debian Codegraph @

mysql-test/suite/galera/t/mdev-29775.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_aria.inc
3
4 #
5 # MDEV-29775 : Assertion `0' failed in void Protocol::end_statement() when adding data to the MyISAM table after setting wsrep_mode=replicate_myisam
6 #
7 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
8 CREATE TABLE t (f0 CHAR(0)) ENGINE=MyISAM;
9 INSERT INTO t VALUES();
10 SELECT * FROM t;
11 --connection node_2
12 SELECT * FROM t;
13 DROP TABLE t;
14
15 --connection node_1
16 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
17 SET GLOBAL wsrep_forced_binlog_format=ROW;
18 CREATE TABLE t (f0 CHAR(0)) ENGINE=MyISAM;
19 INSERT INTO t VALUES();
20 SELECT * FROM t;
21 --connection node_2
22 SELECT * FROM t;
23 DROP TABLE t;
24
25 --connection node_1
26 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
27 CREATE TABLE t (f0 CHAR(0)) ENGINE=Aria;
28 INSERT INTO t VALUES();
29 SELECT * FROM t;
30 --connection node_2
31 SELECT * FROM t;
32 DROP TABLE t;
33
34 --connection node_1
35 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
36 SET GLOBAL wsrep_forced_binlog_format=ROW;
37 CREATE TABLE t (f0 CHAR(0)) ENGINE=Aria;
38 INSERT INTO t VALUES();
39 SELECT * FROM t;
40 --connection node_2
41 SELECT * FROM t;
42 DROP TABLE t;
43
44 --connection node_1
45 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
46 --error ER_WRONG_ARGUMENTS
47 SET GLOBAL wsrep_forced_binlog_format=MIXED;
48 --error ER_WRONG_ARGUMENTS
49 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
50
51 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
52 --error ER_WRONG_ARGUMENTS
53 SET GLOBAL wsrep_forced_binlog_format=MIXED;
54 --error ER_WRONG_ARGUMENTS
55 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
56
57 SET GLOBAL wsrep_mode=DEFAULT;
58 SET GLOBAL wsrep_forced_binlog_format=MIXED;
59 --error ER_WRONG_ARGUMENTS
60 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
61 --error ER_WRONG_ARGUMENTS
62 SET GLOBAL wsrep_mode = REPLICATE_ARIA;
63
64 SET GLOBAL wsrep_mode=DEFAULT;
65 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
66 --error ER_WRONG_ARGUMENTS
67 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
68 --error ER_WRONG_ARGUMENTS
69 SET GLOBAL wsrep_mode = REPLICATE_ARIA;
70
71 SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
72 SET GLOBAL wsrep_mode=DEFAULT;
73 SET GLOBAL wsrep_forced_binlog_format=MIXED;
74 --error ER_WRONG_ARGUMENTS
75 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
76 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
77 --error ER_WRONG_ARGUMENTS
78 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
79
80 SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
81 SET GLOBAL wsrep_mode=DEFAULT;