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