Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_aria.inc
3
4 call mtr.add_suppression("WSREP: ALTER TABLE isolation failure");
5
6 --connection node_1
7 SET GLOBAL binlog_format='ROW';
8 create table before_t1(a int, count int, b int, key(b)) engine=Aria;
9 INSERT INTO before_t1 values (1,1,1);
10
11 SET @@global.wsrep_mode=STRICT_REPLICATION;
12 select @@global.wsrep_mode;
13
14 --connection node_2
15 SET @@global.wsrep_mode=STRICT_REPLICATION;
16 select @@global.wsrep_mode;
17
18 --connection node_1
19 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
20 CREATE TABLE t1(a int) engine=Aria;
21 SHOW WARNINGS;
22
23 --connection node_2
24 --error ER_NO_SUCH_TABLE
25 SHOW CREATE TABLE t1;
26
27 --connection node_1
28 CREATE TABLE t2(a int not null primary key) engine=InnoDB;
29
30 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
31 ALTER TABLE t2 engine=MyISAM;
32 SHOW WARNINGS;
33 SHOW CREATE TABLE t2;
34
35 --connection node_2
36 SHOW CREATE TABLE t2;
37
38 --connection node_1
39 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
40 TRUNCATE TABLE before_t1;
41 SELECT * FROM before_t1;
42
43 --connection node_2
44 SET SESSION wsrep_sync_wait=15;
45 SELECT @@wsrep_sync_wait;
46 SELECT * FROM before_t1;
47
48 --connection node_1
49 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
50 CREATE VIEW x1 AS SELECT * FROM before_t1;
51 --error ER_NO_SUCH_TABLE
52 SHOW CREATE VIEW x1;
53
54 --connection node_2
55 --error ER_NO_SUCH_TABLE
56 SHOW CREATE VIEW x1;
57
58 --connection node_1
59 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
60 CREATE DEFINER=`root`@`localhost` TRIGGER increment_before_t1
61 AFTER INSERT ON before_t1 FOR EACH ROW
62 UPDATE before_t1 SET before_t1.count = before_t1.count+1;
63
64 --error ER_TRG_DOES_NOT_EXIST
65 SHOW CREATE TRIGGER increment_before_t1;
66
67 --connection node_2
68
69 --error ER_TRG_DOES_NOT_EXIST
70 SHOW CREATE TRIGGER increment_before_t1;
71
72 --connection node_1
73 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
74 CREATE INDEX xx2 ON before_t1(a);
75 SHOW CREATE TABLE before_t1;
76
77 --connection node_2
78 SHOW CREATE TABLE before_t1;
79
80 --connection node_1
81 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
82 DROP INDEX b ON before_t1;
83 SHOW CREATE TABLE before_t1;
84
85 --connection node_2
86 SHOW CREATE TABLE before_t1;
87
88 --connection node_1
89 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
90 ALTER TABLE before_t1 ADD COLUMN f int;
91 SHOW CREATE TABLE before_t1;
92
93 --connection node_2
94 SHOW CREATE TABLE before_t1;
95
96 --connection node_1
97 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
98 RENAME TABLE before_t1 to after_t1;
99 SHOW CREATE TABLE before_t1;
100 --error ER_NO_SUCH_TABLE
101 SHOW CREATE TABLE after_t1;
102
103 --connection node_2
104 SHOW CREATE TABLE before_t1;
105 --error ER_NO_SUCH_TABLE
106 SHOW CREATE TABLE after_t1;
107
108 --connection node_1
109 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
110 DROP TABLE before_t1;
111
112 SHOW CREATE TABLE before_t1;
113
114 --connection node_2
115 SHOW CREATE TABLE before_t1;
116
117 #
118 # PROCEDURE, EVENT, FUNCTION
119 # Unfortunately accessed tables are opened only
120 # in SP execution so no hope at CREATE
121
122 #
123 # USER, ROLE, SERVER, DATABASE not really storage engine objects
124 #
125
126 --connection node_1
127 set @@global.wsrep_mode=default;
128 select @@global.wsrep_mode;
129
130 --connectIon node_2
131 set @@global.wsrep_mode=default;
132 select @@global.wsrep_mode;
133 DROP TABLE t2;
134 DROP TABLE before_t1;