Debian Codegraph @

mysql-test/suite/innodb/r/lock_empty_bitmap.result

raw
1 CREATE TABLE t0 (
2 id INT NOT NULL PRIMARY KEY,
3 a INT NOT NULL,
4 b INT NOT NULL
5 );
6 INSERT INTO t0 VALUES (2,0,0);
7 INSERT INTO t0 VALUES (3,0,0);
8 INSERT INTO t0 VALUES (4,0,0);
9 INSERT INTO t0 VALUES (5,0,0);
10 INSERT INTO t0 VALUES (6,0,0);
11 INSERT INTO t0 VALUES (7,0,0);
12 INSERT INTO t0 VALUES (8,0,0);
13 INSERT INTO t0 VALUES (9,0,0);
14 INSERT INTO t0 VALUES (10,0,0);
15 INSERT INTO t0 VALUES (11,0,0);
16 INSERT INTO t0 VALUES (12,0,0);
17 INSERT INTO t0 VALUES (13,0,0);
18 INSERT INTO t0 VALUES (14,0,0);
19 INSERT INTO t0 VALUES (15,0,0);
20 INSERT INTO t0 VALUES (16,0,0);
21 INSERT INTO t0 VALUES (17,0,0);
22 INSERT INTO t0 VALUES (18,0,0);
23 INSERT INTO t0 VALUES (19,0,0);
24 INSERT INTO t0 VALUES (20,0,0);
25 INSERT INTO t0 VALUES (21,0,0);
26 INSERT INTO t0 VALUES (22,0,0);
27 INSERT INTO t0 VALUES (23,0,0);
28 INSERT INTO t0 VALUES (24,0,0);
29 INSERT INTO t0 VALUES (25,0,0);
30 INSERT INTO t0 VALUES (26,0,0);
31 INSERT INTO t0 VALUES (27,0,0);
32 INSERT INTO t0 VALUES (28,0,0);
33 INSERT INTO t0 VALUES (29,0,0);
34 INSERT INTO t0 VALUES (30,0,0);
35 INSERT INTO t0 VALUES (31,0,0);
36 INSERT INTO t0 VALUES (32,0,0);
37 INSERT INTO t0 VALUES (33,0,0);
38 INSERT INTO t0 VALUES (34,0,0);
39 INSERT INTO t0 VALUES (35,0,0);
40 INSERT INTO t0 VALUES (36,0,0);
41 INSERT INTO t0 VALUES (37,0,0);
42 INSERT INTO t0 VALUES (38,0,0);
43 INSERT INTO t0 VALUES (39,0,0);
44 INSERT INTO t0 VALUES (40,0,0);
45 INSERT INTO t0 VALUES (41,0,0);
46 INSERT INTO t0 VALUES (42,0,0);
47 INSERT INTO t0 VALUES (43,0,0);
48 INSERT INTO t0 VALUES (44,0,0);
49 INSERT INTO t0 VALUES (45,0,0);
50 INSERT INTO t0 VALUES (46,0,0);
51 INSERT INTO t0 VALUES (47,0,0);
52 INSERT INTO t0 VALUES (48,0,0);
53 INSERT INTO t0 VALUES (49,0,0);
54 INSERT INTO t0 VALUES (50,0,0);
55 INSERT INTO t0 VALUES (51,0,0);
56 INSERT INTO t0 VALUES (52,0,0);
57 INSERT INTO t0 VALUES (53,0,0);
58 INSERT INTO t0 VALUES (54,0,0);
59 INSERT INTO t0 VALUES (55,0,0);
60 CREATE TABLE t1 (
61 id INT NOT NULL PRIMARY KEY,
62 a INT NOT NULL,
63 b INT NOT NULL
64 );
65 INSERT INTO t1 VALUES (2,0,0);
66 INSERT INTO t1 VALUES (3,0,0);
67 INSERT INTO t1 VALUES (4,0,0);
68 INSERT INTO t1 VALUES (5,0,0);
69 INSERT INTO t1 VALUES (6,0,0);
70 INSERT INTO t1 VALUES (7,0,0);
71 INSERT INTO t1 VALUES (8,0,0);
72 INSERT INTO t1 VALUES (9,0,0);
73 INSERT INTO t1 VALUES (10,0,0);
74 INSERT INTO t1 VALUES (11,0,0);
75 INSERT INTO t1 VALUES (12,0,0);
76 INSERT INTO t1 VALUES (13,0,0);
77 INSERT INTO t1 VALUES (14,0,0);
78 INSERT INTO t1 VALUES (15,0,0);
79 INSERT INTO t1 VALUES (16,0,0);
80 INSERT INTO t1 VALUES (17,0,0);
81 INSERT INTO t1 VALUES (18,0,0);
82 INSERT INTO t1 VALUES (19,0,0);
83 INSERT INTO t1 VALUES (20,0,0);
84 INSERT INTO t1 VALUES (21,0,0);
85 INSERT INTO t1 VALUES (22,0,0);
86 INSERT INTO t1 VALUES (23,0,0);
87 INSERT INTO t1 VALUES (24,0,0);
88 INSERT INTO t1 VALUES (25,0,0);
89 INSERT INTO t1 VALUES (26,0,0);
90 INSERT INTO t1 VALUES (27,0,0);
91 INSERT INTO t1 VALUES (28,0,0);
92 INSERT INTO t1 VALUES (29,0,0);
93 INSERT INTO t1 VALUES (30,0,0);
94 INSERT INTO t1 VALUES (31,0,0);
95 INSERT INTO t1 VALUES (32,0,0);
96 INSERT INTO t1 VALUES (33,0,0);
97 INSERT INTO t1 VALUES (34,0,0);
98 INSERT INTO t1 VALUES (35,0,0);
99 INSERT INTO t1 VALUES (36,0,0);
100 INSERT INTO t1 VALUES (37,0,0);
101 INSERT INTO t1 VALUES (38,0,0);
102 INSERT INTO t1 VALUES (39,0,0);
103 INSERT INTO t1 VALUES (40,0,0);
104 INSERT INTO t1 VALUES (41,0,0);
105 INSERT INTO t1 VALUES (42,0,0);
106 INSERT INTO t1 VALUES (43,0,0);
107 INSERT INTO t1 VALUES (44,0,0);
108 INSERT INTO t1 VALUES (45,0,0);
109 INSERT INTO t1 VALUES (46,0,0);
110 INSERT INTO t1 VALUES (47,0,0);
111 INSERT INTO t1 VALUES (48,0,0);
112 INSERT INTO t1 VALUES (49,0,0);
113 INSERT INTO t1 VALUES (50,0,0);
114 INSERT INTO t1 VALUES (51,0,0);
115 INSERT INTO t1 VALUES (52,0,0);
116 INSERT INTO t1 VALUES (53,0,0);
117 INSERT INTO t1 VALUES (54,0,0);
118 INSERT INTO t1 VALUES (55,0,0);
119 CREATE TABLE t2 (
120 id INT NOT NULL PRIMARY KEY,
121 a INT NOT NULL,
122 b INT NOT NULL
123 );
124 INSERT INTO t2 VALUES (2,0,0);
125 INSERT INTO t2 VALUES (3,0,0);
126 INSERT INTO t2 VALUES (4,0,0);
127 INSERT INTO t2 VALUES (5,0,0);
128 INSERT INTO t2 VALUES (6,0,0);
129 INSERT INTO t2 VALUES (7,0,0);
130 INSERT INTO t2 VALUES (8,0,0);
131 INSERT INTO t2 VALUES (9,0,0);
132 INSERT INTO t2 VALUES (10,0,0);
133 INSERT INTO t2 VALUES (11,0,0);
134 INSERT INTO t2 VALUES (12,0,0);
135 INSERT INTO t2 VALUES (13,0,0);
136 INSERT INTO t2 VALUES (14,0,0);
137 INSERT INTO t2 VALUES (15,0,0);
138 INSERT INTO t2 VALUES (16,0,0);
139 INSERT INTO t2 VALUES (17,0,0);
140 INSERT INTO t2 VALUES (18,0,0);
141 INSERT INTO t2 VALUES (19,0,0);
142 INSERT INTO t2 VALUES (20,0,0);
143 INSERT INTO t2 VALUES (21,0,0);
144 INSERT INTO t2 VALUES (22,0,0);
145 INSERT INTO t2 VALUES (23,0,0);
146 INSERT INTO t2 VALUES (24,0,0);
147 INSERT INTO t2 VALUES (25,0,0);
148 INSERT INTO t2 VALUES (26,0,0);
149 INSERT INTO t2 VALUES (27,0,0);
150 INSERT INTO t2 VALUES (28,0,0);
151 INSERT INTO t2 VALUES (29,0,0);
152 INSERT INTO t2 VALUES (30,0,0);
153 INSERT INTO t2 VALUES (31,0,0);
154 INSERT INTO t2 VALUES (32,0,0);
155 INSERT INTO t2 VALUES (33,0,0);
156 INSERT INTO t2 VALUES (34,0,0);
157 INSERT INTO t2 VALUES (35,0,0);
158 INSERT INTO t2 VALUES (36,0,0);
159 INSERT INTO t2 VALUES (37,0,0);
160 INSERT INTO t2 VALUES (38,0,0);
161 INSERT INTO t2 VALUES (39,0,0);
162 INSERT INTO t2 VALUES (40,0,0);
163 INSERT INTO t2 VALUES (41,0,0);
164 INSERT INTO t2 VALUES (42,0,0);
165 INSERT INTO t2 VALUES (43,0,0);
166 INSERT INTO t2 VALUES (44,0,0);
167 INSERT INTO t2 VALUES (45,0,0);
168 INSERT INTO t2 VALUES (46,0,0);
169 INSERT INTO t2 VALUES (47,0,0);
170 INSERT INTO t2 VALUES (48,0,0);
171 INSERT INTO t2 VALUES (49,0,0);
172 INSERT INTO t2 VALUES (50,0,0);
173 INSERT INTO t2 VALUES (51,0,0);
174 INSERT INTO t2 VALUES (52,0,0);
175 INSERT INTO t2 VALUES (53,0,0);
176 INSERT INTO t2 VALUES (54,0,0);
177 INSERT INTO t2 VALUES (55,0,0);
178 CREATE TABLE t3 (
179 id INT NOT NULL PRIMARY KEY,
180 a INT NOT NULL,
181 b INT NOT NULL
182 );
183 INSERT INTO t3 VALUES (2,0,0);
184 INSERT INTO t3 VALUES (3,0,0);
185 INSERT INTO t3 VALUES (4,0,0);
186 INSERT INTO t3 VALUES (5,0,0);
187 INSERT INTO t3 VALUES (6,0,0);
188 INSERT INTO t3 VALUES (7,0,0);
189 INSERT INTO t3 VALUES (8,0,0);
190 INSERT INTO t3 VALUES (9,0,0);
191 INSERT INTO t3 VALUES (10,0,0);
192 INSERT INTO t3 VALUES (11,0,0);
193 INSERT INTO t3 VALUES (12,0,0);
194 INSERT INTO t3 VALUES (13,0,0);
195 INSERT INTO t3 VALUES (14,0,0);
196 INSERT INTO t3 VALUES (15,0,0);
197 INSERT INTO t3 VALUES (16,0,0);
198 INSERT INTO t3 VALUES (17,0,0);
199 INSERT INTO t3 VALUES (18,0,0);
200 INSERT INTO t3 VALUES (19,0,0);
201 INSERT INTO t3 VALUES (20,0,0);
202 INSERT INTO t3 VALUES (21,0,0);
203 INSERT INTO t3 VALUES (22,0,0);
204 INSERT INTO t3 VALUES (23,0,0);
205 INSERT INTO t3 VALUES (24,0,0);
206 INSERT INTO t3 VALUES (25,0,0);
207 INSERT INTO t3 VALUES (26,0,0);
208 INSERT INTO t3 VALUES (27,0,0);
209 INSERT INTO t3 VALUES (28,0,0);
210 INSERT INTO t3 VALUES (29,0,0);
211 INSERT INTO t3 VALUES (30,0,0);
212 INSERT INTO t3 VALUES (31,0,0);
213 INSERT INTO t3 VALUES (32,0,0);
214 INSERT INTO t3 VALUES (33,0,0);
215 INSERT INTO t3 VALUES (34,0,0);
216 INSERT INTO t3 VALUES (35,0,0);
217 INSERT INTO t3 VALUES (36,0,0);
218 INSERT INTO t3 VALUES (37,0,0);
219 INSERT INTO t3 VALUES (38,0,0);
220 INSERT INTO t3 VALUES (39,0,0);
221 INSERT INTO t3 VALUES (40,0,0);
222 INSERT INTO t3 VALUES (41,0,0);
223 INSERT INTO t3 VALUES (42,0,0);
224 INSERT INTO t3 VALUES (43,0,0);
225 INSERT INTO t3 VALUES (44,0,0);
226 INSERT INTO t3 VALUES (45,0,0);
227 INSERT INTO t3 VALUES (46,0,0);
228 INSERT INTO t3 VALUES (47,0,0);
229 INSERT INTO t3 VALUES (48,0,0);
230 INSERT INTO t3 VALUES (49,0,0);
231 INSERT INTO t3 VALUES (50,0,0);
232 INSERT INTO t3 VALUES (51,0,0);
233 INSERT INTO t3 VALUES (52,0,0);
234 INSERT INTO t3 VALUES (53,0,0);
235 INSERT INTO t3 VALUES (54,0,0);
236 INSERT INTO t3 VALUES (55,0,0);
237 CREATE TABLE t4 (
238 id INT NOT NULL PRIMARY KEY,
239 a INT NOT NULL,
240 b INT NOT NULL
241 );
242 INSERT INTO t4 VALUES (2,0,0);
243 INSERT INTO t4 VALUES (3,0,0);
244 INSERT INTO t4 VALUES (4,0,0);
245 INSERT INTO t4 VALUES (5,0,0);
246 INSERT INTO t4 VALUES (6,0,0);
247 INSERT INTO t4 VALUES (7,0,0);
248 INSERT INTO t4 VALUES (8,0,0);
249 INSERT INTO t4 VALUES (9,0,0);
250 INSERT INTO t4 VALUES (10,0,0);
251 INSERT INTO t4 VALUES (11,0,0);
252 INSERT INTO t4 VALUES (12,0,0);
253 INSERT INTO t4 VALUES (13,0,0);
254 INSERT INTO t4 VALUES (14,0,0);
255 INSERT INTO t4 VALUES (15,0,0);
256 INSERT INTO t4 VALUES (16,0,0);
257 INSERT INTO t4 VALUES (17,0,0);
258 INSERT INTO t4 VALUES (18,0,0);
259 INSERT INTO t4 VALUES (19,0,0);
260 INSERT INTO t4 VALUES (20,0,0);
261 INSERT INTO t4 VALUES (21,0,0);
262 INSERT INTO t4 VALUES (22,0,0);
263 INSERT INTO t4 VALUES (23,0,0);
264 INSERT INTO t4 VALUES (24,0,0);
265 INSERT INTO t4 VALUES (25,0,0);
266 INSERT INTO t4 VALUES (26,0,0);
267 INSERT INTO t4 VALUES (27,0,0);
268 INSERT INTO t4 VALUES (28,0,0);
269 INSERT INTO t4 VALUES (29,0,0);
270 INSERT INTO t4 VALUES (30,0,0);
271 INSERT INTO t4 VALUES (31,0,0);
272 INSERT INTO t4 VALUES (32,0,0);
273 INSERT INTO t4 VALUES (33,0,0);
274 INSERT INTO t4 VALUES (34,0,0);
275 INSERT INTO t4 VALUES (35,0,0);
276 INSERT INTO t4 VALUES (36,0,0);
277 INSERT INTO t4 VALUES (37,0,0);
278 INSERT INTO t4 VALUES (38,0,0);
279 INSERT INTO t4 VALUES (39,0,0);
280 INSERT INTO t4 VALUES (40,0,0);
281 INSERT INTO t4 VALUES (41,0,0);
282 INSERT INTO t4 VALUES (42,0,0);
283 INSERT INTO t4 VALUES (43,0,0);
284 INSERT INTO t4 VALUES (44,0,0);
285 INSERT INTO t4 VALUES (45,0,0);
286 INSERT INTO t4 VALUES (46,0,0);
287 INSERT INTO t4 VALUES (47,0,0);
288 INSERT INTO t4 VALUES (48,0,0);
289 INSERT INTO t4 VALUES (49,0,0);
290 INSERT INTO t4 VALUES (50,0,0);
291 INSERT INTO t4 VALUES (51,0,0);
292 INSERT INTO t4 VALUES (52,0,0);
293 INSERT INTO t4 VALUES (53,0,0);
294 INSERT INTO t4 VALUES (54,0,0);
295 INSERT INTO t4 VALUES (55,0,0);
296 CREATE TABLE t5 (
297 id INT NOT NULL PRIMARY KEY,
298 a INT NOT NULL,
299 b INT NOT NULL
300 );
301 INSERT INTO t5 VALUES (2,0,0);
302 INSERT INTO t5 VALUES (3,0,0);
303 INSERT INTO t5 VALUES (4,0,0);
304 INSERT INTO t5 VALUES (5,0,0);
305 INSERT INTO t5 VALUES (6,0,0);
306 INSERT INTO t5 VALUES (7,0,0);
307 INSERT INTO t5 VALUES (8,0,0);
308 INSERT INTO t5 VALUES (9,0,0);
309 INSERT INTO t5 VALUES (10,0,0);
310 INSERT INTO t5 VALUES (11,0,0);
311 INSERT INTO t5 VALUES (12,0,0);
312 INSERT INTO t5 VALUES (13,0,0);
313 INSERT INTO t5 VALUES (14,0,0);
314 INSERT INTO t5 VALUES (15,0,0);
315 INSERT INTO t5 VALUES (16,0,0);
316 INSERT INTO t5 VALUES (17,0,0);
317 INSERT INTO t5 VALUES (18,0,0);
318 INSERT INTO t5 VALUES (19,0,0);
319 INSERT INTO t5 VALUES (20,0,0);
320 INSERT INTO t5 VALUES (21,0,0);
321 INSERT INTO t5 VALUES (22,0,0);
322 INSERT INTO t5 VALUES (23,0,0);
323 INSERT INTO t5 VALUES (24,0,0);
324 INSERT INTO t5 VALUES (25,0,0);
325 INSERT INTO t5 VALUES (26,0,0);
326 INSERT INTO t5 VALUES (27,0,0);
327 INSERT INTO t5 VALUES (28,0,0);
328 INSERT INTO t5 VALUES (29,0,0);
329 INSERT INTO t5 VALUES (30,0,0);
330 INSERT INTO t5 VALUES (31,0,0);
331 INSERT INTO t5 VALUES (32,0,0);
332 INSERT INTO t5 VALUES (33,0,0);
333 INSERT INTO t5 VALUES (34,0,0);
334 INSERT INTO t5 VALUES (35,0,0);
335 INSERT INTO t5 VALUES (36,0,0);
336 INSERT INTO t5 VALUES (37,0,0);
337 INSERT INTO t5 VALUES (38,0,0);
338 INSERT INTO t5 VALUES (39,0,0);
339 INSERT INTO t5 VALUES (40,0,0);
340 INSERT INTO t5 VALUES (41,0,0);
341 INSERT INTO t5 VALUES (42,0,0);
342 INSERT INTO t5 VALUES (43,0,0);
343 INSERT INTO t5 VALUES (44,0,0);
344 INSERT INTO t5 VALUES (45,0,0);
345 INSERT INTO t5 VALUES (46,0,0);
346 INSERT INTO t5 VALUES (47,0,0);
347 INSERT INTO t5 VALUES (48,0,0);
348 INSERT INTO t5 VALUES (49,0,0);
349 INSERT INTO t5 VALUES (50,0,0);
350 INSERT INTO t5 VALUES (51,0,0);
351 INSERT INTO t5 VALUES (52,0,0);
352 INSERT INTO t5 VALUES (53,0,0);
353 INSERT INTO t5 VALUES (54,0,0);
354 INSERT INTO t5 VALUES (55,0,0);
355 CREATE TABLE t6 (
356 id INT NOT NULL PRIMARY KEY,
357 a INT NOT NULL,
358 b INT NOT NULL
359 );
360 INSERT INTO t6 VALUES (2,0,0);
361 INSERT INTO t6 VALUES (3,0,0);
362 INSERT INTO t6 VALUES (4,0,0);
363 INSERT INTO t6 VALUES (5,0,0);
364 INSERT INTO t6 VALUES (6,0,0);
365 INSERT INTO t6 VALUES (7,0,0);
366 INSERT INTO t6 VALUES (8,0,0);
367 INSERT INTO t6 VALUES (9,0,0);
368 INSERT INTO t6 VALUES (10,0,0);
369 INSERT INTO t6 VALUES (11,0,0);
370 INSERT INTO t6 VALUES (12,0,0);
371 INSERT INTO t6 VALUES (13,0,0);
372 INSERT INTO t6 VALUES (14,0,0);
373 INSERT INTO t6 VALUES (15,0,0);
374 INSERT INTO t6 VALUES (16,0,0);
375 INSERT INTO t6 VALUES (17,0,0);
376 INSERT INTO t6 VALUES (18,0,0);
377 INSERT INTO t6 VALUES (19,0,0);
378 INSERT INTO t6 VALUES (20,0,0);
379 INSERT INTO t6 VALUES (21,0,0);
380 INSERT INTO t6 VALUES (22,0,0);
381 INSERT INTO t6 VALUES (23,0,0);
382 INSERT INTO t6 VALUES (24,0,0);
383 INSERT INTO t6 VALUES (25,0,0);
384 INSERT INTO t6 VALUES (26,0,0);
385 INSERT INTO t6 VALUES (27,0,0);
386 INSERT INTO t6 VALUES (28,0,0);
387 INSERT INTO t6 VALUES (29,0,0);
388 INSERT INTO t6 VALUES (30,0,0);
389 INSERT INTO t6 VALUES (31,0,0);
390 INSERT INTO t6 VALUES (32,0,0);
391 INSERT INTO t6 VALUES (33,0,0);
392 INSERT INTO t6 VALUES (34,0,0);
393 INSERT INTO t6 VALUES (35,0,0);
394 INSERT INTO t6 VALUES (36,0,0);
395 INSERT INTO t6 VALUES (37,0,0);
396 INSERT INTO t6 VALUES (38,0,0);
397 INSERT INTO t6 VALUES (39,0,0);
398 INSERT INTO t6 VALUES (40,0,0);
399 INSERT INTO t6 VALUES (41,0,0);
400 INSERT INTO t6 VALUES (42,0,0);
401 INSERT INTO t6 VALUES (43,0,0);
402 INSERT INTO t6 VALUES (44,0,0);
403 INSERT INTO t6 VALUES (45,0,0);
404 INSERT INTO t6 VALUES (46,0,0);
405 INSERT INTO t6 VALUES (47,0,0);
406 INSERT INTO t6 VALUES (48,0,0);
407 INSERT INTO t6 VALUES (49,0,0);
408 INSERT INTO t6 VALUES (50,0,0);
409 INSERT INTO t6 VALUES (51,0,0);
410 INSERT INTO t6 VALUES (52,0,0);
411 INSERT INTO t6 VALUES (53,0,0);
412 INSERT INTO t6 VALUES (54,0,0);
413 INSERT INTO t6 VALUES (55,0,0);
414 CREATE TABLE t7 (
415 id INT NOT NULL PRIMARY KEY,
416 a INT NOT NULL,
417 b INT NOT NULL
418 );
419 INSERT INTO t7 VALUES (2,0,0);
420 INSERT INTO t7 VALUES (3,0,0);
421 INSERT INTO t7 VALUES (4,0,0);
422 INSERT INTO t7 VALUES (5,0,0);
423 INSERT INTO t7 VALUES (6,0,0);
424 INSERT INTO t7 VALUES (7,0,0);
425 INSERT INTO t7 VALUES (8,0,0);
426 INSERT INTO t7 VALUES (9,0,0);
427 INSERT INTO t7 VALUES (10,0,0);
428 INSERT INTO t7 VALUES (11,0,0);
429 INSERT INTO t7 VALUES (12,0,0);
430 INSERT INTO t7 VALUES (13,0,0);
431 INSERT INTO t7 VALUES (14,0,0);
432 INSERT INTO t7 VALUES (15,0,0);
433 INSERT INTO t7 VALUES (16,0,0);
434 INSERT INTO t7 VALUES (17,0,0);
435 INSERT INTO t7 VALUES (18,0,0);
436 INSERT INTO t7 VALUES (19,0,0);
437 INSERT INTO t7 VALUES (20,0,0);
438 INSERT INTO t7 VALUES (21,0,0);
439 INSERT INTO t7 VALUES (22,0,0);
440 INSERT INTO t7 VALUES (23,0,0);
441 INSERT INTO t7 VALUES (24,0,0);
442 INSERT INTO t7 VALUES (25,0,0);
443 INSERT INTO t7 VALUES (26,0,0);
444 INSERT INTO t7 VALUES (27,0,0);
445 INSERT INTO t7 VALUES (28,0,0);
446 INSERT INTO t7 VALUES (29,0,0);
447 INSERT INTO t7 VALUES (30,0,0);
448 INSERT INTO t7 VALUES (31,0,0);
449 INSERT INTO t7 VALUES (32,0,0);
450 INSERT INTO t7 VALUES (33,0,0);
451 INSERT INTO t7 VALUES (34,0,0);
452 INSERT INTO t7 VALUES (35,0,0);
453 INSERT INTO t7 VALUES (36,0,0);
454 INSERT INTO t7 VALUES (37,0,0);
455 INSERT INTO t7 VALUES (38,0,0);
456 INSERT INTO t7 VALUES (39,0,0);
457 INSERT INTO t7 VALUES (40,0,0);
458 INSERT INTO t7 VALUES (41,0,0);
459 INSERT INTO t7 VALUES (42,0,0);
460 INSERT INTO t7 VALUES (43,0,0);
461 INSERT INTO t7 VALUES (44,0,0);
462 INSERT INTO t7 VALUES (45,0,0);
463 INSERT INTO t7 VALUES (46,0,0);
464 INSERT INTO t7 VALUES (47,0,0);
465 INSERT INTO t7 VALUES (48,0,0);
466 INSERT INTO t7 VALUES (49,0,0);
467 INSERT INTO t7 VALUES (50,0,0);
468 INSERT INTO t7 VALUES (51,0,0);
469 INSERT INTO t7 VALUES (52,0,0);
470 INSERT INTO t7 VALUES (53,0,0);
471 INSERT INTO t7 VALUES (54,0,0);
472 INSERT INTO t7 VALUES (55,0,0);
473 CREATE TABLE t8 (
474 id INT NOT NULL PRIMARY KEY,
475 a INT NOT NULL,
476 b INT NOT NULL
477 );
478 INSERT INTO t8 VALUES (2,0,0);
479 INSERT INTO t8 VALUES (3,0,0);
480 INSERT INTO t8 VALUES (4,0,0);
481 INSERT INTO t8 VALUES (5,0,0);
482 INSERT INTO t8 VALUES (6,0,0);
483 INSERT INTO t8 VALUES (7,0,0);
484 INSERT INTO t8 VALUES (8,0,0);
485 INSERT INTO t8 VALUES (9,0,0);
486 INSERT INTO t8 VALUES (10,0,0);
487 INSERT INTO t8 VALUES (11,0,0);
488 INSERT INTO t8 VALUES (12,0,0);
489 INSERT INTO t8 VALUES (13,0,0);
490 INSERT INTO t8 VALUES (14,0,0);
491 INSERT INTO t8 VALUES (15,0,0);
492 INSERT INTO t8 VALUES (16,0,0);
493 INSERT INTO t8 VALUES (17,0,0);
494 INSERT INTO t8 VALUES (18,0,0);
495 INSERT INTO t8 VALUES (19,0,0);
496 INSERT INTO t8 VALUES (20,0,0);
497 INSERT INTO t8 VALUES (21,0,0);
498 INSERT INTO t8 VALUES (22,0,0);
499 INSERT INTO t8 VALUES (23,0,0);
500 INSERT INTO t8 VALUES (24,0,0);
501 INSERT INTO t8 VALUES (25,0,0);
502 INSERT INTO t8 VALUES (26,0,0);
503 INSERT INTO t8 VALUES (27,0,0);
504 INSERT INTO t8 VALUES (28,0,0);
505 INSERT INTO t8 VALUES (29,0,0);
506 INSERT INTO t8 VALUES (30,0,0);
507 INSERT INTO t8 VALUES (31,0,0);
508 INSERT INTO t8 VALUES (32,0,0);
509 INSERT INTO t8 VALUES (33,0,0);
510 INSERT INTO t8 VALUES (34,0,0);
511 INSERT INTO t8 VALUES (35,0,0);
512 INSERT INTO t8 VALUES (36,0,0);
513 INSERT INTO t8 VALUES (37,0,0);
514 INSERT INTO t8 VALUES (38,0,0);
515 INSERT INTO t8 VALUES (39,0,0);
516 INSERT INTO t8 VALUES (40,0,0);
517 INSERT INTO t8 VALUES (41,0,0);
518 INSERT INTO t8 VALUES (42,0,0);
519 INSERT INTO t8 VALUES (43,0,0);
520 INSERT INTO t8 VALUES (44,0,0);
521 INSERT INTO t8 VALUES (45,0,0);
522 INSERT INTO t8 VALUES (46,0,0);
523 INSERT INTO t8 VALUES (47,0,0);
524 INSERT INTO t8 VALUES (48,0,0);
525 INSERT INTO t8 VALUES (49,0,0);
526 INSERT INTO t8 VALUES (50,0,0);
527 INSERT INTO t8 VALUES (51,0,0);
528 INSERT INTO t8 VALUES (52,0,0);
529 INSERT INTO t8 VALUES (53,0,0);
530 INSERT INTO t8 VALUES (54,0,0);
531 INSERT INTO t8 VALUES (55,0,0);
532 CREATE TABLE t9 (
533 id INT NOT NULL PRIMARY KEY,
534 a INT NOT NULL,
535 b INT NOT NULL
536 );
537 INSERT INTO t9 VALUES (2,0,0);
538 INSERT INTO t9 VALUES (3,0,0);
539 INSERT INTO t9 VALUES (4,0,0);
540 INSERT INTO t9 VALUES (5,0,0);
541 INSERT INTO t9 VALUES (6,0,0);
542 INSERT INTO t9 VALUES (7,0,0);
543 INSERT INTO t9 VALUES (8,0,0);
544 INSERT INTO t9 VALUES (9,0,0);
545 INSERT INTO t9 VALUES (10,0,0);
546 INSERT INTO t9 VALUES (11,0,0);
547 INSERT INTO t9 VALUES (12,0,0);
548 INSERT INTO t9 VALUES (13,0,0);
549 INSERT INTO t9 VALUES (14,0,0);
550 INSERT INTO t9 VALUES (15,0,0);
551 INSERT INTO t9 VALUES (16,0,0);
552 INSERT INTO t9 VALUES (17,0,0);
553 INSERT INTO t9 VALUES (18,0,0);
554 INSERT INTO t9 VALUES (19,0,0);
555 INSERT INTO t9 VALUES (20,0,0);
556 INSERT INTO t9 VALUES (21,0,0);
557 INSERT INTO t9 VALUES (22,0,0);
558 INSERT INTO t9 VALUES (23,0,0);
559 INSERT INTO t9 VALUES (24,0,0);
560 INSERT INTO t9 VALUES (25,0,0);
561 INSERT INTO t9 VALUES (26,0,0);
562 INSERT INTO t9 VALUES (27,0,0);
563 INSERT INTO t9 VALUES (28,0,0);
564 INSERT INTO t9 VALUES (29,0,0);
565 INSERT INTO t9 VALUES (30,0,0);
566 INSERT INTO t9 VALUES (31,0,0);
567 INSERT INTO t9 VALUES (32,0,0);
568 INSERT INTO t9 VALUES (33,0,0);
569 INSERT INTO t9 VALUES (34,0,0);
570 INSERT INTO t9 VALUES (35,0,0);
571 INSERT INTO t9 VALUES (36,0,0);
572 INSERT INTO t9 VALUES (37,0,0);
573 INSERT INTO t9 VALUES (38,0,0);
574 INSERT INTO t9 VALUES (39,0,0);
575 INSERT INTO t9 VALUES (40,0,0);
576 INSERT INTO t9 VALUES (41,0,0);
577 INSERT INTO t9 VALUES (42,0,0);
578 INSERT INTO t9 VALUES (43,0,0);
579 INSERT INTO t9 VALUES (44,0,0);
580 INSERT INTO t9 VALUES (45,0,0);
581 INSERT INTO t9 VALUES (46,0,0);
582 INSERT INTO t9 VALUES (47,0,0);
583 INSERT INTO t9 VALUES (48,0,0);
584 INSERT INTO t9 VALUES (49,0,0);
585 INSERT INTO t9 VALUES (50,0,0);
586 INSERT INTO t9 VALUES (51,0,0);
587 INSERT INTO t9 VALUES (52,0,0);
588 INSERT INTO t9 VALUES (53,0,0);
589 INSERT INTO t9 VALUES (54,0,0);
590 INSERT INTO t9 VALUES (55,0,0);
591 CREATE TABLE t10 (
592 id INT NOT NULL PRIMARY KEY,
593 a INT NOT NULL,
594 b INT NOT NULL
595 );
596 INSERT INTO t10 VALUES (2,0,0);
597 INSERT INTO t10 VALUES (3,0,0);
598 INSERT INTO t10 VALUES (4,0,0);
599 INSERT INTO t10 VALUES (5,0,0);
600 INSERT INTO t10 VALUES (6,0,0);
601 INSERT INTO t10 VALUES (7,0,0);
602 INSERT INTO t10 VALUES (8,0,0);
603 INSERT INTO t10 VALUES (9,0,0);
604 INSERT INTO t10 VALUES (10,0,0);
605 INSERT INTO t10 VALUES (11,0,0);
606 INSERT INTO t10 VALUES (12,0,0);
607 INSERT INTO t10 VALUES (13,0,0);
608 INSERT INTO t10 VALUES (14,0,0);
609 INSERT INTO t10 VALUES (15,0,0);
610 INSERT INTO t10 VALUES (16,0,0);
611 INSERT INTO t10 VALUES (17,0,0);
612 INSERT INTO t10 VALUES (18,0,0);
613 INSERT INTO t10 VALUES (19,0,0);
614 INSERT INTO t10 VALUES (20,0,0);
615 INSERT INTO t10 VALUES (21,0,0);
616 INSERT INTO t10 VALUES (22,0,0);
617 INSERT INTO t10 VALUES (23,0,0);
618 INSERT INTO t10 VALUES (24,0,0);
619 INSERT INTO t10 VALUES (25,0,0);
620 INSERT INTO t10 VALUES (26,0,0);
621 INSERT INTO t10 VALUES (27,0,0);
622 INSERT INTO t10 VALUES (28,0,0);
623 INSERT INTO t10 VALUES (29,0,0);
624 INSERT INTO t10 VALUES (30,0,0);
625 INSERT INTO t10 VALUES (31,0,0);
626 INSERT INTO t10 VALUES (32,0,0);
627 INSERT INTO t10 VALUES (33,0,0);
628 INSERT INTO t10 VALUES (34,0,0);
629 INSERT INTO t10 VALUES (35,0,0);
630 INSERT INTO t10 VALUES (36,0,0);
631 INSERT INTO t10 VALUES (37,0,0);
632 INSERT INTO t10 VALUES (38,0,0);
633 INSERT INTO t10 VALUES (39,0,0);
634 INSERT INTO t10 VALUES (40,0,0);
635 INSERT INTO t10 VALUES (41,0,0);
636 INSERT INTO t10 VALUES (42,0,0);
637 INSERT INTO t10 VALUES (43,0,0);
638 INSERT INTO t10 VALUES (44,0,0);
639 INSERT INTO t10 VALUES (45,0,0);
640 INSERT INTO t10 VALUES (46,0,0);
641 INSERT INTO t10 VALUES (47,0,0);
642 INSERT INTO t10 VALUES (48,0,0);
643 INSERT INTO t10 VALUES (49,0,0);
644 INSERT INTO t10 VALUES (50,0,0);
645 INSERT INTO t10 VALUES (51,0,0);
646 INSERT INTO t10 VALUES (52,0,0);
647 INSERT INTO t10 VALUES (53,0,0);
648 INSERT INTO t10 VALUES (54,0,0);
649 INSERT INTO t10 VALUES (55,0,0);
650 CREATE TABLE t11 (
651 id INT NOT NULL PRIMARY KEY,
652 a INT NOT NULL,
653 b INT NOT NULL
654 );
655 INSERT INTO t11 VALUES (2,0,0);
656 INSERT INTO t11 VALUES (3,0,0);
657 INSERT INTO t11 VALUES (4,0,0);
658 INSERT INTO t11 VALUES (5,0,0);
659 INSERT INTO t11 VALUES (6,0,0);
660 INSERT INTO t11 VALUES (7,0,0);
661 INSERT INTO t11 VALUES (8,0,0);
662 INSERT INTO t11 VALUES (9,0,0);
663 INSERT INTO t11 VALUES (10,0,0);
664 INSERT INTO t11 VALUES (11,0,0);
665 INSERT INTO t11 VALUES (12,0,0);
666 INSERT INTO t11 VALUES (13,0,0);
667 INSERT INTO t11 VALUES (14,0,0);
668 INSERT INTO t11 VALUES (15,0,0);
669 INSERT INTO t11 VALUES (16,0,0);
670 INSERT INTO t11 VALUES (17,0,0);
671 INSERT INTO t11 VALUES (18,0,0);
672 INSERT INTO t11 VALUES (19,0,0);
673 INSERT INTO t11 VALUES (20,0,0);
674 INSERT INTO t11 VALUES (21,0,0);
675 INSERT INTO t11 VALUES (22,0,0);
676 INSERT INTO t11 VALUES (23,0,0);
677 INSERT INTO t11 VALUES (24,0,0);
678 INSERT INTO t11 VALUES (25,0,0);
679 INSERT INTO t11 VALUES (26,0,0);
680 INSERT INTO t11 VALUES (27,0,0);
681 INSERT INTO t11 VALUES (28,0,0);
682 INSERT INTO t11 VALUES (29,0,0);
683 INSERT INTO t11 VALUES (30,0,0);
684 INSERT INTO t11 VALUES (31,0,0);
685 INSERT INTO t11 VALUES (32,0,0);
686 INSERT INTO t11 VALUES (33,0,0);
687 INSERT INTO t11 VALUES (34,0,0);
688 INSERT INTO t11 VALUES (35,0,0);
689 INSERT INTO t11 VALUES (36,0,0);
690 INSERT INTO t11 VALUES (37,0,0);
691 INSERT INTO t11 VALUES (38,0,0);
692 INSERT INTO t11 VALUES (39,0,0);
693 INSERT INTO t11 VALUES (40,0,0);
694 INSERT INTO t11 VALUES (41,0,0);
695 INSERT INTO t11 VALUES (42,0,0);
696 INSERT INTO t11 VALUES (43,0,0);
697 INSERT INTO t11 VALUES (44,0,0);
698 INSERT INTO t11 VALUES (45,0,0);
699 INSERT INTO t11 VALUES (46,0,0);
700 INSERT INTO t11 VALUES (47,0,0);
701 INSERT INTO t11 VALUES (48,0,0);
702 INSERT INTO t11 VALUES (49,0,0);
703 INSERT INTO t11 VALUES (50,0,0);
704 INSERT INTO t11 VALUES (51,0,0);
705 INSERT INTO t11 VALUES (52,0,0);
706 INSERT INTO t11 VALUES (53,0,0);
707 INSERT INTO t11 VALUES (54,0,0);
708 INSERT INTO t11 VALUES (55,0,0);
709 CREATE TABLE t12 (
710 id INT NOT NULL PRIMARY KEY,
711 a INT NOT NULL,
712 b INT NOT NULL
713 );
714 INSERT INTO t12 VALUES (2,0,0);
715 INSERT INTO t12 VALUES (3,0,0);
716 INSERT INTO t12 VALUES (4,0,0);
717 INSERT INTO t12 VALUES (5,0,0);
718 INSERT INTO t12 VALUES (6,0,0);
719 INSERT INTO t12 VALUES (7,0,0);
720 INSERT INTO t12 VALUES (8,0,0);
721 INSERT INTO t12 VALUES (9,0,0);
722 INSERT INTO t12 VALUES (10,0,0);
723 INSERT INTO t12 VALUES (11,0,0);
724 INSERT INTO t12 VALUES (12,0,0);
725 INSERT INTO t12 VALUES (13,0,0);
726 INSERT INTO t12 VALUES (14,0,0);
727 INSERT INTO t12 VALUES (15,0,0);
728 INSERT INTO t12 VALUES (16,0,0);
729 INSERT INTO t12 VALUES (17,0,0);
730 INSERT INTO t12 VALUES (18,0,0);
731 INSERT INTO t12 VALUES (19,0,0);
732 INSERT INTO t12 VALUES (20,0,0);
733 INSERT INTO t12 VALUES (21,0,0);
734 INSERT INTO t12 VALUES (22,0,0);
735 INSERT INTO t12 VALUES (23,0,0);
736 INSERT INTO t12 VALUES (24,0,0);
737 INSERT INTO t12 VALUES (25,0,0);
738 INSERT INTO t12 VALUES (26,0,0);
739 INSERT INTO t12 VALUES (27,0,0);
740 INSERT INTO t12 VALUES (28,0,0);
741 INSERT INTO t12 VALUES (29,0,0);
742 INSERT INTO t12 VALUES (30,0,0);
743 INSERT INTO t12 VALUES (31,0,0);
744 INSERT INTO t12 VALUES (32,0,0);
745 INSERT INTO t12 VALUES (33,0,0);
746 INSERT INTO t12 VALUES (34,0,0);
747 INSERT INTO t12 VALUES (35,0,0);
748 INSERT INTO t12 VALUES (36,0,0);
749 INSERT INTO t12 VALUES (37,0,0);
750 INSERT INTO t12 VALUES (38,0,0);
751 INSERT INTO t12 VALUES (39,0,0);
752 INSERT INTO t12 VALUES (40,0,0);
753 INSERT INTO t12 VALUES (41,0,0);
754 INSERT INTO t12 VALUES (42,0,0);
755 INSERT INTO t12 VALUES (43,0,0);
756 INSERT INTO t12 VALUES (44,0,0);
757 INSERT INTO t12 VALUES (45,0,0);
758 INSERT INTO t12 VALUES (46,0,0);
759 INSERT INTO t12 VALUES (47,0,0);
760 INSERT INTO t12 VALUES (48,0,0);
761 INSERT INTO t12 VALUES (49,0,0);
762 INSERT INTO t12 VALUES (50,0,0);
763 INSERT INTO t12 VALUES (51,0,0);
764 INSERT INTO t12 VALUES (52,0,0);
765 INSERT INTO t12 VALUES (53,0,0);
766 INSERT INTO t12 VALUES (54,0,0);
767 INSERT INTO t12 VALUES (55,0,0);
768 CREATE TABLE t13 (
769 id INT NOT NULL PRIMARY KEY,
770 a INT NOT NULL,
771 b INT NOT NULL
772 );
773 INSERT INTO t13 VALUES (2,0,0);
774 INSERT INTO t13 VALUES (3,0,0);
775 INSERT INTO t13 VALUES (4,0,0);
776 INSERT INTO t13 VALUES (5,0,0);
777 INSERT INTO t13 VALUES (6,0,0);
778 INSERT INTO t13 VALUES (7,0,0);
779 INSERT INTO t13 VALUES (8,0,0);
780 INSERT INTO t13 VALUES (9,0,0);
781 INSERT INTO t13 VALUES (10,0,0);
782 INSERT INTO t13 VALUES (11,0,0);
783 INSERT INTO t13 VALUES (12,0,0);
784 INSERT INTO t13 VALUES (13,0,0);
785 INSERT INTO t13 VALUES (14,0,0);
786 INSERT INTO t13 VALUES (15,0,0);
787 INSERT INTO t13 VALUES (16,0,0);
788 INSERT INTO t13 VALUES (17,0,0);
789 INSERT INTO t13 VALUES (18,0,0);
790 INSERT INTO t13 VALUES (19,0,0);
791 INSERT INTO t13 VALUES (20,0,0);
792 INSERT INTO t13 VALUES (21,0,0);
793 INSERT INTO t13 VALUES (22,0,0);
794 INSERT INTO t13 VALUES (23,0,0);
795 INSERT INTO t13 VALUES (24,0,0);
796 INSERT INTO t13 VALUES (25,0,0);
797 INSERT INTO t13 VALUES (26,0,0);
798 INSERT INTO t13 VALUES (27,0,0);
799 INSERT INTO t13 VALUES (28,0,0);
800 INSERT INTO t13 VALUES (29,0,0);
801 INSERT INTO t13 VALUES (30,0,0);
802 INSERT INTO t13 VALUES (31,0,0);
803 INSERT INTO t13 VALUES (32,0,0);
804 INSERT INTO t13 VALUES (33,0,0);
805 INSERT INTO t13 VALUES (34,0,0);
806 INSERT INTO t13 VALUES (35,0,0);
807 INSERT INTO t13 VALUES (36,0,0);
808 INSERT INTO t13 VALUES (37,0,0);
809 INSERT INTO t13 VALUES (38,0,0);
810 INSERT INTO t13 VALUES (39,0,0);
811 INSERT INTO t13 VALUES (40,0,0);
812 INSERT INTO t13 VALUES (41,0,0);
813 INSERT INTO t13 VALUES (42,0,0);
814 INSERT INTO t13 VALUES (43,0,0);
815 INSERT INTO t13 VALUES (44,0,0);
816 INSERT INTO t13 VALUES (45,0,0);
817 INSERT INTO t13 VALUES (46,0,0);
818 INSERT INTO t13 VALUES (47,0,0);
819 INSERT INTO t13 VALUES (48,0,0);
820 INSERT INTO t13 VALUES (49,0,0);
821 INSERT INTO t13 VALUES (50,0,0);
822 INSERT INTO t13 VALUES (51,0,0);
823 INSERT INTO t13 VALUES (52,0,0);
824 INSERT INTO t13 VALUES (53,0,0);
825 INSERT INTO t13 VALUES (54,0,0);
826 INSERT INTO t13 VALUES (55,0,0);
827 CREATE TABLE t14 (
828 id INT NOT NULL PRIMARY KEY,
829 a INT NOT NULL,
830 b INT NOT NULL
831 );
832 INSERT INTO t14 VALUES (2,0,0);
833 INSERT INTO t14 VALUES (3,0,0);
834 INSERT INTO t14 VALUES (4,0,0);
835 INSERT INTO t14 VALUES (5,0,0);
836 INSERT INTO t14 VALUES (6,0,0);
837 INSERT INTO t14 VALUES (7,0,0);
838 INSERT INTO t14 VALUES (8,0,0);
839 INSERT INTO t14 VALUES (9,0,0);
840 INSERT INTO t14 VALUES (10,0,0);
841 INSERT INTO t14 VALUES (11,0,0);
842 INSERT INTO t14 VALUES (12,0,0);
843 INSERT INTO t14 VALUES (13,0,0);
844 INSERT INTO t14 VALUES (14,0,0);
845 INSERT INTO t14 VALUES (15,0,0);
846 INSERT INTO t14 VALUES (16,0,0);
847 INSERT INTO t14 VALUES (17,0,0);
848 INSERT INTO t14 VALUES (18,0,0);
849 INSERT INTO t14 VALUES (19,0,0);
850 INSERT INTO t14 VALUES (20,0,0);
851 INSERT INTO t14 VALUES (21,0,0);
852 INSERT INTO t14 VALUES (22,0,0);
853 INSERT INTO t14 VALUES (23,0,0);
854 INSERT INTO t14 VALUES (24,0,0);
855 INSERT INTO t14 VALUES (25,0,0);
856 INSERT INTO t14 VALUES (26,0,0);
857 INSERT INTO t14 VALUES (27,0,0);
858 INSERT INTO t14 VALUES (28,0,0);
859 INSERT INTO t14 VALUES (29,0,0);
860 INSERT INTO t14 VALUES (30,0,0);
861 INSERT INTO t14 VALUES (31,0,0);
862 INSERT INTO t14 VALUES (32,0,0);
863 INSERT INTO t14 VALUES (33,0,0);
864 INSERT INTO t14 VALUES (34,0,0);
865 INSERT INTO t14 VALUES (35,0,0);
866 INSERT INTO t14 VALUES (36,0,0);
867 INSERT INTO t14 VALUES (37,0,0);
868 INSERT INTO t14 VALUES (38,0,0);
869 INSERT INTO t14 VALUES (39,0,0);
870 INSERT INTO t14 VALUES (40,0,0);
871 INSERT INTO t14 VALUES (41,0,0);
872 INSERT INTO t14 VALUES (42,0,0);
873 INSERT INTO t14 VALUES (43,0,0);
874 INSERT INTO t14 VALUES (44,0,0);
875 INSERT INTO t14 VALUES (45,0,0);
876 INSERT INTO t14 VALUES (46,0,0);
877 INSERT INTO t14 VALUES (47,0,0);
878 INSERT INTO t14 VALUES (48,0,0);
879 INSERT INTO t14 VALUES (49,0,0);
880 INSERT INTO t14 VALUES (50,0,0);
881 INSERT INTO t14 VALUES (51,0,0);
882 INSERT INTO t14 VALUES (52,0,0);
883 INSERT INTO t14 VALUES (53,0,0);
884 INSERT INTO t14 VALUES (54,0,0);
885 INSERT INTO t14 VALUES (55,0,0);
886 CREATE TABLE t15 (
887 id INT NOT NULL PRIMARY KEY,
888 a INT NOT NULL,
889 b INT NOT NULL
890 );
891 INSERT INTO t15 VALUES (2,0,0);
892 INSERT INTO t15 VALUES (3,0,0);
893 INSERT INTO t15 VALUES (4,0,0);
894 INSERT INTO t15 VALUES (5,0,0);
895 INSERT INTO t15 VALUES (6,0,0);
896 INSERT INTO t15 VALUES (7,0,0);
897 INSERT INTO t15 VALUES (8,0,0);
898 INSERT INTO t15 VALUES (9,0,0);
899 INSERT INTO t15 VALUES (10,0,0);
900 INSERT INTO t15 VALUES (11,0,0);
901 INSERT INTO t15 VALUES (12,0,0);
902 INSERT INTO t15 VALUES (13,0,0);
903 INSERT INTO t15 VALUES (14,0,0);
904 INSERT INTO t15 VALUES (15,0,0);
905 INSERT INTO t15 VALUES (16,0,0);
906 INSERT INTO t15 VALUES (17,0,0);
907 INSERT INTO t15 VALUES (18,0,0);
908 INSERT INTO t15 VALUES (19,0,0);
909 INSERT INTO t15 VALUES (20,0,0);
910 INSERT INTO t15 VALUES (21,0,0);
911 INSERT INTO t15 VALUES (22,0,0);
912 INSERT INTO t15 VALUES (23,0,0);
913 INSERT INTO t15 VALUES (24,0,0);
914 INSERT INTO t15 VALUES (25,0,0);
915 INSERT INTO t15 VALUES (26,0,0);
916 INSERT INTO t15 VALUES (27,0,0);
917 INSERT INTO t15 VALUES (28,0,0);
918 INSERT INTO t15 VALUES (29,0,0);
919 INSERT INTO t15 VALUES (30,0,0);
920 INSERT INTO t15 VALUES (31,0,0);
921 INSERT INTO t15 VALUES (32,0,0);
922 INSERT INTO t15 VALUES (33,0,0);
923 INSERT INTO t15 VALUES (34,0,0);
924 INSERT INTO t15 VALUES (35,0,0);
925 INSERT INTO t15 VALUES (36,0,0);
926 INSERT INTO t15 VALUES (37,0,0);
927 INSERT INTO t15 VALUES (38,0,0);
928 INSERT INTO t15 VALUES (39,0,0);
929 INSERT INTO t15 VALUES (40,0,0);
930 INSERT INTO t15 VALUES (41,0,0);
931 INSERT INTO t15 VALUES (42,0,0);
932 INSERT INTO t15 VALUES (43,0,0);
933 INSERT INTO t15 VALUES (44,0,0);
934 INSERT INTO t15 VALUES (45,0,0);
935 INSERT INTO t15 VALUES (46,0,0);
936 INSERT INTO t15 VALUES (47,0,0);
937 INSERT INTO t15 VALUES (48,0,0);
938 INSERT INTO t15 VALUES (49,0,0);
939 INSERT INTO t15 VALUES (50,0,0);
940 INSERT INTO t15 VALUES (51,0,0);
941 INSERT INTO t15 VALUES (52,0,0);
942 INSERT INTO t15 VALUES (53,0,0);
943 INSERT INTO t15 VALUES (54,0,0);
944 INSERT INTO t15 VALUES (55,0,0);
945 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
946 BEGIN;
947 UPDATE t0 SET `a` = 1 WHERE `b`;
948 UPDATE t1 SET `a` = 1 WHERE `b`;
949 UPDATE t2 SET `a` = 1 WHERE `b`;
950 UPDATE t3 SET `a` = 1 WHERE `b`;
951 UPDATE t4 SET `a` = 1 WHERE `b`;
952 UPDATE t5 SET `a` = 1 WHERE `b`;
953 UPDATE t6 SET `a` = 1 WHERE `b`;
954 UPDATE t7 SET `a` = 1 WHERE `b`;
955 UPDATE t8 SET `a` = 1 WHERE `b`;
956 UPDATE t9 SET `a` = 1 WHERE `b`;
957 UPDATE t10 SET `a` = 1 WHERE `b`;
958 UPDATE t11 SET `a` = 1 WHERE `b`;
959 UPDATE t12 SET `a` = 1 WHERE `b`;
960 UPDATE t13 SET `a` = 1 WHERE `b`;
961 UPDATE t14 SET `a` = 1 WHERE `b`;
962 UPDATE t15 SET `a` = 1 WHERE `b`;
963 SELECT LOCK_DATA
964 FROM performance_schema.data_locks
965 WHERE LOCK_TYPE = 'RECORD' AND OBJECT_SCHEMA = 'test';
966 LOCK_DATA
967 COMMIT;
968 DROP TABLE t0;
969 DROP TABLE t1;
970 DROP TABLE t2;
971 DROP TABLE t3;
972 DROP TABLE t4;
973 DROP TABLE t5;
974 DROP TABLE t6;
975 DROP TABLE t7;
976 DROP TABLE t8;
977 DROP TABLE t9;
978 DROP TABLE t10;
979 DROP TABLE t11;
980 DROP TABLE t12;
981 DROP TABLE t13;
982 DROP TABLE t14;
983 DROP TABLE t15;