18
18
Qcache_queries_in_cache 0
19
19
drop table t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,t20,t21,t22,t23,t24,t25,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,t39,t40,t41,t42,t43,t44,t45,t46,t47,t48,t49,t50,t51,t52,t53,t54,t55,t56,t57,t58,t59,t60,t61,t62,t63,t64,t65,t66,t67,t68,t69,t70,t71,t72,t73,t74,t75,t76,t77,t78,t79,t80,t81,t82,t83,t84,t85,t86,t87,t88,t89,t90,t91,t92,t93,t94,t95,t96,t97,t98,t99,t100,t101,t102,t103,t104,t105,t106,t107,t108,t109,t110,t111,t112,t113,t114,t115,t116,t117,t118,t119,t120,t121,t122,t123,t124,t125,t126,t127,t128,t129,t130,t131,t132,t133,t134,t135,t136,t137,t138,t139,t140,t141,t142,t143,t144,t145,t146,t147,t148,t149,t150,t151,t152,t153,t154,t155,t156,t157,t158,t159,t160,t161,t162,t163,t164,t165,t166,t167,t168,t169,t170,t171,t172,t173,t174,t175,t176,t177,t178,t179,t180,t181,t182,t183,t184,t185,t186,t187,t188,t189,t190,t191,t192,t193,t194,t195,t196,t197,t198,t199,t200,t201,t202,t203,t204,t205,t206,t207,t208,t209,t210,t211,t212,t213,t214,t215,t216,t217,t218,t219,t220,t221,t222,t223,t224,t225,t226,t227,t228,t229,t230,t231,t232,t233,t234,t235,t236,t237,t238,t239,t240,t241,t242,t243,t244,t245,t246,t247,t248,t249,t250,t251,t252,t253,t254,t255,t256,t257,t00;
20
20
SET @@global.query_cache_size=0;
21
set @@global.table_definition_cache=@save_table_definition_cache;
22
SET @save_table_definition_cache = @@global.table_definition_cache;
23
SET @@global.table_definition_cache = 512;
24
CREATE TABLE t255 (a INT);
25
INSERT INTO t255 VALUES (255);
26
CREATE TABLE t254 (a INT);
27
INSERT INTO t254 VALUES (254);
28
CREATE TABLE t253 (a INT);
29
INSERT INTO t253 VALUES (253);
30
CREATE TABLE t252 (a INT);
31
INSERT INTO t252 VALUES (252);
32
CREATE TABLE t251 (a INT);
33
INSERT INTO t251 VALUES (251);
34
CREATE TABLE t250 (a INT);
35
INSERT INTO t250 VALUES (250);
36
CREATE TABLE t249 (a INT);
37
INSERT INTO t249 VALUES (249);
38
CREATE TABLE t248 (a INT);
39
INSERT INTO t248 VALUES (248);
40
CREATE TABLE t247 (a INT);
41
INSERT INTO t247 VALUES (247);
42
CREATE TABLE t246 (a INT);
43
INSERT INTO t246 VALUES (246);
44
CREATE TABLE t245 (a INT);
45
INSERT INTO t245 VALUES (245);
46
CREATE TABLE t244 (a INT);
47
INSERT INTO t244 VALUES (244);
48
CREATE TABLE t243 (a INT);
49
INSERT INTO t243 VALUES (243);
50
CREATE TABLE t242 (a INT);
51
INSERT INTO t242 VALUES (242);
52
CREATE TABLE t241 (a INT);
53
INSERT INTO t241 VALUES (241);
54
CREATE TABLE t240 (a INT);
55
INSERT INTO t240 VALUES (240);
56
CREATE TABLE t239 (a INT);
57
INSERT INTO t239 VALUES (239);
58
CREATE TABLE t238 (a INT);
59
INSERT INTO t238 VALUES (238);
60
CREATE TABLE t237 (a INT);
61
INSERT INTO t237 VALUES (237);
62
CREATE TABLE t236 (a INT);
63
INSERT INTO t236 VALUES (236);
64
CREATE TABLE t235 (a INT);
65
INSERT INTO t235 VALUES (235);
66
CREATE TABLE t234 (a INT);
67
INSERT INTO t234 VALUES (234);
68
CREATE TABLE t233 (a INT);
69
INSERT INTO t233 VALUES (233);
70
CREATE TABLE t232 (a INT);
71
INSERT INTO t232 VALUES (232);
72
CREATE TABLE t231 (a INT);
73
INSERT INTO t231 VALUES (231);
74
CREATE TABLE t230 (a INT);
75
INSERT INTO t230 VALUES (230);
76
CREATE TABLE t229 (a INT);
77
INSERT INTO t229 VALUES (229);
78
CREATE TABLE t228 (a INT);
79
INSERT INTO t228 VALUES (228);
80
CREATE TABLE t227 (a INT);
81
INSERT INTO t227 VALUES (227);
82
CREATE TABLE t226 (a INT);
83
INSERT INTO t226 VALUES (226);
84
CREATE TABLE t225 (a INT);
85
INSERT INTO t225 VALUES (225);
86
CREATE TABLE t224 (a INT);
87
INSERT INTO t224 VALUES (224);
88
CREATE TABLE t223 (a INT);
89
INSERT INTO t223 VALUES (223);
90
CREATE TABLE t222 (a INT);
91
INSERT INTO t222 VALUES (222);
92
CREATE TABLE t221 (a INT);
93
INSERT INTO t221 VALUES (221);
94
CREATE TABLE t220 (a INT);
95
INSERT INTO t220 VALUES (220);
96
CREATE TABLE t219 (a INT);
97
INSERT INTO t219 VALUES (219);
98
CREATE TABLE t218 (a INT);
99
INSERT INTO t218 VALUES (218);
100
CREATE TABLE t217 (a INT);
101
INSERT INTO t217 VALUES (217);
102
CREATE TABLE t216 (a INT);
103
INSERT INTO t216 VALUES (216);
104
CREATE TABLE t215 (a INT);
105
INSERT INTO t215 VALUES (215);
106
CREATE TABLE t214 (a INT);
107
INSERT INTO t214 VALUES (214);
108
CREATE TABLE t213 (a INT);
109
INSERT INTO t213 VALUES (213);
110
CREATE TABLE t212 (a INT);
111
INSERT INTO t212 VALUES (212);
112
CREATE TABLE t211 (a INT);
113
INSERT INTO t211 VALUES (211);
114
CREATE TABLE t210 (a INT);
115
INSERT INTO t210 VALUES (210);
116
CREATE TABLE t209 (a INT);
117
INSERT INTO t209 VALUES (209);
118
CREATE TABLE t208 (a INT);
119
INSERT INTO t208 VALUES (208);
120
CREATE TABLE t207 (a INT);
121
INSERT INTO t207 VALUES (207);
122
CREATE TABLE t206 (a INT);
123
INSERT INTO t206 VALUES (206);
124
CREATE TABLE t205 (a INT);
125
INSERT INTO t205 VALUES (205);
126
CREATE TABLE t204 (a INT);
127
INSERT INTO t204 VALUES (204);
128
CREATE TABLE t203 (a INT);
129
INSERT INTO t203 VALUES (203);
130
CREATE TABLE t202 (a INT);
131
INSERT INTO t202 VALUES (202);
132
CREATE TABLE t201 (a INT);
133
INSERT INTO t201 VALUES (201);
134
CREATE TABLE t200 (a INT);
135
INSERT INTO t200 VALUES (200);
136
CREATE TABLE t199 (a INT);
137
INSERT INTO t199 VALUES (199);
138
CREATE TABLE t198 (a INT);
139
INSERT INTO t198 VALUES (198);
140
CREATE TABLE t197 (a INT);
141
INSERT INTO t197 VALUES (197);
142
CREATE TABLE t196 (a INT);
143
INSERT INTO t196 VALUES (196);
144
CREATE TABLE t195 (a INT);
145
INSERT INTO t195 VALUES (195);
146
CREATE TABLE t194 (a INT);
147
INSERT INTO t194 VALUES (194);
148
CREATE TABLE t193 (a INT);
149
INSERT INTO t193 VALUES (193);
150
CREATE TABLE t192 (a INT);
151
INSERT INTO t192 VALUES (192);
152
CREATE TABLE t191 (a INT);
153
INSERT INTO t191 VALUES (191);
154
CREATE TABLE t190 (a INT);
155
INSERT INTO t190 VALUES (190);
156
CREATE TABLE t189 (a INT);
157
INSERT INTO t189 VALUES (189);
158
CREATE TABLE t188 (a INT);
159
INSERT INTO t188 VALUES (188);
160
CREATE TABLE t187 (a INT);
161
INSERT INTO t187 VALUES (187);
162
CREATE TABLE t186 (a INT);
163
INSERT INTO t186 VALUES (186);
164
CREATE TABLE t185 (a INT);
165
INSERT INTO t185 VALUES (185);
166
CREATE TABLE t184 (a INT);
167
INSERT INTO t184 VALUES (184);
168
CREATE TABLE t183 (a INT);
169
INSERT INTO t183 VALUES (183);
170
CREATE TABLE t182 (a INT);
171
INSERT INTO t182 VALUES (182);
172
CREATE TABLE t181 (a INT);
173
INSERT INTO t181 VALUES (181);
174
CREATE TABLE t180 (a INT);
175
INSERT INTO t180 VALUES (180);
176
CREATE TABLE t179 (a INT);
177
INSERT INTO t179 VALUES (179);
178
CREATE TABLE t178 (a INT);
179
INSERT INTO t178 VALUES (178);
180
CREATE TABLE t177 (a INT);
181
INSERT INTO t177 VALUES (177);
182
CREATE TABLE t176 (a INT);
183
INSERT INTO t176 VALUES (176);
184
CREATE TABLE t175 (a INT);
185
INSERT INTO t175 VALUES (175);
186
CREATE TABLE t174 (a INT);
187
INSERT INTO t174 VALUES (174);
188
CREATE TABLE t173 (a INT);
189
INSERT INTO t173 VALUES (173);
190
CREATE TABLE t172 (a INT);
191
INSERT INTO t172 VALUES (172);
192
CREATE TABLE t171 (a INT);
193
INSERT INTO t171 VALUES (171);
194
CREATE TABLE t170 (a INT);
195
INSERT INTO t170 VALUES (170);
196
CREATE TABLE t169 (a INT);
197
INSERT INTO t169 VALUES (169);
198
CREATE TABLE t168 (a INT);
199
INSERT INTO t168 VALUES (168);
200
CREATE TABLE t167 (a INT);
201
INSERT INTO t167 VALUES (167);
202
CREATE TABLE t166 (a INT);
203
INSERT INTO t166 VALUES (166);
204
CREATE TABLE t165 (a INT);
205
INSERT INTO t165 VALUES (165);
206
CREATE TABLE t164 (a INT);
207
INSERT INTO t164 VALUES (164);
208
CREATE TABLE t163 (a INT);
209
INSERT INTO t163 VALUES (163);
210
CREATE TABLE t162 (a INT);
211
INSERT INTO t162 VALUES (162);
212
CREATE TABLE t161 (a INT);
213
INSERT INTO t161 VALUES (161);
214
CREATE TABLE t160 (a INT);
215
INSERT INTO t160 VALUES (160);
216
CREATE TABLE t159 (a INT);
217
INSERT INTO t159 VALUES (159);
218
CREATE TABLE t158 (a INT);
219
INSERT INTO t158 VALUES (158);
220
CREATE TABLE t157 (a INT);
221
INSERT INTO t157 VALUES (157);
222
CREATE TABLE t156 (a INT);
223
INSERT INTO t156 VALUES (156);
224
CREATE TABLE t155 (a INT);
225
INSERT INTO t155 VALUES (155);
226
CREATE TABLE t154 (a INT);
227
INSERT INTO t154 VALUES (154);
228
CREATE TABLE t153 (a INT);
229
INSERT INTO t153 VALUES (153);
230
CREATE TABLE t152 (a INT);
231
INSERT INTO t152 VALUES (152);
232
CREATE TABLE t151 (a INT);
233
INSERT INTO t151 VALUES (151);
234
CREATE TABLE t150 (a INT);
235
INSERT INTO t150 VALUES (150);
236
CREATE TABLE t149 (a INT);
237
INSERT INTO t149 VALUES (149);
238
CREATE TABLE t148 (a INT);
239
INSERT INTO t148 VALUES (148);
240
CREATE TABLE t147 (a INT);
241
INSERT INTO t147 VALUES (147);
242
CREATE TABLE t146 (a INT);
243
INSERT INTO t146 VALUES (146);
244
CREATE TABLE t145 (a INT);
245
INSERT INTO t145 VALUES (145);
246
CREATE TABLE t144 (a INT);
247
INSERT INTO t144 VALUES (144);
248
CREATE TABLE t143 (a INT);
249
INSERT INTO t143 VALUES (143);
250
CREATE TABLE t142 (a INT);
251
INSERT INTO t142 VALUES (142);
252
CREATE TABLE t141 (a INT);
253
INSERT INTO t141 VALUES (141);
254
CREATE TABLE t140 (a INT);
255
INSERT INTO t140 VALUES (140);
256
CREATE TABLE t139 (a INT);
257
INSERT INTO t139 VALUES (139);
258
CREATE TABLE t138 (a INT);
259
INSERT INTO t138 VALUES (138);
260
CREATE TABLE t137 (a INT);
261
INSERT INTO t137 VALUES (137);
262
CREATE TABLE t136 (a INT);
263
INSERT INTO t136 VALUES (136);
264
CREATE TABLE t135 (a INT);
265
INSERT INTO t135 VALUES (135);
266
CREATE TABLE t134 (a INT);
267
INSERT INTO t134 VALUES (134);
268
CREATE TABLE t133 (a INT);
269
INSERT INTO t133 VALUES (133);
270
CREATE TABLE t132 (a INT);
271
INSERT INTO t132 VALUES (132);
272
CREATE TABLE t131 (a INT);
273
INSERT INTO t131 VALUES (131);
274
CREATE TABLE t130 (a INT);
275
INSERT INTO t130 VALUES (130);
276
CREATE TABLE t129 (a INT);
277
INSERT INTO t129 VALUES (129);
278
CREATE TABLE t128 (a INT);
279
INSERT INTO t128 VALUES (128);
280
CREATE TABLE t127 (a INT);
281
INSERT INTO t127 VALUES (127);
282
CREATE TABLE t126 (a INT);
283
INSERT INTO t126 VALUES (126);
284
CREATE TABLE t125 (a INT);
285
INSERT INTO t125 VALUES (125);
286
CREATE TABLE t124 (a INT);
287
INSERT INTO t124 VALUES (124);
288
CREATE TABLE t123 (a INT);
289
INSERT INTO t123 VALUES (123);
290
CREATE TABLE t122 (a INT);
291
INSERT INTO t122 VALUES (122);
292
CREATE TABLE t121 (a INT);
293
INSERT INTO t121 VALUES (121);
294
CREATE TABLE t120 (a INT);
295
INSERT INTO t120 VALUES (120);
296
CREATE TABLE t119 (a INT);
297
INSERT INTO t119 VALUES (119);
298
CREATE TABLE t118 (a INT);
299
INSERT INTO t118 VALUES (118);
300
CREATE TABLE t117 (a INT);
301
INSERT INTO t117 VALUES (117);
302
CREATE TABLE t116 (a INT);
303
INSERT INTO t116 VALUES (116);
304
CREATE TABLE t115 (a INT);
305
INSERT INTO t115 VALUES (115);
306
CREATE TABLE t114 (a INT);
307
INSERT INTO t114 VALUES (114);
308
CREATE TABLE t113 (a INT);
309
INSERT INTO t113 VALUES (113);
310
CREATE TABLE t112 (a INT);
311
INSERT INTO t112 VALUES (112);
312
CREATE TABLE t111 (a INT);
313
INSERT INTO t111 VALUES (111);
314
CREATE TABLE t110 (a INT);
315
INSERT INTO t110 VALUES (110);
316
CREATE TABLE t109 (a INT);
317
INSERT INTO t109 VALUES (109);
318
CREATE TABLE t108 (a INT);
319
INSERT INTO t108 VALUES (108);
320
CREATE TABLE t107 (a INT);
321
INSERT INTO t107 VALUES (107);
322
CREATE TABLE t106 (a INT);
323
INSERT INTO t106 VALUES (106);
324
CREATE TABLE t105 (a INT);
325
INSERT INTO t105 VALUES (105);
326
CREATE TABLE t104 (a INT);
327
INSERT INTO t104 VALUES (104);
328
CREATE TABLE t103 (a INT);
329
INSERT INTO t103 VALUES (103);
330
CREATE TABLE t102 (a INT);
331
INSERT INTO t102 VALUES (102);
332
CREATE TABLE t101 (a INT);
333
INSERT INTO t101 VALUES (101);
334
CREATE TABLE t100 (a INT);
335
INSERT INTO t100 VALUES (100);
336
CREATE TABLE t99 (a INT);
337
INSERT INTO t99 VALUES (99);
338
CREATE TABLE t98 (a INT);
339
INSERT INTO t98 VALUES (98);
340
CREATE TABLE t97 (a INT);
341
INSERT INTO t97 VALUES (97);
342
CREATE TABLE t96 (a INT);
343
INSERT INTO t96 VALUES (96);
344
CREATE TABLE t95 (a INT);
345
INSERT INTO t95 VALUES (95);
346
CREATE TABLE t94 (a INT);
347
INSERT INTO t94 VALUES (94);
348
CREATE TABLE t93 (a INT);
349
INSERT INTO t93 VALUES (93);
350
CREATE TABLE t92 (a INT);
351
INSERT INTO t92 VALUES (92);
352
CREATE TABLE t91 (a INT);
353
INSERT INTO t91 VALUES (91);
354
CREATE TABLE t90 (a INT);
355
INSERT INTO t90 VALUES (90);
356
CREATE TABLE t89 (a INT);
357
INSERT INTO t89 VALUES (89);
358
CREATE TABLE t88 (a INT);
359
INSERT INTO t88 VALUES (88);
360
CREATE TABLE t87 (a INT);
361
INSERT INTO t87 VALUES (87);
362
CREATE TABLE t86 (a INT);
363
INSERT INTO t86 VALUES (86);
364
CREATE TABLE t85 (a INT);
365
INSERT INTO t85 VALUES (85);
366
CREATE TABLE t84 (a INT);
367
INSERT INTO t84 VALUES (84);
368
CREATE TABLE t83 (a INT);
369
INSERT INTO t83 VALUES (83);
370
CREATE TABLE t82 (a INT);
371
INSERT INTO t82 VALUES (82);
372
CREATE TABLE t81 (a INT);
373
INSERT INTO t81 VALUES (81);
374
CREATE TABLE t80 (a INT);
375
INSERT INTO t80 VALUES (80);
376
CREATE TABLE t79 (a INT);
377
INSERT INTO t79 VALUES (79);
378
CREATE TABLE t78 (a INT);
379
INSERT INTO t78 VALUES (78);
380
CREATE TABLE t77 (a INT);
381
INSERT INTO t77 VALUES (77);
382
CREATE TABLE t76 (a INT);
383
INSERT INTO t76 VALUES (76);
384
CREATE TABLE t75 (a INT);
385
INSERT INTO t75 VALUES (75);
386
CREATE TABLE t74 (a INT);
387
INSERT INTO t74 VALUES (74);
388
CREATE TABLE t73 (a INT);
389
INSERT INTO t73 VALUES (73);
390
CREATE TABLE t72 (a INT);
391
INSERT INTO t72 VALUES (72);
392
CREATE TABLE t71 (a INT);
393
INSERT INTO t71 VALUES (71);
394
CREATE TABLE t70 (a INT);
395
INSERT INTO t70 VALUES (70);
396
CREATE TABLE t69 (a INT);
397
INSERT INTO t69 VALUES (69);
398
CREATE TABLE t68 (a INT);
399
INSERT INTO t68 VALUES (68);
400
CREATE TABLE t67 (a INT);
401
INSERT INTO t67 VALUES (67);
402
CREATE TABLE t66 (a INT);
403
INSERT INTO t66 VALUES (66);
404
CREATE TABLE t65 (a INT);
405
INSERT INTO t65 VALUES (65);
406
CREATE TABLE t64 (a INT);
407
INSERT INTO t64 VALUES (64);
408
CREATE TABLE t63 (a INT);
409
INSERT INTO t63 VALUES (63);
410
CREATE TABLE t62 (a INT);
411
INSERT INTO t62 VALUES (62);
412
CREATE TABLE t61 (a INT);
413
INSERT INTO t61 VALUES (61);
414
CREATE TABLE t60 (a INT);
415
INSERT INTO t60 VALUES (60);
416
CREATE TABLE t59 (a INT);
417
INSERT INTO t59 VALUES (59);
418
CREATE TABLE t58 (a INT);
419
INSERT INTO t58 VALUES (58);
420
CREATE TABLE t57 (a INT);
421
INSERT INTO t57 VALUES (57);
422
CREATE TABLE t56 (a INT);
423
INSERT INTO t56 VALUES (56);
424
CREATE TABLE t55 (a INT);
425
INSERT INTO t55 VALUES (55);
426
CREATE TABLE t54 (a INT);
427
INSERT INTO t54 VALUES (54);
428
CREATE TABLE t53 (a INT);
429
INSERT INTO t53 VALUES (53);
430
CREATE TABLE t52 (a INT);
431
INSERT INTO t52 VALUES (52);
432
CREATE TABLE t51 (a INT);
433
INSERT INTO t51 VALUES (51);
434
CREATE TABLE t50 (a INT);
435
INSERT INTO t50 VALUES (50);
436
CREATE TABLE t49 (a INT);
437
INSERT INTO t49 VALUES (49);
438
CREATE TABLE t48 (a INT);
439
INSERT INTO t48 VALUES (48);
440
CREATE TABLE t47 (a INT);
441
INSERT INTO t47 VALUES (47);
442
CREATE TABLE t46 (a INT);
443
INSERT INTO t46 VALUES (46);
444
CREATE TABLE t45 (a INT);
445
INSERT INTO t45 VALUES (45);
446
CREATE TABLE t44 (a INT);
447
INSERT INTO t44 VALUES (44);
448
CREATE TABLE t43 (a INT);
449
INSERT INTO t43 VALUES (43);
450
CREATE TABLE t42 (a INT);
451
INSERT INTO t42 VALUES (42);
452
CREATE TABLE t41 (a INT);
453
INSERT INTO t41 VALUES (41);
454
CREATE TABLE t40 (a INT);
455
INSERT INTO t40 VALUES (40);
456
CREATE TABLE t39 (a INT);
457
INSERT INTO t39 VALUES (39);
458
CREATE TABLE t38 (a INT);
459
INSERT INTO t38 VALUES (38);
460
CREATE TABLE t37 (a INT);
461
INSERT INTO t37 VALUES (37);
462
CREATE TABLE t36 (a INT);
463
INSERT INTO t36 VALUES (36);
464
CREATE TABLE t35 (a INT);
465
INSERT INTO t35 VALUES (35);
466
CREATE TABLE t34 (a INT);
467
INSERT INTO t34 VALUES (34);
468
CREATE TABLE t33 (a INT);
469
INSERT INTO t33 VALUES (33);
470
CREATE TABLE t32 (a INT);
471
INSERT INTO t32 VALUES (32);
472
CREATE TABLE t31 (a INT);
473
INSERT INTO t31 VALUES (31);
474
CREATE TABLE t30 (a INT);
475
INSERT INTO t30 VALUES (30);
476
CREATE TABLE t29 (a INT);
477
INSERT INTO t29 VALUES (29);
478
CREATE TABLE t28 (a INT);
479
INSERT INTO t28 VALUES (28);
480
CREATE TABLE t27 (a INT);
481
INSERT INTO t27 VALUES (27);
482
CREATE TABLE t26 (a INT);
483
INSERT INTO t26 VALUES (26);
484
CREATE TABLE t25 (a INT);
485
INSERT INTO t25 VALUES (25);
486
CREATE TABLE t24 (a INT);
487
INSERT INTO t24 VALUES (24);
488
CREATE TABLE t23 (a INT);
489
INSERT INTO t23 VALUES (23);
490
CREATE TABLE t22 (a INT);
491
INSERT INTO t22 VALUES (22);
492
CREATE TABLE t21 (a INT);
493
INSERT INTO t21 VALUES (21);
494
CREATE TABLE t20 (a INT);
495
INSERT INTO t20 VALUES (20);
496
CREATE TABLE t19 (a INT);
497
INSERT INTO t19 VALUES (19);
498
CREATE TABLE t18 (a INT);
499
INSERT INTO t18 VALUES (18);
500
CREATE TABLE t17 (a INT);
501
INSERT INTO t17 VALUES (17);
502
CREATE TABLE t16 (a INT);
503
INSERT INTO t16 VALUES (16);
504
CREATE TABLE t15 (a INT);
505
INSERT INTO t15 VALUES (15);
506
CREATE TABLE t14 (a INT);
507
INSERT INTO t14 VALUES (14);
508
CREATE TABLE t13 (a INT);
509
INSERT INTO t13 VALUES (13);
510
CREATE TABLE t12 (a INT);
511
INSERT INTO t12 VALUES (12);
512
CREATE TABLE t11 (a INT);
513
INSERT INTO t11 VALUES (11);
514
CREATE TABLE t10 (a INT);
515
INSERT INTO t10 VALUES (10);
516
CREATE TABLE t9 (a INT);
517
INSERT INTO t9 VALUES (9);
518
CREATE TABLE t8 (a INT);
519
INSERT INTO t8 VALUES (8);
520
CREATE TABLE t7 (a INT);
521
INSERT INTO t7 VALUES (7);
522
CREATE TABLE t6 (a INT);
523
INSERT INTO t6 VALUES (6);
524
CREATE TABLE t5 (a INT);
525
INSERT INTO t5 VALUES (5);
526
CREATE TABLE t4 (a INT);
527
INSERT INTO t4 VALUES (4);
528
CREATE TABLE t3 (a INT);
529
INSERT INTO t3 VALUES (3);
530
CREATE TABLE t2 (a INT);
531
INSERT INTO t2 VALUES (2);
532
CREATE TABLE t1 (a INT);
533
INSERT INTO t1 VALUES (1);
534
CREATE TABLE t0 (a INT) ENGINE=MERGE UNION(t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,t20,t21,t22,t23,t24,t25,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,t39,t40,t41,t42,t43,t44,t45,t46,t47,t48,t49,t50,t51,t52,t53,t54,t55,t56,t57,t58,t59,t60,t61,t62,t63,t64,t65,t66,t67,t68,t69,t70,t71,t72,t73,t74,t75,t76,t77,t78,t79,t80,t81,t82,t83,t84,t85,t86,t87,t88,t89,t90,t91,t92,t93,t94,t95,t96,t97,t98,t99,t100,t101,t102,t103,t104,t105,t106,t107,t108,t109,t110,t111,t112,t113,t114,t115,t116,t117,t118,t119,t120,t121,t122,t123,t124,t125,t126,t127,t128,t129,t130,t131,t132,t133,t134,t135,t136,t137,t138,t139,t140,t141,t142,t143,t144,t145,t146,t147,t148,t149,t150,t151,t152,t153,t154,t155,t156,t157,t158,t159,t160,t161,t162,t163,t164,t165,t166,t167,t168,t169,t170,t171,t172,t173,t174,t175,t176,t177,t178,t179,t180,t181,t182,t183,t184,t185,t186,t187,t188,t189,t190,t191,t192,t193,t194,t195,t196,t197,t198,t199,t200,t201,t202,t203,t204,t205,t206,t207,t208,t209,t210,t211,t212,t213,t214,t215,t216,t217,t218,t219,t220,t221,t222,t223,t224,t225,t226,t227,t228,t229,t230,t231,t232,t233,t234,t235,t236,t237,t238,t239,t240,t241,t242,t243,t244,t245,t246,t247,t248,t249,t250,t251,t252,t253,t254,t255);
535
SET GLOBAL query_cache_size = 1048576;
537
SELECT a FROM t0 WHERE a = 1;
540
SHOW STATUS LIKE "Qcache_queries_in_cache";
542
Qcache_queries_in_cache 1
1003
TRUNCATE TABLE t140;
1007
TRUNCATE TABLE t139;
1011
TRUNCATE TABLE t138;
1015
TRUNCATE TABLE t137;
1019
TRUNCATE TABLE t136;
1023
TRUNCATE TABLE t135;
1027
TRUNCATE TABLE t134;
1031
TRUNCATE TABLE t133;
1035
TRUNCATE TABLE t132;
1039
TRUNCATE TABLE t131;
1043
TRUNCATE TABLE t130;
1047
TRUNCATE TABLE t129;
1051
TRUNCATE TABLE t128;
1054
TRUNCATE TABLE t127;
1057
TRUNCATE TABLE t126;
1060
TRUNCATE TABLE t125;
1063
TRUNCATE TABLE t124;
1066
TRUNCATE TABLE t123;
1069
TRUNCATE TABLE t122;
1072
TRUNCATE TABLE t121;
1075
TRUNCATE TABLE t120;
1078
TRUNCATE TABLE t119;
1081
TRUNCATE TABLE t118;
1084
TRUNCATE TABLE t117;
1087
TRUNCATE TABLE t116;
1090
TRUNCATE TABLE t115;
1093
TRUNCATE TABLE t114;
1096
TRUNCATE TABLE t113;
1099
TRUNCATE TABLE t112;
1102
TRUNCATE TABLE t111;
1105
TRUNCATE TABLE t110;
1108
TRUNCATE TABLE t109;
1111
TRUNCATE TABLE t108;
1114
TRUNCATE TABLE t107;
1117
TRUNCATE TABLE t106;
1120
TRUNCATE TABLE t105;
1123
TRUNCATE TABLE t104;
1126
TRUNCATE TABLE t103;
1129
TRUNCATE TABLE t102;
1132
TRUNCATE TABLE t101;
1135
TRUNCATE TABLE t100;
1693
SET @@global.query_cache_size = 0;
1694
SET @@global.table_definition_cache = @save_table_definition_cache;