1SET @@global.query_cache_size=1355776;
2Warnings:
3Warning	1287	'@@query_cache_size' is deprecated and will be removed in a future release.
4flush status;
5select count(*) from t00;
6count(*)
7514
8select count(*) from t00;
9count(*)
10514
11show status like "Qcache_queries_in_cache";
12Variable_name	Value
13Qcache_queries_in_cache	1
14show status like "Qcache_hits";
15Variable_name	Value
16Qcache_hits	1
17delete from t256;
18show status like "Qcache_queries_in_cache";
19Variable_name	Value
20Qcache_queries_in_cache	0
21drop 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;
22SET @@global.query_cache_size=0;
23Warnings:
24Warning	1287	'@@query_cache_size' is deprecated and will be removed in a future release.
25set @@global.table_definition_cache=@save_table_definition_cache;
26SET @save_table_definition_cache = @@global.table_definition_cache;
27SET @@global.table_definition_cache = 512;
28CREATE TABLE t255 (a INT);
29INSERT INTO t255 VALUES (255);
30CREATE TABLE t254 (a INT);
31INSERT INTO t254 VALUES (254);
32CREATE TABLE t253 (a INT);
33INSERT INTO t253 VALUES (253);
34CREATE TABLE t252 (a INT);
35INSERT INTO t252 VALUES (252);
36CREATE TABLE t251 (a INT);
37INSERT INTO t251 VALUES (251);
38CREATE TABLE t250 (a INT);
39INSERT INTO t250 VALUES (250);
40CREATE TABLE t249 (a INT);
41INSERT INTO t249 VALUES (249);
42CREATE TABLE t248 (a INT);
43INSERT INTO t248 VALUES (248);
44CREATE TABLE t247 (a INT);
45INSERT INTO t247 VALUES (247);
46CREATE TABLE t246 (a INT);
47INSERT INTO t246 VALUES (246);
48CREATE TABLE t245 (a INT);
49INSERT INTO t245 VALUES (245);
50CREATE TABLE t244 (a INT);
51INSERT INTO t244 VALUES (244);
52CREATE TABLE t243 (a INT);
53INSERT INTO t243 VALUES (243);
54CREATE TABLE t242 (a INT);
55INSERT INTO t242 VALUES (242);
56CREATE TABLE t241 (a INT);
57INSERT INTO t241 VALUES (241);
58CREATE TABLE t240 (a INT);
59INSERT INTO t240 VALUES (240);
60CREATE TABLE t239 (a INT);
61INSERT INTO t239 VALUES (239);
62CREATE TABLE t238 (a INT);
63INSERT INTO t238 VALUES (238);
64CREATE TABLE t237 (a INT);
65INSERT INTO t237 VALUES (237);
66CREATE TABLE t236 (a INT);
67INSERT INTO t236 VALUES (236);
68CREATE TABLE t235 (a INT);
69INSERT INTO t235 VALUES (235);
70CREATE TABLE t234 (a INT);
71INSERT INTO t234 VALUES (234);
72CREATE TABLE t233 (a INT);
73INSERT INTO t233 VALUES (233);
74CREATE TABLE t232 (a INT);
75INSERT INTO t232 VALUES (232);
76CREATE TABLE t231 (a INT);
77INSERT INTO t231 VALUES (231);
78CREATE TABLE t230 (a INT);
79INSERT INTO t230 VALUES (230);
80CREATE TABLE t229 (a INT);
81INSERT INTO t229 VALUES (229);
82CREATE TABLE t228 (a INT);
83INSERT INTO t228 VALUES (228);
84CREATE TABLE t227 (a INT);
85INSERT INTO t227 VALUES (227);
86CREATE TABLE t226 (a INT);
87INSERT INTO t226 VALUES (226);
88CREATE TABLE t225 (a INT);
89INSERT INTO t225 VALUES (225);
90CREATE TABLE t224 (a INT);
91INSERT INTO t224 VALUES (224);
92CREATE TABLE t223 (a INT);
93INSERT INTO t223 VALUES (223);
94CREATE TABLE t222 (a INT);
95INSERT INTO t222 VALUES (222);
96CREATE TABLE t221 (a INT);
97INSERT INTO t221 VALUES (221);
98CREATE TABLE t220 (a INT);
99INSERT INTO t220 VALUES (220);
100CREATE TABLE t219 (a INT);
101INSERT INTO t219 VALUES (219);
102CREATE TABLE t218 (a INT);
103INSERT INTO t218 VALUES (218);
104CREATE TABLE t217 (a INT);
105INSERT INTO t217 VALUES (217);
106CREATE TABLE t216 (a INT);
107INSERT INTO t216 VALUES (216);
108CREATE TABLE t215 (a INT);
109INSERT INTO t215 VALUES (215);
110CREATE TABLE t214 (a INT);
111INSERT INTO t214 VALUES (214);
112CREATE TABLE t213 (a INT);
113INSERT INTO t213 VALUES (213);
114CREATE TABLE t212 (a INT);
115INSERT INTO t212 VALUES (212);
116CREATE TABLE t211 (a INT);
117INSERT INTO t211 VALUES (211);
118CREATE TABLE t210 (a INT);
119INSERT INTO t210 VALUES (210);
120CREATE TABLE t209 (a INT);
121INSERT INTO t209 VALUES (209);
122CREATE TABLE t208 (a INT);
123INSERT INTO t208 VALUES (208);
124CREATE TABLE t207 (a INT);
125INSERT INTO t207 VALUES (207);
126CREATE TABLE t206 (a INT);
127INSERT INTO t206 VALUES (206);
128CREATE TABLE t205 (a INT);
129INSERT INTO t205 VALUES (205);
130CREATE TABLE t204 (a INT);
131INSERT INTO t204 VALUES (204);
132CREATE TABLE t203 (a INT);
133INSERT INTO t203 VALUES (203);
134CREATE TABLE t202 (a INT);
135INSERT INTO t202 VALUES (202);
136CREATE TABLE t201 (a INT);
137INSERT INTO t201 VALUES (201);
138CREATE TABLE t200 (a INT);
139INSERT INTO t200 VALUES (200);
140CREATE TABLE t199 (a INT);
141INSERT INTO t199 VALUES (199);
142CREATE TABLE t198 (a INT);
143INSERT INTO t198 VALUES (198);
144CREATE TABLE t197 (a INT);
145INSERT INTO t197 VALUES (197);
146CREATE TABLE t196 (a INT);
147INSERT INTO t196 VALUES (196);
148CREATE TABLE t195 (a INT);
149INSERT INTO t195 VALUES (195);
150CREATE TABLE t194 (a INT);
151INSERT INTO t194 VALUES (194);
152CREATE TABLE t193 (a INT);
153INSERT INTO t193 VALUES (193);
154CREATE TABLE t192 (a INT);
155INSERT INTO t192 VALUES (192);
156CREATE TABLE t191 (a INT);
157INSERT INTO t191 VALUES (191);
158CREATE TABLE t190 (a INT);
159INSERT INTO t190 VALUES (190);
160CREATE TABLE t189 (a INT);
161INSERT INTO t189 VALUES (189);
162CREATE TABLE t188 (a INT);
163INSERT INTO t188 VALUES (188);
164CREATE TABLE t187 (a INT);
165INSERT INTO t187 VALUES (187);
166CREATE TABLE t186 (a INT);
167INSERT INTO t186 VALUES (186);
168CREATE TABLE t185 (a INT);
169INSERT INTO t185 VALUES (185);
170CREATE TABLE t184 (a INT);
171INSERT INTO t184 VALUES (184);
172CREATE TABLE t183 (a INT);
173INSERT INTO t183 VALUES (183);
174CREATE TABLE t182 (a INT);
175INSERT INTO t182 VALUES (182);
176CREATE TABLE t181 (a INT);
177INSERT INTO t181 VALUES (181);
178CREATE TABLE t180 (a INT);
179INSERT INTO t180 VALUES (180);
180CREATE TABLE t179 (a INT);
181INSERT INTO t179 VALUES (179);
182CREATE TABLE t178 (a INT);
183INSERT INTO t178 VALUES (178);
184CREATE TABLE t177 (a INT);
185INSERT INTO t177 VALUES (177);
186CREATE TABLE t176 (a INT);
187INSERT INTO t176 VALUES (176);
188CREATE TABLE t175 (a INT);
189INSERT INTO t175 VALUES (175);
190CREATE TABLE t174 (a INT);
191INSERT INTO t174 VALUES (174);
192CREATE TABLE t173 (a INT);
193INSERT INTO t173 VALUES (173);
194CREATE TABLE t172 (a INT);
195INSERT INTO t172 VALUES (172);
196CREATE TABLE t171 (a INT);
197INSERT INTO t171 VALUES (171);
198CREATE TABLE t170 (a INT);
199INSERT INTO t170 VALUES (170);
200CREATE TABLE t169 (a INT);
201INSERT INTO t169 VALUES (169);
202CREATE TABLE t168 (a INT);
203INSERT INTO t168 VALUES (168);
204CREATE TABLE t167 (a INT);
205INSERT INTO t167 VALUES (167);
206CREATE TABLE t166 (a INT);
207INSERT INTO t166 VALUES (166);
208CREATE TABLE t165 (a INT);
209INSERT INTO t165 VALUES (165);
210CREATE TABLE t164 (a INT);
211INSERT INTO t164 VALUES (164);
212CREATE TABLE t163 (a INT);
213INSERT INTO t163 VALUES (163);
214CREATE TABLE t162 (a INT);
215INSERT INTO t162 VALUES (162);
216CREATE TABLE t161 (a INT);
217INSERT INTO t161 VALUES (161);
218CREATE TABLE t160 (a INT);
219INSERT INTO t160 VALUES (160);
220CREATE TABLE t159 (a INT);
221INSERT INTO t159 VALUES (159);
222CREATE TABLE t158 (a INT);
223INSERT INTO t158 VALUES (158);
224CREATE TABLE t157 (a INT);
225INSERT INTO t157 VALUES (157);
226CREATE TABLE t156 (a INT);
227INSERT INTO t156 VALUES (156);
228CREATE TABLE t155 (a INT);
229INSERT INTO t155 VALUES (155);
230CREATE TABLE t154 (a INT);
231INSERT INTO t154 VALUES (154);
232CREATE TABLE t153 (a INT);
233INSERT INTO t153 VALUES (153);
234CREATE TABLE t152 (a INT);
235INSERT INTO t152 VALUES (152);
236CREATE TABLE t151 (a INT);
237INSERT INTO t151 VALUES (151);
238CREATE TABLE t150 (a INT);
239INSERT INTO t150 VALUES (150);
240CREATE TABLE t149 (a INT);
241INSERT INTO t149 VALUES (149);
242CREATE TABLE t148 (a INT);
243INSERT INTO t148 VALUES (148);
244CREATE TABLE t147 (a INT);
245INSERT INTO t147 VALUES (147);
246CREATE TABLE t146 (a INT);
247INSERT INTO t146 VALUES (146);
248CREATE TABLE t145 (a INT);
249INSERT INTO t145 VALUES (145);
250CREATE TABLE t144 (a INT);
251INSERT INTO t144 VALUES (144);
252CREATE TABLE t143 (a INT);
253INSERT INTO t143 VALUES (143);
254CREATE TABLE t142 (a INT);
255INSERT INTO t142 VALUES (142);
256CREATE TABLE t141 (a INT);
257INSERT INTO t141 VALUES (141);
258CREATE TABLE t140 (a INT);
259INSERT INTO t140 VALUES (140);
260CREATE TABLE t139 (a INT);
261INSERT INTO t139 VALUES (139);
262CREATE TABLE t138 (a INT);
263INSERT INTO t138 VALUES (138);
264CREATE TABLE t137 (a INT);
265INSERT INTO t137 VALUES (137);
266CREATE TABLE t136 (a INT);
267INSERT INTO t136 VALUES (136);
268CREATE TABLE t135 (a INT);
269INSERT INTO t135 VALUES (135);
270CREATE TABLE t134 (a INT);
271INSERT INTO t134 VALUES (134);
272CREATE TABLE t133 (a INT);
273INSERT INTO t133 VALUES (133);
274CREATE TABLE t132 (a INT);
275INSERT INTO t132 VALUES (132);
276CREATE TABLE t131 (a INT);
277INSERT INTO t131 VALUES (131);
278CREATE TABLE t130 (a INT);
279INSERT INTO t130 VALUES (130);
280CREATE TABLE t129 (a INT);
281INSERT INTO t129 VALUES (129);
282CREATE TABLE t128 (a INT);
283INSERT INTO t128 VALUES (128);
284CREATE TABLE t127 (a INT);
285INSERT INTO t127 VALUES (127);
286CREATE TABLE t126 (a INT);
287INSERT INTO t126 VALUES (126);
288CREATE TABLE t125 (a INT);
289INSERT INTO t125 VALUES (125);
290CREATE TABLE t124 (a INT);
291INSERT INTO t124 VALUES (124);
292CREATE TABLE t123 (a INT);
293INSERT INTO t123 VALUES (123);
294CREATE TABLE t122 (a INT);
295INSERT INTO t122 VALUES (122);
296CREATE TABLE t121 (a INT);
297INSERT INTO t121 VALUES (121);
298CREATE TABLE t120 (a INT);
299INSERT INTO t120 VALUES (120);
300CREATE TABLE t119 (a INT);
301INSERT INTO t119 VALUES (119);
302CREATE TABLE t118 (a INT);
303INSERT INTO t118 VALUES (118);
304CREATE TABLE t117 (a INT);
305INSERT INTO t117 VALUES (117);
306CREATE TABLE t116 (a INT);
307INSERT INTO t116 VALUES (116);
308CREATE TABLE t115 (a INT);
309INSERT INTO t115 VALUES (115);
310CREATE TABLE t114 (a INT);
311INSERT INTO t114 VALUES (114);
312CREATE TABLE t113 (a INT);
313INSERT INTO t113 VALUES (113);
314CREATE TABLE t112 (a INT);
315INSERT INTO t112 VALUES (112);
316CREATE TABLE t111 (a INT);
317INSERT INTO t111 VALUES (111);
318CREATE TABLE t110 (a INT);
319INSERT INTO t110 VALUES (110);
320CREATE TABLE t109 (a INT);
321INSERT INTO t109 VALUES (109);
322CREATE TABLE t108 (a INT);
323INSERT INTO t108 VALUES (108);
324CREATE TABLE t107 (a INT);
325INSERT INTO t107 VALUES (107);
326CREATE TABLE t106 (a INT);
327INSERT INTO t106 VALUES (106);
328CREATE TABLE t105 (a INT);
329INSERT INTO t105 VALUES (105);
330CREATE TABLE t104 (a INT);
331INSERT INTO t104 VALUES (104);
332CREATE TABLE t103 (a INT);
333INSERT INTO t103 VALUES (103);
334CREATE TABLE t102 (a INT);
335INSERT INTO t102 VALUES (102);
336CREATE TABLE t101 (a INT);
337INSERT INTO t101 VALUES (101);
338CREATE TABLE t100 (a INT);
339INSERT INTO t100 VALUES (100);
340CREATE TABLE t99 (a INT);
341INSERT INTO t99 VALUES (99);
342CREATE TABLE t98 (a INT);
343INSERT INTO t98 VALUES (98);
344CREATE TABLE t97 (a INT);
345INSERT INTO t97 VALUES (97);
346CREATE TABLE t96 (a INT);
347INSERT INTO t96 VALUES (96);
348CREATE TABLE t95 (a INT);
349INSERT INTO t95 VALUES (95);
350CREATE TABLE t94 (a INT);
351INSERT INTO t94 VALUES (94);
352CREATE TABLE t93 (a INT);
353INSERT INTO t93 VALUES (93);
354CREATE TABLE t92 (a INT);
355INSERT INTO t92 VALUES (92);
356CREATE TABLE t91 (a INT);
357INSERT INTO t91 VALUES (91);
358CREATE TABLE t90 (a INT);
359INSERT INTO t90 VALUES (90);
360CREATE TABLE t89 (a INT);
361INSERT INTO t89 VALUES (89);
362CREATE TABLE t88 (a INT);
363INSERT INTO t88 VALUES (88);
364CREATE TABLE t87 (a INT);
365INSERT INTO t87 VALUES (87);
366CREATE TABLE t86 (a INT);
367INSERT INTO t86 VALUES (86);
368CREATE TABLE t85 (a INT);
369INSERT INTO t85 VALUES (85);
370CREATE TABLE t84 (a INT);
371INSERT INTO t84 VALUES (84);
372CREATE TABLE t83 (a INT);
373INSERT INTO t83 VALUES (83);
374CREATE TABLE t82 (a INT);
375INSERT INTO t82 VALUES (82);
376CREATE TABLE t81 (a INT);
377INSERT INTO t81 VALUES (81);
378CREATE TABLE t80 (a INT);
379INSERT INTO t80 VALUES (80);
380CREATE TABLE t79 (a INT);
381INSERT INTO t79 VALUES (79);
382CREATE TABLE t78 (a INT);
383INSERT INTO t78 VALUES (78);
384CREATE TABLE t77 (a INT);
385INSERT INTO t77 VALUES (77);
386CREATE TABLE t76 (a INT);
387INSERT INTO t76 VALUES (76);
388CREATE TABLE t75 (a INT);
389INSERT INTO t75 VALUES (75);
390CREATE TABLE t74 (a INT);
391INSERT INTO t74 VALUES (74);
392CREATE TABLE t73 (a INT);
393INSERT INTO t73 VALUES (73);
394CREATE TABLE t72 (a INT);
395INSERT INTO t72 VALUES (72);
396CREATE TABLE t71 (a INT);
397INSERT INTO t71 VALUES (71);
398CREATE TABLE t70 (a INT);
399INSERT INTO t70 VALUES (70);
400CREATE TABLE t69 (a INT);
401INSERT INTO t69 VALUES (69);
402CREATE TABLE t68 (a INT);
403INSERT INTO t68 VALUES (68);
404CREATE TABLE t67 (a INT);
405INSERT INTO t67 VALUES (67);
406CREATE TABLE t66 (a INT);
407INSERT INTO t66 VALUES (66);
408CREATE TABLE t65 (a INT);
409INSERT INTO t65 VALUES (65);
410CREATE TABLE t64 (a INT);
411INSERT INTO t64 VALUES (64);
412CREATE TABLE t63 (a INT);
413INSERT INTO t63 VALUES (63);
414CREATE TABLE t62 (a INT);
415INSERT INTO t62 VALUES (62);
416CREATE TABLE t61 (a INT);
417INSERT INTO t61 VALUES (61);
418CREATE TABLE t60 (a INT);
419INSERT INTO t60 VALUES (60);
420CREATE TABLE t59 (a INT);
421INSERT INTO t59 VALUES (59);
422CREATE TABLE t58 (a INT);
423INSERT INTO t58 VALUES (58);
424CREATE TABLE t57 (a INT);
425INSERT INTO t57 VALUES (57);
426CREATE TABLE t56 (a INT);
427INSERT INTO t56 VALUES (56);
428CREATE TABLE t55 (a INT);
429INSERT INTO t55 VALUES (55);
430CREATE TABLE t54 (a INT);
431INSERT INTO t54 VALUES (54);
432CREATE TABLE t53 (a INT);
433INSERT INTO t53 VALUES (53);
434CREATE TABLE t52 (a INT);
435INSERT INTO t52 VALUES (52);
436CREATE TABLE t51 (a INT);
437INSERT INTO t51 VALUES (51);
438CREATE TABLE t50 (a INT);
439INSERT INTO t50 VALUES (50);
440CREATE TABLE t49 (a INT);
441INSERT INTO t49 VALUES (49);
442CREATE TABLE t48 (a INT);
443INSERT INTO t48 VALUES (48);
444CREATE TABLE t47 (a INT);
445INSERT INTO t47 VALUES (47);
446CREATE TABLE t46 (a INT);
447INSERT INTO t46 VALUES (46);
448CREATE TABLE t45 (a INT);
449INSERT INTO t45 VALUES (45);
450CREATE TABLE t44 (a INT);
451INSERT INTO t44 VALUES (44);
452CREATE TABLE t43 (a INT);
453INSERT INTO t43 VALUES (43);
454CREATE TABLE t42 (a INT);
455INSERT INTO t42 VALUES (42);
456CREATE TABLE t41 (a INT);
457INSERT INTO t41 VALUES (41);
458CREATE TABLE t40 (a INT);
459INSERT INTO t40 VALUES (40);
460CREATE TABLE t39 (a INT);
461INSERT INTO t39 VALUES (39);
462CREATE TABLE t38 (a INT);
463INSERT INTO t38 VALUES (38);
464CREATE TABLE t37 (a INT);
465INSERT INTO t37 VALUES (37);
466CREATE TABLE t36 (a INT);
467INSERT INTO t36 VALUES (36);
468CREATE TABLE t35 (a INT);
469INSERT INTO t35 VALUES (35);
470CREATE TABLE t34 (a INT);
471INSERT INTO t34 VALUES (34);
472CREATE TABLE t33 (a INT);
473INSERT INTO t33 VALUES (33);
474CREATE TABLE t32 (a INT);
475INSERT INTO t32 VALUES (32);
476CREATE TABLE t31 (a INT);
477INSERT INTO t31 VALUES (31);
478CREATE TABLE t30 (a INT);
479INSERT INTO t30 VALUES (30);
480CREATE TABLE t29 (a INT);
481INSERT INTO t29 VALUES (29);
482CREATE TABLE t28 (a INT);
483INSERT INTO t28 VALUES (28);
484CREATE TABLE t27 (a INT);
485INSERT INTO t27 VALUES (27);
486CREATE TABLE t26 (a INT);
487INSERT INTO t26 VALUES (26);
488CREATE TABLE t25 (a INT);
489INSERT INTO t25 VALUES (25);
490CREATE TABLE t24 (a INT);
491INSERT INTO t24 VALUES (24);
492CREATE TABLE t23 (a INT);
493INSERT INTO t23 VALUES (23);
494CREATE TABLE t22 (a INT);
495INSERT INTO t22 VALUES (22);
496CREATE TABLE t21 (a INT);
497INSERT INTO t21 VALUES (21);
498CREATE TABLE t20 (a INT);
499INSERT INTO t20 VALUES (20);
500CREATE TABLE t19 (a INT);
501INSERT INTO t19 VALUES (19);
502CREATE TABLE t18 (a INT);
503INSERT INTO t18 VALUES (18);
504CREATE TABLE t17 (a INT);
505INSERT INTO t17 VALUES (17);
506CREATE TABLE t16 (a INT);
507INSERT INTO t16 VALUES (16);
508CREATE TABLE t15 (a INT);
509INSERT INTO t15 VALUES (15);
510CREATE TABLE t14 (a INT);
511INSERT INTO t14 VALUES (14);
512CREATE TABLE t13 (a INT);
513INSERT INTO t13 VALUES (13);
514CREATE TABLE t12 (a INT);
515INSERT INTO t12 VALUES (12);
516CREATE TABLE t11 (a INT);
517INSERT INTO t11 VALUES (11);
518CREATE TABLE t10 (a INT);
519INSERT INTO t10 VALUES (10);
520CREATE TABLE t9 (a INT);
521INSERT INTO t9 VALUES (9);
522CREATE TABLE t8 (a INT);
523INSERT INTO t8 VALUES (8);
524CREATE TABLE t7 (a INT);
525INSERT INTO t7 VALUES (7);
526CREATE TABLE t6 (a INT);
527INSERT INTO t6 VALUES (6);
528CREATE TABLE t5 (a INT);
529INSERT INTO t5 VALUES (5);
530CREATE TABLE t4 (a INT);
531INSERT INTO t4 VALUES (4);
532CREATE TABLE t3 (a INT);
533INSERT INTO t3 VALUES (3);
534CREATE TABLE t2 (a INT);
535INSERT INTO t2 VALUES (2);
536CREATE TABLE t1 (a INT);
537INSERT INTO t1 VALUES (1);
538CREATE 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);
539SET GLOBAL query_cache_size = 1048576;
540Warnings:
541Warning	1287	'@@query_cache_size' is deprecated and will be removed in a future release.
542FLUSH STATUS;
543SELECT a FROM t0 WHERE a = 1;
544a
5451
546SHOW STATUS LIKE "Qcache_queries_in_cache";
547Variable_name	Value
548Qcache_queries_in_cache	1
549TRUNCATE TABLE t255;
550SELECT a FROM t1;
551a
5521
553TRUNCATE TABLE t254;
554SELECT a FROM t2;
555a
5562
557TRUNCATE TABLE t253;
558SELECT a FROM t3;
559a
5603
561TRUNCATE TABLE t252;
562SELECT a FROM t4;
563a
5644
565TRUNCATE TABLE t251;
566SELECT a FROM t5;
567a
5685
569TRUNCATE TABLE t250;
570SELECT a FROM t6;
571a
5726
573TRUNCATE TABLE t249;
574SELECT a FROM t7;
575a
5767
577TRUNCATE TABLE t248;
578SELECT a FROM t8;
579a
5808
581TRUNCATE TABLE t247;
582SELECT a FROM t9;
583a
5849
585TRUNCATE TABLE t246;
586SELECT a FROM t10;
587a
58810
589TRUNCATE TABLE t245;
590SELECT a FROM t11;
591a
59211
593TRUNCATE TABLE t244;
594SELECT a FROM t12;
595a
59612
597TRUNCATE TABLE t243;
598SELECT a FROM t13;
599a
60013
601TRUNCATE TABLE t242;
602SELECT a FROM t14;
603a
60414
605TRUNCATE TABLE t241;
606SELECT a FROM t15;
607a
60815
609TRUNCATE TABLE t240;
610SELECT a FROM t16;
611a
61216
613TRUNCATE TABLE t239;
614SELECT a FROM t17;
615a
61617
617TRUNCATE TABLE t238;
618SELECT a FROM t18;
619a
62018
621TRUNCATE TABLE t237;
622SELECT a FROM t19;
623a
62419
625TRUNCATE TABLE t236;
626SELECT a FROM t20;
627a
62820
629TRUNCATE TABLE t235;
630SELECT a FROM t21;
631a
63221
633TRUNCATE TABLE t234;
634SELECT a FROM t22;
635a
63622
637TRUNCATE TABLE t233;
638SELECT a FROM t23;
639a
64023
641TRUNCATE TABLE t232;
642SELECT a FROM t24;
643a
64424
645TRUNCATE TABLE t231;
646SELECT a FROM t25;
647a
64825
649TRUNCATE TABLE t230;
650SELECT a FROM t26;
651a
65226
653TRUNCATE TABLE t229;
654SELECT a FROM t27;
655a
65627
657TRUNCATE TABLE t228;
658SELECT a FROM t28;
659a
66028
661TRUNCATE TABLE t227;
662SELECT a FROM t29;
663a
66429
665TRUNCATE TABLE t226;
666SELECT a FROM t30;
667a
66830
669TRUNCATE TABLE t225;
670SELECT a FROM t31;
671a
67231
673TRUNCATE TABLE t224;
674SELECT a FROM t32;
675a
67632
677TRUNCATE TABLE t223;
678SELECT a FROM t33;
679a
68033
681TRUNCATE TABLE t222;
682SELECT a FROM t34;
683a
68434
685TRUNCATE TABLE t221;
686SELECT a FROM t35;
687a
68835
689TRUNCATE TABLE t220;
690SELECT a FROM t36;
691a
69236
693TRUNCATE TABLE t219;
694SELECT a FROM t37;
695a
69637
697TRUNCATE TABLE t218;
698SELECT a FROM t38;
699a
70038
701TRUNCATE TABLE t217;
702SELECT a FROM t39;
703a
70439
705TRUNCATE TABLE t216;
706SELECT a FROM t40;
707a
70840
709TRUNCATE TABLE t215;
710SELECT a FROM t41;
711a
71241
713TRUNCATE TABLE t214;
714SELECT a FROM t42;
715a
71642
717TRUNCATE TABLE t213;
718SELECT a FROM t43;
719a
72043
721TRUNCATE TABLE t212;
722SELECT a FROM t44;
723a
72444
725TRUNCATE TABLE t211;
726SELECT a FROM t45;
727a
72845
729TRUNCATE TABLE t210;
730SELECT a FROM t46;
731a
73246
733TRUNCATE TABLE t209;
734SELECT a FROM t47;
735a
73647
737TRUNCATE TABLE t208;
738SELECT a FROM t48;
739a
74048
741TRUNCATE TABLE t207;
742SELECT a FROM t49;
743a
74449
745TRUNCATE TABLE t206;
746SELECT a FROM t50;
747a
74850
749TRUNCATE TABLE t205;
750SELECT a FROM t51;
751a
75251
753TRUNCATE TABLE t204;
754SELECT a FROM t52;
755a
75652
757TRUNCATE TABLE t203;
758SELECT a FROM t53;
759a
76053
761TRUNCATE TABLE t202;
762SELECT a FROM t54;
763a
76454
765TRUNCATE TABLE t201;
766SELECT a FROM t55;
767a
76855
769TRUNCATE TABLE t200;
770SELECT a FROM t56;
771a
77256
773TRUNCATE TABLE t199;
774SELECT a FROM t57;
775a
77657
777TRUNCATE TABLE t198;
778SELECT a FROM t58;
779a
78058
781TRUNCATE TABLE t197;
782SELECT a FROM t59;
783a
78459
785TRUNCATE TABLE t196;
786SELECT a FROM t60;
787a
78860
789TRUNCATE TABLE t195;
790SELECT a FROM t61;
791a
79261
793TRUNCATE TABLE t194;
794SELECT a FROM t62;
795a
79662
797TRUNCATE TABLE t193;
798SELECT a FROM t63;
799a
80063
801TRUNCATE TABLE t192;
802SELECT a FROM t64;
803a
80464
805TRUNCATE TABLE t191;
806SELECT a FROM t65;
807a
80865
809TRUNCATE TABLE t190;
810SELECT a FROM t66;
811a
81266
813TRUNCATE TABLE t189;
814SELECT a FROM t67;
815a
81667
817TRUNCATE TABLE t188;
818SELECT a FROM t68;
819a
82068
821TRUNCATE TABLE t187;
822SELECT a FROM t69;
823a
82469
825TRUNCATE TABLE t186;
826SELECT a FROM t70;
827a
82870
829TRUNCATE TABLE t185;
830SELECT a FROM t71;
831a
83271
833TRUNCATE TABLE t184;
834SELECT a FROM t72;
835a
83672
837TRUNCATE TABLE t183;
838SELECT a FROM t73;
839a
84073
841TRUNCATE TABLE t182;
842SELECT a FROM t74;
843a
84474
845TRUNCATE TABLE t181;
846SELECT a FROM t75;
847a
84875
849TRUNCATE TABLE t180;
850SELECT a FROM t76;
851a
85276
853TRUNCATE TABLE t179;
854SELECT a FROM t77;
855a
85677
857TRUNCATE TABLE t178;
858SELECT a FROM t78;
859a
86078
861TRUNCATE TABLE t177;
862SELECT a FROM t79;
863a
86479
865TRUNCATE TABLE t176;
866SELECT a FROM t80;
867a
86880
869TRUNCATE TABLE t175;
870SELECT a FROM t81;
871a
87281
873TRUNCATE TABLE t174;
874SELECT a FROM t82;
875a
87682
877TRUNCATE TABLE t173;
878SELECT a FROM t83;
879a
88083
881TRUNCATE TABLE t172;
882SELECT a FROM t84;
883a
88484
885TRUNCATE TABLE t171;
886SELECT a FROM t85;
887a
88885
889TRUNCATE TABLE t170;
890SELECT a FROM t86;
891a
89286
893TRUNCATE TABLE t169;
894SELECT a FROM t87;
895a
89687
897TRUNCATE TABLE t168;
898SELECT a FROM t88;
899a
90088
901TRUNCATE TABLE t167;
902SELECT a FROM t89;
903a
90489
905TRUNCATE TABLE t166;
906SELECT a FROM t90;
907a
90890
909TRUNCATE TABLE t165;
910SELECT a FROM t91;
911a
91291
913TRUNCATE TABLE t164;
914SELECT a FROM t92;
915a
91692
917TRUNCATE TABLE t163;
918SELECT a FROM t93;
919a
92093
921TRUNCATE TABLE t162;
922SELECT a FROM t94;
923a
92494
925TRUNCATE TABLE t161;
926SELECT a FROM t95;
927a
92895
929TRUNCATE TABLE t160;
930SELECT a FROM t96;
931a
93296
933TRUNCATE TABLE t159;
934SELECT a FROM t97;
935a
93697
937TRUNCATE TABLE t158;
938SELECT a FROM t98;
939a
94098
941TRUNCATE TABLE t157;
942SELECT a FROM t99;
943a
94499
945TRUNCATE TABLE t156;
946SELECT a FROM t100;
947a
948100
949TRUNCATE TABLE t155;
950SELECT a FROM t101;
951a
952101
953TRUNCATE TABLE t154;
954SELECT a FROM t102;
955a
956102
957TRUNCATE TABLE t153;
958SELECT a FROM t103;
959a
960103
961TRUNCATE TABLE t152;
962SELECT a FROM t104;
963a
964104
965TRUNCATE TABLE t151;
966SELECT a FROM t105;
967a
968105
969TRUNCATE TABLE t150;
970SELECT a FROM t106;
971a
972106
973TRUNCATE TABLE t149;
974SELECT a FROM t107;
975a
976107
977TRUNCATE TABLE t148;
978SELECT a FROM t108;
979a
980108
981TRUNCATE TABLE t147;
982SELECT a FROM t109;
983a
984109
985TRUNCATE TABLE t146;
986SELECT a FROM t110;
987a
988110
989TRUNCATE TABLE t145;
990SELECT a FROM t111;
991a
992111
993TRUNCATE TABLE t144;
994SELECT a FROM t112;
995a
996112
997TRUNCATE TABLE t143;
998SELECT a FROM t113;
999a
1000113
1001TRUNCATE TABLE t142;
1002SELECT a FROM t114;
1003a
1004114
1005TRUNCATE TABLE t141;
1006SELECT a FROM t115;
1007a
1008115
1009TRUNCATE TABLE t140;
1010SELECT a FROM t116;
1011a
1012116
1013TRUNCATE TABLE t139;
1014SELECT a FROM t117;
1015a
1016117
1017TRUNCATE TABLE t138;
1018SELECT a FROM t118;
1019a
1020118
1021TRUNCATE TABLE t137;
1022SELECT a FROM t119;
1023a
1024119
1025TRUNCATE TABLE t136;
1026SELECT a FROM t120;
1027a
1028120
1029TRUNCATE TABLE t135;
1030SELECT a FROM t121;
1031a
1032121
1033TRUNCATE TABLE t134;
1034SELECT a FROM t122;
1035a
1036122
1037TRUNCATE TABLE t133;
1038SELECT a FROM t123;
1039a
1040123
1041TRUNCATE TABLE t132;
1042SELECT a FROM t124;
1043a
1044124
1045TRUNCATE TABLE t131;
1046SELECT a FROM t125;
1047a
1048125
1049TRUNCATE TABLE t130;
1050SELECT a FROM t126;
1051a
1052126
1053TRUNCATE TABLE t129;
1054SELECT a FROM t127;
1055a
1056127
1057TRUNCATE TABLE t128;
1058SELECT a FROM t128;
1059a
1060TRUNCATE TABLE t127;
1061SELECT a FROM t129;
1062a
1063TRUNCATE TABLE t126;
1064SELECT a FROM t130;
1065a
1066TRUNCATE TABLE t125;
1067SELECT a FROM t131;
1068a
1069TRUNCATE TABLE t124;
1070SELECT a FROM t132;
1071a
1072TRUNCATE TABLE t123;
1073SELECT a FROM t133;
1074a
1075TRUNCATE TABLE t122;
1076SELECT a FROM t134;
1077a
1078TRUNCATE TABLE t121;
1079SELECT a FROM t135;
1080a
1081TRUNCATE TABLE t120;
1082SELECT a FROM t136;
1083a
1084TRUNCATE TABLE t119;
1085SELECT a FROM t137;
1086a
1087TRUNCATE TABLE t118;
1088SELECT a FROM t138;
1089a
1090TRUNCATE TABLE t117;
1091SELECT a FROM t139;
1092a
1093TRUNCATE TABLE t116;
1094SELECT a FROM t140;
1095a
1096TRUNCATE TABLE t115;
1097SELECT a FROM t141;
1098a
1099TRUNCATE TABLE t114;
1100SELECT a FROM t142;
1101a
1102TRUNCATE TABLE t113;
1103SELECT a FROM t143;
1104a
1105TRUNCATE TABLE t112;
1106SELECT a FROM t144;
1107a
1108TRUNCATE TABLE t111;
1109SELECT a FROM t145;
1110a
1111TRUNCATE TABLE t110;
1112SELECT a FROM t146;
1113a
1114TRUNCATE TABLE t109;
1115SELECT a FROM t147;
1116a
1117TRUNCATE TABLE t108;
1118SELECT a FROM t148;
1119a
1120TRUNCATE TABLE t107;
1121SELECT a FROM t149;
1122a
1123TRUNCATE TABLE t106;
1124SELECT a FROM t150;
1125a
1126TRUNCATE TABLE t105;
1127SELECT a FROM t151;
1128a
1129TRUNCATE TABLE t104;
1130SELECT a FROM t152;
1131a
1132TRUNCATE TABLE t103;
1133SELECT a FROM t153;
1134a
1135TRUNCATE TABLE t102;
1136SELECT a FROM t154;
1137a
1138TRUNCATE TABLE t101;
1139SELECT a FROM t155;
1140a
1141TRUNCATE TABLE t100;
1142SELECT a FROM t156;
1143a
1144TRUNCATE TABLE t99;
1145SELECT a FROM t157;
1146a
1147TRUNCATE TABLE t98;
1148SELECT a FROM t158;
1149a
1150TRUNCATE TABLE t97;
1151SELECT a FROM t159;
1152a
1153TRUNCATE TABLE t96;
1154SELECT a FROM t160;
1155a
1156TRUNCATE TABLE t95;
1157SELECT a FROM t161;
1158a
1159TRUNCATE TABLE t94;
1160SELECT a FROM t162;
1161a
1162TRUNCATE TABLE t93;
1163SELECT a FROM t163;
1164a
1165TRUNCATE TABLE t92;
1166SELECT a FROM t164;
1167a
1168TRUNCATE TABLE t91;
1169SELECT a FROM t165;
1170a
1171TRUNCATE TABLE t90;
1172SELECT a FROM t166;
1173a
1174TRUNCATE TABLE t89;
1175SELECT a FROM t167;
1176a
1177TRUNCATE TABLE t88;
1178SELECT a FROM t168;
1179a
1180TRUNCATE TABLE t87;
1181SELECT a FROM t169;
1182a
1183TRUNCATE TABLE t86;
1184SELECT a FROM t170;
1185a
1186TRUNCATE TABLE t85;
1187SELECT a FROM t171;
1188a
1189TRUNCATE TABLE t84;
1190SELECT a FROM t172;
1191a
1192TRUNCATE TABLE t83;
1193SELECT a FROM t173;
1194a
1195TRUNCATE TABLE t82;
1196SELECT a FROM t174;
1197a
1198TRUNCATE TABLE t81;
1199SELECT a FROM t175;
1200a
1201TRUNCATE TABLE t80;
1202SELECT a FROM t176;
1203a
1204TRUNCATE TABLE t79;
1205SELECT a FROM t177;
1206a
1207TRUNCATE TABLE t78;
1208SELECT a FROM t178;
1209a
1210TRUNCATE TABLE t77;
1211SELECT a FROM t179;
1212a
1213TRUNCATE TABLE t76;
1214SELECT a FROM t180;
1215a
1216TRUNCATE TABLE t75;
1217SELECT a FROM t181;
1218a
1219TRUNCATE TABLE t74;
1220SELECT a FROM t182;
1221a
1222TRUNCATE TABLE t73;
1223SELECT a FROM t183;
1224a
1225TRUNCATE TABLE t72;
1226SELECT a FROM t184;
1227a
1228TRUNCATE TABLE t71;
1229SELECT a FROM t185;
1230a
1231TRUNCATE TABLE t70;
1232SELECT a FROM t186;
1233a
1234TRUNCATE TABLE t69;
1235SELECT a FROM t187;
1236a
1237TRUNCATE TABLE t68;
1238SELECT a FROM t188;
1239a
1240TRUNCATE TABLE t67;
1241SELECT a FROM t189;
1242a
1243TRUNCATE TABLE t66;
1244SELECT a FROM t190;
1245a
1246TRUNCATE TABLE t65;
1247SELECT a FROM t191;
1248a
1249TRUNCATE TABLE t64;
1250SELECT a FROM t192;
1251a
1252TRUNCATE TABLE t63;
1253SELECT a FROM t193;
1254a
1255TRUNCATE TABLE t62;
1256SELECT a FROM t194;
1257a
1258TRUNCATE TABLE t61;
1259SELECT a FROM t195;
1260a
1261TRUNCATE TABLE t60;
1262SELECT a FROM t196;
1263a
1264TRUNCATE TABLE t59;
1265SELECT a FROM t197;
1266a
1267TRUNCATE TABLE t58;
1268SELECT a FROM t198;
1269a
1270TRUNCATE TABLE t57;
1271SELECT a FROM t199;
1272a
1273TRUNCATE TABLE t56;
1274SELECT a FROM t200;
1275a
1276TRUNCATE TABLE t55;
1277SELECT a FROM t201;
1278a
1279TRUNCATE TABLE t54;
1280SELECT a FROM t202;
1281a
1282TRUNCATE TABLE t53;
1283SELECT a FROM t203;
1284a
1285TRUNCATE TABLE t52;
1286SELECT a FROM t204;
1287a
1288TRUNCATE TABLE t51;
1289SELECT a FROM t205;
1290a
1291TRUNCATE TABLE t50;
1292SELECT a FROM t206;
1293a
1294TRUNCATE TABLE t49;
1295SELECT a FROM t207;
1296a
1297TRUNCATE TABLE t48;
1298SELECT a FROM t208;
1299a
1300TRUNCATE TABLE t47;
1301SELECT a FROM t209;
1302a
1303TRUNCATE TABLE t46;
1304SELECT a FROM t210;
1305a
1306TRUNCATE TABLE t45;
1307SELECT a FROM t211;
1308a
1309TRUNCATE TABLE t44;
1310SELECT a FROM t212;
1311a
1312TRUNCATE TABLE t43;
1313SELECT a FROM t213;
1314a
1315TRUNCATE TABLE t42;
1316SELECT a FROM t214;
1317a
1318TRUNCATE TABLE t41;
1319SELECT a FROM t215;
1320a
1321TRUNCATE TABLE t40;
1322SELECT a FROM t216;
1323a
1324TRUNCATE TABLE t39;
1325SELECT a FROM t217;
1326a
1327TRUNCATE TABLE t38;
1328SELECT a FROM t218;
1329a
1330TRUNCATE TABLE t37;
1331SELECT a FROM t219;
1332a
1333TRUNCATE TABLE t36;
1334SELECT a FROM t220;
1335a
1336TRUNCATE TABLE t35;
1337SELECT a FROM t221;
1338a
1339TRUNCATE TABLE t34;
1340SELECT a FROM t222;
1341a
1342TRUNCATE TABLE t33;
1343SELECT a FROM t223;
1344a
1345TRUNCATE TABLE t32;
1346SELECT a FROM t224;
1347a
1348TRUNCATE TABLE t31;
1349SELECT a FROM t225;
1350a
1351TRUNCATE TABLE t30;
1352SELECT a FROM t226;
1353a
1354TRUNCATE TABLE t29;
1355SELECT a FROM t227;
1356a
1357TRUNCATE TABLE t28;
1358SELECT a FROM t228;
1359a
1360TRUNCATE TABLE t27;
1361SELECT a FROM t229;
1362a
1363TRUNCATE TABLE t26;
1364SELECT a FROM t230;
1365a
1366TRUNCATE TABLE t25;
1367SELECT a FROM t231;
1368a
1369TRUNCATE TABLE t24;
1370SELECT a FROM t232;
1371a
1372TRUNCATE TABLE t23;
1373SELECT a FROM t233;
1374a
1375TRUNCATE TABLE t22;
1376SELECT a FROM t234;
1377a
1378TRUNCATE TABLE t21;
1379SELECT a FROM t235;
1380a
1381TRUNCATE TABLE t20;
1382SELECT a FROM t236;
1383a
1384TRUNCATE TABLE t19;
1385SELECT a FROM t237;
1386a
1387TRUNCATE TABLE t18;
1388SELECT a FROM t238;
1389a
1390TRUNCATE TABLE t17;
1391SELECT a FROM t239;
1392a
1393TRUNCATE TABLE t16;
1394SELECT a FROM t240;
1395a
1396TRUNCATE TABLE t15;
1397SELECT a FROM t241;
1398a
1399TRUNCATE TABLE t14;
1400SELECT a FROM t242;
1401a
1402TRUNCATE TABLE t13;
1403SELECT a FROM t243;
1404a
1405TRUNCATE TABLE t12;
1406SELECT a FROM t244;
1407a
1408TRUNCATE TABLE t11;
1409SELECT a FROM t245;
1410a
1411TRUNCATE TABLE t10;
1412SELECT a FROM t246;
1413a
1414TRUNCATE TABLE t9;
1415SELECT a FROM t247;
1416a
1417TRUNCATE TABLE t8;
1418SELECT a FROM t248;
1419a
1420TRUNCATE TABLE t7;
1421SELECT a FROM t249;
1422a
1423TRUNCATE TABLE t6;
1424SELECT a FROM t250;
1425a
1426TRUNCATE TABLE t5;
1427SELECT a FROM t251;
1428a
1429TRUNCATE TABLE t4;
1430SELECT a FROM t252;
1431a
1432TRUNCATE TABLE t3;
1433SELECT a FROM t253;
1434a
1435TRUNCATE TABLE t2;
1436SELECT a FROM t254;
1437a
1438TRUNCATE TABLE t1;
1439SELECT a FROM t255;
1440a
1441SELECT a FROM t0;
1442a
1443DROP TABLE t0;
1444DROP TABLE t255;
1445DROP TABLE t254;
1446DROP TABLE t253;
1447DROP TABLE t252;
1448DROP TABLE t251;
1449DROP TABLE t250;
1450DROP TABLE t249;
1451DROP TABLE t248;
1452DROP TABLE t247;
1453DROP TABLE t246;
1454DROP TABLE t245;
1455DROP TABLE t244;
1456DROP TABLE t243;
1457DROP TABLE t242;
1458DROP TABLE t241;
1459DROP TABLE t240;
1460DROP TABLE t239;
1461DROP TABLE t238;
1462DROP TABLE t237;
1463DROP TABLE t236;
1464DROP TABLE t235;
1465DROP TABLE t234;
1466DROP TABLE t233;
1467DROP TABLE t232;
1468DROP TABLE t231;
1469DROP TABLE t230;
1470DROP TABLE t229;
1471DROP TABLE t228;
1472DROP TABLE t227;
1473DROP TABLE t226;
1474DROP TABLE t225;
1475DROP TABLE t224;
1476DROP TABLE t223;
1477DROP TABLE t222;
1478DROP TABLE t221;
1479DROP TABLE t220;
1480DROP TABLE t219;
1481DROP TABLE t218;
1482DROP TABLE t217;
1483DROP TABLE t216;
1484DROP TABLE t215;
1485DROP TABLE t214;
1486DROP TABLE t213;
1487DROP TABLE t212;
1488DROP TABLE t211;
1489DROP TABLE t210;
1490DROP TABLE t209;
1491DROP TABLE t208;
1492DROP TABLE t207;
1493DROP TABLE t206;
1494DROP TABLE t205;
1495DROP TABLE t204;
1496DROP TABLE t203;
1497DROP TABLE t202;
1498DROP TABLE t201;
1499DROP TABLE t200;
1500DROP TABLE t199;
1501DROP TABLE t198;
1502DROP TABLE t197;
1503DROP TABLE t196;
1504DROP TABLE t195;
1505DROP TABLE t194;
1506DROP TABLE t193;
1507DROP TABLE t192;
1508DROP TABLE t191;
1509DROP TABLE t190;
1510DROP TABLE t189;
1511DROP TABLE t188;
1512DROP TABLE t187;
1513DROP TABLE t186;
1514DROP TABLE t185;
1515DROP TABLE t184;
1516DROP TABLE t183;
1517DROP TABLE t182;
1518DROP TABLE t181;
1519DROP TABLE t180;
1520DROP TABLE t179;
1521DROP TABLE t178;
1522DROP TABLE t177;
1523DROP TABLE t176;
1524DROP TABLE t175;
1525DROP TABLE t174;
1526DROP TABLE t173;
1527DROP TABLE t172;
1528DROP TABLE t171;
1529DROP TABLE t170;
1530DROP TABLE t169;
1531DROP TABLE t168;
1532DROP TABLE t167;
1533DROP TABLE t166;
1534DROP TABLE t165;
1535DROP TABLE t164;
1536DROP TABLE t163;
1537DROP TABLE t162;
1538DROP TABLE t161;
1539DROP TABLE t160;
1540DROP TABLE t159;
1541DROP TABLE t158;
1542DROP TABLE t157;
1543DROP TABLE t156;
1544DROP TABLE t155;
1545DROP TABLE t154;
1546DROP TABLE t153;
1547DROP TABLE t152;
1548DROP TABLE t151;
1549DROP TABLE t150;
1550DROP TABLE t149;
1551DROP TABLE t148;
1552DROP TABLE t147;
1553DROP TABLE t146;
1554DROP TABLE t145;
1555DROP TABLE t144;
1556DROP TABLE t143;
1557DROP TABLE t142;
1558DROP TABLE t141;
1559DROP TABLE t140;
1560DROP TABLE t139;
1561DROP TABLE t138;
1562DROP TABLE t137;
1563DROP TABLE t136;
1564DROP TABLE t135;
1565DROP TABLE t134;
1566DROP TABLE t133;
1567DROP TABLE t132;
1568DROP TABLE t131;
1569DROP TABLE t130;
1570DROP TABLE t129;
1571DROP TABLE t128;
1572DROP TABLE t127;
1573DROP TABLE t126;
1574DROP TABLE t125;
1575DROP TABLE t124;
1576DROP TABLE t123;
1577DROP TABLE t122;
1578DROP TABLE t121;
1579DROP TABLE t120;
1580DROP TABLE t119;
1581DROP TABLE t118;
1582DROP TABLE t117;
1583DROP TABLE t116;
1584DROP TABLE t115;
1585DROP TABLE t114;
1586DROP TABLE t113;
1587DROP TABLE t112;
1588DROP TABLE t111;
1589DROP TABLE t110;
1590DROP TABLE t109;
1591DROP TABLE t108;
1592DROP TABLE t107;
1593DROP TABLE t106;
1594DROP TABLE t105;
1595DROP TABLE t104;
1596DROP TABLE t103;
1597DROP TABLE t102;
1598DROP TABLE t101;
1599DROP TABLE t100;
1600DROP TABLE t99;
1601DROP TABLE t98;
1602DROP TABLE t97;
1603DROP TABLE t96;
1604DROP TABLE t95;
1605DROP TABLE t94;
1606DROP TABLE t93;
1607DROP TABLE t92;
1608DROP TABLE t91;
1609DROP TABLE t90;
1610DROP TABLE t89;
1611DROP TABLE t88;
1612DROP TABLE t87;
1613DROP TABLE t86;
1614DROP TABLE t85;
1615DROP TABLE t84;
1616DROP TABLE t83;
1617DROP TABLE t82;
1618DROP TABLE t81;
1619DROP TABLE t80;
1620DROP TABLE t79;
1621DROP TABLE t78;
1622DROP TABLE t77;
1623DROP TABLE t76;
1624DROP TABLE t75;
1625DROP TABLE t74;
1626DROP TABLE t73;
1627DROP TABLE t72;
1628DROP TABLE t71;
1629DROP TABLE t70;
1630DROP TABLE t69;
1631DROP TABLE t68;
1632DROP TABLE t67;
1633DROP TABLE t66;
1634DROP TABLE t65;
1635DROP TABLE t64;
1636DROP TABLE t63;
1637DROP TABLE t62;
1638DROP TABLE t61;
1639DROP TABLE t60;
1640DROP TABLE t59;
1641DROP TABLE t58;
1642DROP TABLE t57;
1643DROP TABLE t56;
1644DROP TABLE t55;
1645DROP TABLE t54;
1646DROP TABLE t53;
1647DROP TABLE t52;
1648DROP TABLE t51;
1649DROP TABLE t50;
1650DROP TABLE t49;
1651DROP TABLE t48;
1652DROP TABLE t47;
1653DROP TABLE t46;
1654DROP TABLE t45;
1655DROP TABLE t44;
1656DROP TABLE t43;
1657DROP TABLE t42;
1658DROP TABLE t41;
1659DROP TABLE t40;
1660DROP TABLE t39;
1661DROP TABLE t38;
1662DROP TABLE t37;
1663DROP TABLE t36;
1664DROP TABLE t35;
1665DROP TABLE t34;
1666DROP TABLE t33;
1667DROP TABLE t32;
1668DROP TABLE t31;
1669DROP TABLE t30;
1670DROP TABLE t29;
1671DROP TABLE t28;
1672DROP TABLE t27;
1673DROP TABLE t26;
1674DROP TABLE t25;
1675DROP TABLE t24;
1676DROP TABLE t23;
1677DROP TABLE t22;
1678DROP TABLE t21;
1679DROP TABLE t20;
1680DROP TABLE t19;
1681DROP TABLE t18;
1682DROP TABLE t17;
1683DROP TABLE t16;
1684DROP TABLE t15;
1685DROP TABLE t14;
1686DROP TABLE t13;
1687DROP TABLE t12;
1688DROP TABLE t11;
1689DROP TABLE t10;
1690DROP TABLE t9;
1691DROP TABLE t8;
1692DROP TABLE t7;
1693DROP TABLE t6;
1694DROP TABLE t5;
1695DROP TABLE t4;
1696DROP TABLE t3;
1697DROP TABLE t2;
1698DROP TABLE t1;
1699SET @@global.query_cache_size = DEFAULT;
1700Warnings:
1701Warning	1287	'@@query_cache_size' is deprecated and will be removed in a future release.
1702SET @@global.table_definition_cache = @save_table_definition_cache;
1703End of 5.1 tests
1704