Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
5 connection node_2;
6 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
7 connection node_1;
8 CREATE TABLE t1 (f1 INT PRIMARY KEY) Engine=MyISAM;
9 INSERT INTO t1 VALUES (1);
10 INSERT INTO t1 VALUES (2), (3);
11 INSERT INTO t1 SELECT 4 FROM DUAL UNION ALL SELECT 5 FROM DUAL;
12 connection node_2;
13 SELECT COUNT(*) AS EXPECT_5 FROM t1;
14 EXPECT_5
15 5
16 DROP TABLE t1;
17 connection node_1;
18 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(100)) ENGINE=MyISAM;
19 INSERT INTO t1 VALUES (1, 'abc'),(2,'abc'), (3, 'xxx');
20 REPLACE INTO t1 VALUES (1, 'klm'), (2,'xyz');
21 REPLACE INTO t1 SELECT 3, 'yyy' FROM DUAL;
22 connection node_2;
23 SELECT COUNT(*) AS EXPECT_3 FROM t1;
24 EXPECT_3
25 3
26 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f1 = 1 AND f2 = 'klm';
27 EXPECT_1
28 1
29 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f1 = 2 AND f2 = 'xyz';
30 EXPECT_1
31 1
32 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f1 = 3 AND f2 = 'yyy';
33 EXPECT_1
34 1
35 connection node_1;
36 UPDATE t1 SET f2 = 'zzz' WHERE f2 = 'yyy';
37 connection node_2;
38 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'zzz';
39 EXPECT_1
40 1
41 connection node_1;
42 DELETE FROM t1 WHERE f2 = 'zzz';
43 connection node_2;
44 SELECT COUNT(*) AS EXPECT_0 FROM t1 WHERE f2 = 'zzz';
45 EXPECT_0
46 0
47 connection node_1;
48 TRUNCATE TABLE t1;
49 connection node_2;
50 SELECT COUNT(*) AS EXPECT_0 FROM t1;
51 EXPECT_0
52 0
53 DROP TABLE t1;
54 connection node_1;
55 CREATE TABLE t1 (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=MyISAM;
56 CREATE TABLE t2 (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
57 SET AUTOCOMMIT=OFF;
58 START TRANSACTION;
59 INSERT INTO t1 VALUES (1);
60 INSERT INTO t2 VALUES (1);
61 COMMIT;
62 connection node_2;
63 SELECT COUNT(*) AS EXPECT_1 FROM t1;
64 EXPECT_1
65 1
66 SELECT COUNT(*) AS EXPECT_1 FROM t2;
67 EXPECT_1
68 1
69 connection node_1;
70 START TRANSACTION;
71 INSERT INTO t1 VALUES (2);
72 INSERT INTO t2 VALUES (2);
73 ROLLBACK;
74 Warnings:
75 Warning 1196 Some non-transactional changed tables couldn't be rolled back
76 connection node_2;
77 SELECT COUNT(*) AS EXPECT_2 FROM t1;
78 EXPECT_2
79 2
80 SELECT COUNT(*) AS EXPECT_1 FROM t2;
81 EXPECT_1
82 1
83 DROP TABLE t1;
84 DROP TABLE t2;
85 connection node_1;
86 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=MyISAM;
87 CREATE TABLE t2 (f2 INTEGER PRIMARY KEY) ENGINE=InnoDB;
88 START TRANSACTION;
89 INSERT INTO t1 VALUES (1);
90 INSERT INTO t2 VALUES (1);
91 connection node_2;
92 INSERT INTO t1 VALUES (1);
93 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
94 connection node_1;
95 COMMIT;
96 DROP TABLE t1, t2;
97 connection node_1;
98 CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY, b INT) ENGINE=MyISAM;
99 INSERT INTO t1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);
100 PREPARE upd from 'update t1 set b = 100 where id = 5';
101 PREPARE ins from 'insert into t1 values (11,11)';
102 PREPARE del from 'delete from t1 where id = 4';
103 PREPARE rep from 'replace into t1 values (12,12),(6,600)';
104 EXECUTE upd;
105 EXECUTE ins;
106 EXECUTE del;
107 EXECUTE rep;
108 SELECT * FROM t1 ORDER BY id;
109 id b
110 1 1
111 2 2
112 3 3
113 5 100
114 6 600
115 7 7
116 8 8
117 9 9
118 10 10
119 11 11
120 12 12
121 connection node_2;
122 SELECT * FROM t1 ORDER BY id;
123 id b
124 1 1
125 2 2
126 3 3
127 5 100
128 6 600
129 7 7
130 8 8
131 9 9
132 10 10
133 11 11
134 12 12
135 DROP TABLE t1;
136 connection node_1;
137 CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY, b INT) ENGINE=MyISAM;
138 INSERT INTO t1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);
139 CREATE PROCEDURE proc()
140 BEGIN
141 UPDATE t1 set b = 100 WHERE id = 5;
142 INSERT INTO t1 VALUES (11,11);
143 DELETE FROM t1 WHERE id = 4;
144 REPLACE INTO t1 VALUES (12,12),(6,600);
145 COMMIT;
146 END|
147 CALL proc();
148 SELECT * FROM t1 ORDER BY id;
149 id b
150 1 1
151 2 2
152 3 3
153 5 100
154 6 600
155 7 7
156 8 8
157 9 9
158 10 10
159 11 11
160 12 12
161 connection node_2;
162 SELECT * FROM t1 ORDER BY id;
163 id b
164 1 1
165 2 2
166 3 3
167 5 100
168 6 600
169 7 7
170 8 8
171 9 9
172 10 10
173 11 11
174 12 12
175 DROP PROCEDURE proc;
176 DROP TABLE t1;
177 connection node_1;
178 CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY, b INT) ENGINE=MyISAM;
179 CREATE TABLE t2 (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT) ENGINE=MyISAM;
180 INSERT INTO t1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);
181 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 VALUES (NULL, NEW.b);
182 CREATE TRIGGER tr2 BEFORE UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (NULL, OLD.b),(NULL, NEW.b);
183 CREATE TRIGGER tr3 BEFORE DELETE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (NULL, OLD.b);
184 INSERT INTO t1 VALUES (11,11);
185 UPDATE t1 SET b = 200 WHERE id = 2;
186 DELETE FROM t1 where id = 5;
187 SELECT * FROM t1 ORDER BY id;
188 id b
189 1 1
190 2 200
191 3 3
192 4 4
193 6 6
194 7 7
195 8 8
196 9 9
197 10 10
198 11 11
199 SELECT * FROM t2 ORDER BY id;
200 id b
201 1 11
202 2 2
203 3 200
204 4 5
205 connection node_2;
206 SELECT COUNT(*) FROM t1;
207 COUNT(*)
208 10
209 SELECT * FROM t1 ORDER BY id;
210 id b
211 1 1
212 2 200
213 3 3
214 4 4
215 6 6
216 7 7
217 8 8
218 9 9
219 10 10
220 11 11
221 SELECT * FROM t2 ORDER BY id;
222 id b
223 1 11
224 2 2
225 3 200
226 4 5
227 DROP TRIGGER tr1;
228 DROP TRIGGER tr2;
229 DROP TRIGGER tr3;
230 DROP TABLE t1, t2;
231 CREATE TABLE t1 (a INT, b INT, UNIQUE(a)) ENGINE=MyISAM;
232 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=1;
233 INSERT INTO t1 (a,b) VALUES (10,20);
234 SELECT * from t1;
235 a b
236 1 20
237 connection node_2;
238 SELECT * from t1;
239 a b
240 1 20
241 connection node_1;
242 DROP TABLE t1;
243 #
244 # MDEV-11152: wsrep_replicate_myisam: SELECT gets replicated using TO
245 #
246 connection node_1;
247 CREATE TABLE t1 (i INT NOT NULL PRIMARY KEY) ENGINE=INNODB;
248 INSERT INTO t1 VALUES(1);
249 SELECT * FROM t1;
250 i
251 1
252 DROP TABLE t1;
253 SET GLOBAL wsrep_mode = DEFAULT;
254 connection node_2;
255 SET GLOBAL wsrep_mode = DEFAULT;