Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE SEQUENCE s INCREMENT=0 CACHE=5 ENGINE=InnoDB;
5 CREATE TABLE t1 (f1 INT PRIMARY KEY DEFAULT NEXTVAL(s), f2 INT) ENGINE=InnoDB;
6 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
7 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
8 connection node_1;
9 BEGIN;
10 INSERT INTO t1(f2) values (1);
11 INSERT INTO t1(f2) values (1);
12 INSERT INTO t1(f2) values (1);
13 INSERT INTO t1(f2) values (1);
14 INSERT INTO t1(f2) values (1);
15 INSERT INTO t1(f2) values (1);
16 INSERT INTO t1(f2) values (1);
17 INSERT INTO t1(f2) values (1);
18 INSERT INTO t1(f2) values (1);
19 INSERT INTO t1(f2) values (1);
20 COMMIT;
21 connection node_2;
22 BEGIN;
23 INSERT INTO t1(f2) values (1);
24 INSERT INTO t1(f2) values (1);
25 INSERT INTO t1(f2) values (1);
26 INSERT INTO t1(f2) values (1);
27 INSERT INTO t1(f2) values (1);
28 INSERT INTO t1(f2) values (1);
29 INSERT INTO t1(f2) values (1);
30 INSERT INTO t1(f2) values (1);
31 INSERT INTO t1(f2) values (1);
32 INSERT INTO t1(f2) values (1);
33 COMMIT;
34 connection node_2a;
35 BEGIN;
36 INSERT INTO t1(f2) values (1);
37 INSERT INTO t1(f2) values (1);
38 INSERT INTO t1(f2) values (1);
39 INSERT INTO t1(f2) values (1);
40 INSERT INTO t1(f2) values (1);
41 INSERT INTO t1(f2) values (1);
42 INSERT INTO t1(f2) values (1);
43 INSERT INTO t1(f2) values (1);
44 INSERT INTO t1(f2) values (1);
45 INSERT INTO t1(f2) values (1);
46 COMMIT;
47 connection node_1a;
48 BEGIN;
49 INSERT INTO t1(f2) values (1);
50 INSERT INTO t1(f2) values (1);
51 INSERT INTO t1(f2) values (1);
52 INSERT INTO t1(f2) values (1);
53 INSERT INTO t1(f2) values (1);
54 INSERT INTO t1(f2) values (1);
55 INSERT INTO t1(f2) values (1);
56 INSERT INTO t1(f2) values (1);
57 INSERT INTO t1(f2) values (1);
58 INSERT INTO t1(f2) values (1);
59 COMMIT;
60 connection node_2;
61 SELECT LASTVAL(s);
62 LASTVAL(s)
63 40
64 connection node_1;
65 SELECT LASTVAL(s);
66 LASTVAL(s)
67 19
68 connection node_2a;
69 SELECT LASTVAL(s);
70 LASTVAL(s)
71 60
72 connection node_1a;
73 SELECT LASTVAL(s);
74 LASTVAL(s)
75 81
76 connection node_1;
77 SELECT * FROM t1;
78 f1 f2
79 1 1
80 3 1
81 5 1
82 7 1
83 9 1
84 11 1
85 13 1
86 15 1
87 17 1
88 19 1
89 22 1
90 24 1
91 26 1
92 28 1
93 30 1
94 32 1
95 34 1
96 36 1
97 38 1
98 40 1
99 42 1
100 44 1
101 46 1
102 48 1
103 50 1
104 52 1
105 54 1
106 56 1
107 58 1
108 60 1
109 63 1
110 65 1
111 67 1
112 69 1
113 71 1
114 73 1
115 75 1
116 77 1
117 79 1
118 81 1
119 connection node_2;
120 SELECT * FROM t1;
121 f1 f2
122 1 1
123 3 1
124 5 1
125 7 1
126 9 1
127 11 1
128 13 1
129 15 1
130 17 1
131 19 1
132 22 1
133 24 1
134 26 1
135 28 1
136 30 1
137 32 1
138 34 1
139 36 1
140 38 1
141 40 1
142 42 1
143 44 1
144 46 1
145 48 1
146 50 1
147 52 1
148 54 1
149 56 1
150 58 1
151 60 1
152 63 1
153 65 1
154 67 1
155 69 1
156 71 1
157 73 1
158 75 1
159 77 1
160 79 1
161 81 1
162 connection node_1;
163 DROP TABLE t1;
164 DROP SEQUENCE s;
165 connection node_1;
166 CREATE SEQUENCE s INCREMENT=0 CACHE=5 ENGINE=InnoDB;
167 CREATE TABLE t1 (f1 INT PRIMARY KEY DEFAULT NEXTVAL(s), f2 INT) ENGINE=InnoDB;
168 connection node_1;
169 BEGIN;
170 INSERT INTO t1(f2) values (1);
171 INSERT INTO t1(f2) values (1);
172 INSERT INTO t1(f2) values (1);
173 INSERT INTO t1(f2) values (1);
174 INSERT INTO t1(f2) values (1);
175 INSERT INTO t1(f2) values (1);
176 INSERT INTO t1(f2) values (1);
177 INSERT INTO t1(f2) values (1);
178 INSERT INTO t1(f2) values (1);
179 INSERT INTO t1(f2) values (1);
180 ROLLBACK;
181 connection node_2;
182 BEGIN;
183 INSERT INTO t1(f2) values (1);
184 INSERT INTO t1(f2) values (1);
185 INSERT INTO t1(f2) values (1);
186 INSERT INTO t1(f2) values (1);
187 INSERT INTO t1(f2) values (1);
188 INSERT INTO t1(f2) values (1);
189 INSERT INTO t1(f2) values (1);
190 INSERT INTO t1(f2) values (1);
191 INSERT INTO t1(f2) values (1);
192 INSERT INTO t1(f2) values (1);
193 ROLLBACK;
194 connection node_2a;
195 BEGIN;
196 INSERT INTO t1(f2) values (1);
197 INSERT INTO t1(f2) values (1);
198 INSERT INTO t1(f2) values (1);
199 INSERT INTO t1(f2) values (1);
200 INSERT INTO t1(f2) values (1);
201 INSERT INTO t1(f2) values (1);
202 INSERT INTO t1(f2) values (1);
203 INSERT INTO t1(f2) values (1);
204 INSERT INTO t1(f2) values (1);
205 INSERT INTO t1(f2) values (1);
206 ROLLBACK;
207 connection node_1a;
208 BEGIN;
209 INSERT INTO t1(f2) values (1);
210 INSERT INTO t1(f2) values (1);
211 INSERT INTO t1(f2) values (1);
212 INSERT INTO t1(f2) values (1);
213 INSERT INTO t1(f2) values (1);
214 INSERT INTO t1(f2) values (1);
215 INSERT INTO t1(f2) values (1);
216 INSERT INTO t1(f2) values (1);
217 INSERT INTO t1(f2) values (1);
218 INSERT INTO t1(f2) values (1);
219 ROLLBACK;
220 connection node_2;
221 SELECT LASTVAL(s);
222 LASTVAL(s)
223 20
224 connection node_1;
225 SELECT LASTVAL(s);
226 LASTVAL(s)
227 19
228 connection node_2a;
229 SELECT LASTVAL(s);
230 LASTVAL(s)
231 40
232 connection node_1a;
233 SELECT LASTVAL(s);
234 LASTVAL(s)
235 39
236 connection node_1;
237 SELECT * FROM t1;
238 f1 f2
239 connection node_2;
240 SELECT * FROM t1;
241 f1 f2
242 connection node_1;
243 DROP TABLE t1;
244 DROP SEQUENCE s;
245 connection node_1;
246 CREATE SEQUENCE s INCREMENT=0 CACHE=5 ENGINE=InnoDB;
247 CREATE TABLE t1 (f1 INT PRIMARY KEY DEFAULT NEXTVAL(s), f2 INT) ENGINE=InnoDB;
248 connection node_1;
249 BEGIN;
250 INSERT INTO t1(f2) values (1);
251 INSERT INTO t1(f2) values (1);
252 INSERT INTO t1(f2) values (1);
253 INSERT INTO t1(f2) values (1);
254 INSERT INTO t1(f2) values (1);
255 INSERT INTO t1(f2) values (1);
256 INSERT INTO t1(f2) values (1);
257 INSERT INTO t1(f2) values (1);
258 INSERT INTO t1(f2) values (1);
259 INSERT INTO t1(f2) values (1);
260 connection node_1a;
261 BEGIN;
262 INSERT INTO t1(f2) values (1);
263 INSERT INTO t1(f2) values (1);
264 INSERT INTO t1(f2) values (1);
265 INSERT INTO t1(f2) values (1);
266 INSERT INTO t1(f2) values (1);
267 INSERT INTO t1(f2) values (1);
268 INSERT INTO t1(f2) values (1);
269 INSERT INTO t1(f2) values (1);
270 INSERT INTO t1(f2) values (1);
271 INSERT INTO t1(f2) values (1);
272 connection node_2a;
273 BEGIN;
274 INSERT INTO t1(f2) values (1);
275 INSERT INTO t1(f2) values (1);
276 INSERT INTO t1(f2) values (1);
277 INSERT INTO t1(f2) values (1);
278 INSERT INTO t1(f2) values (1);
279 INSERT INTO t1(f2) values (1);
280 INSERT INTO t1(f2) values (1);
281 INSERT INTO t1(f2) values (1);
282 INSERT INTO t1(f2) values (1);
283 INSERT INTO t1(f2) values (1);
284 connection node_2;
285 BEGIN;
286 INSERT INTO t1(f2) values (1);
287 INSERT INTO t1(f2) values (1);
288 INSERT INTO t1(f2) values (1);
289 INSERT INTO t1(f2) values (1);
290 INSERT INTO t1(f2) values (1);
291 INSERT INTO t1(f2) values (1);
292 INSERT INTO t1(f2) values (1);
293 INSERT INTO t1(f2) values (1);
294 INSERT INTO t1(f2) values (1);
295 INSERT INTO t1(f2) values (1);
296 connection node_1;
297 COMMIT;
298 connection node_1a;
299 ROLLBACK;
300 connection node_2;
301 COMMIT;
302 connection node_2a;
303 ROLLBACK;
304 connection node_2;
305 SELECT LASTVAL(s);
306 LASTVAL(s)
307 40
308 connection node_1;
309 SELECT LASTVAL(s);
310 LASTVAL(s)
311 19
312 connection node_2a;
313 SELECT LASTVAL(s);
314 LASTVAL(s)
315 20
316 connection node_1a;
317 SELECT LASTVAL(s);
318 LASTVAL(s)
319 39
320 connection node_1;
321 SELECT * FROM t1;
322 f1 f2
323 1 1
324 3 1
325 5 1
326 7 1
327 9 1
328 11 1
329 13 1
330 15 1
331 17 1
332 19 1
333 22 1
334 24 1
335 26 1
336 28 1
337 30 1
338 32 1
339 34 1
340 36 1
341 38 1
342 40 1
343 connection node_2;
344 SELECT * FROM t1;
345 f1 f2
346 1 1
347 3 1
348 5 1
349 7 1
350 9 1
351 11 1
352 13 1
353 15 1
354 17 1
355 19 1
356 22 1
357 24 1
358 26 1
359 28 1
360 30 1
361 32 1
362 34 1
363 36 1
364 38 1
365 40 1
366 connection node_1;
367 DROP TABLE t1;
368 DROP SEQUENCE s;