Debian Codegraph @

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

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