From 6b1ff7e2a4fc1fcc79b5cb2c0c457cf4cb7f37dc Mon Sep 17 00:00:00 2001 From: Rahul Malik Date: Thu, 16 Jun 2022 15:20:23 +0530 Subject: [PATCH] PS-107207 Assertion Failure buf0buf.cc:4318:page_size.equals_to(space_page_size) https://bugs.mysql.com/bug.php?id=107207 Problem: Crash in debug build when discard table followed by drop table. Analysis: As part of discard tablespace, server sets index root page to null but does not remove AHI(Adaptive Hash Index) entries from buffer pool.It can causes crash if there a drop after the discard tablespace. As drop tablespace explicity remove AHI entries but these indexes root pages are already set to null and it asserts different places in code Fix: drop AHI as part of discard tablespace --- .../innodb/r/discard_drop_tablespace.result | 425 +++++++++++++++++ .../innodb/t/discard_drop_tablespace.test | 431 ++++++++++++++++++ storage/innobase/row/row0mysql.cc | 1 + 3 files changed, 857 insertions(+) create mode 100644 mysql-test/suite/innodb/r/discard_drop_tablespace.result create mode 100644 mysql-test/suite/innodb/t/discard_drop_tablespace.test diff --git a/mysql-test/suite/innodb/r/discard_drop_tablespace.result b/mysql-test/suite/innodb/r/discard_drop_tablespace.result new file mode 100644 index 000000000000..cf8007264c96 --- /dev/null +++ b/mysql-test/suite/innodb/r/discard_drop_tablespace.result @@ -0,0 +1,425 @@ +# +# Bug#107207 Assertion Failure buf0buf.cc:4318:page_size.equals_to(space_page_size) +# +CREATE TABLE tt_4 (ipkey INT, i1 INT AUTO_INCREMENT, v2 VARCHAR(11), i3 INT, v4 VARCHAR(12), i5 INT, PRIMARY KEY(ipkey), INDEX tt_4i0(i5, i3 DESC, v2 DESC) , INDEX tt_4i1(i3, i1, v4 ASC) , INDEX tt_4i2(i5, v2, i1) , INDEX tt_4i3(ipkey DESC, i5 ASC, i3 DESC, v4 ASC, v2 DESC) , INDEX tt_4i4(i1 DESC, v2 DESC, v4, i3) ) ENCRYPTION='N' ENGINE=InnoDB ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 3996, 40643, '3UpuyZ', 40507, 'vABx6pjGVGit', 9934 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22723, 32292, '1S8xT3', 21969, 'RTl', 31466 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40190, 22356, '', 25688, '3xl932l9RQM5', 26963 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 47065, 31327, 'YIv', 46234, 'L3fMUT', 32812 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22180, 36284, 'i', 1077, 'Y', 24671 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22194, 42243, 'ZD1DWH', 40824, '7S2ii9LodlT', 8396 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20064, 1591, 'gumUU4j', 19803, '4mMOyE', 20341 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37358, 26898, 'qmMU', 46427, 'IGl', 36047 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 23388, 7286, 'w', 46734, 'gw', 33041 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35146, 46405, 'i', 8377, 'zSifdJTI', 30296 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41072, NULL, '', 35139, 'IbPaom', 2364 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20915, 43056, 'kl', 27234, 'I28NQ4', 27927 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15341, 36795, '4o0PR7', 49923, 'GhiuqC', 8773 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 649, NULL, 'Bi', 42231, 'm3jsVLKORC6B', 26416 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16240, 11939, '', 28305, 'bmURJ', 6498 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43830, 34176, '8', 40762, 'yeWEdbgK', 46579 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14510, 25451, 'x', 38758, 'FrMb4aH8b', 1038 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30059, 23990, '6L6B', 8738, '0xq', 39781 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32601, 16119, 'H', 33584, 'Y8h', 19698 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37999, 10970, 'TJyyDsNS', 27973, 'A2BlqOMbQ1', 8636 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12279, 24977, 'ylfnJ', 30261, 'tw7pNcGXE', 26913 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9933, 9949, '7wZA3OLWmV', 2365, '46Qbk16', 12350 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6956, 10733, 'U5usj0', 47179, 'b5Eo', 15401 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14982, 49512, 'Yx', 40952, 'NWspACo', 37081 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29529, 684, '0Xpylgkfn', 22347, 'pBMfkq6qK', 25867 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16514, 5641, '', 31747, 'et4lO5w', 10970 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22806, 5379, 'edP2Xo1', 36524, 'M6XWxS', 45473 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18537, 49681, 'Wa4', 38813, '', 26011 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 13333, 21050, '3ruEjhBFr', 6901, 'xpSv03K1', 28200 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 25917, 17433, 'i8', 22740, 'jW2Qjd', 20809 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 574, 37308, '40hsk80GH5', 27805, 'f', 31078 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 2663, 31505, 'dDL8', 45820, 'SbpZDkDDG', 47080 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35683, 10645, 'XU46v0', 35123, 'Lu', 28083 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19726, 5580, '', 23036, '', 24065 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8882, 31800, 'ar9UALiyr0y', 15075, 'SaxgLKfj', 15381 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9849, 46086, '2WgQE', 11475, '91M', 10462 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 11199, 46803, 'mHYMK', 24778, 'md39Tp59I', 19127 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46509, 36038, 'UPo', 43321, 'A', 38571 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 3863, 8312, 'kzcU5LXpn', 5140, '', 11924 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40926, 9515, 'sSfsBL8Zae', 9961, 'FpGe5z', 25947 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 7482, 12038, 'lF1adqpp', 49998, '5j6EwFhn3Nl', 43902 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9960, 31763, 'qIMg2P9Moc', 32918, 'zT1', 23728 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48921, 27925, 'PopjIARHz', 15204, 'h3kO', 41416 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 10041, 37402, 'v', 15525, 'o2kkoyK', 1826 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18453, 21124, 'yfo', 30887, '', 3520 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30619, 34928, 'z', 21160, '1An', 28049 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28961, 39021, 'ZaQy5', 31573, 'yx', 23545 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37034, 30054, '591Fj8Y5', 39357, 'j', 8016 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 33445, 36872, 'kFQyHOaSF', 34031, 'a16K6fV7g', 57 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34501, 17164, 'YRJXsXqyFW', 1824, 'xEsG6vBuP8v', 5896 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12667, 24392, 'w', 47926, 'dCa', 49425 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46196, 17710, 'YVa7qSWy2G', 15214, 'oe45CIZn5fMr', 30557 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 25627, 32984, 'fF4aZBFtZw', 17, 'QsD', 39928 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 4957, 46952, 'sMBs1tRTd5W', 21812, 'RFbrM9eSU1', 10674 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 2973, 45174, 'XNKD6CJJOsY', 34763, 'n3kiXxAgf', 43650 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37736, 1391, 'iZWQW7MC9', 37085, 'TCzYZv', 19869 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8284, 47649, 'yqWwG8sL', 3894, '', 46478 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24888, 21595, 'KFPQZh', 24414, 'XM75U', 24414 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28146, 27050, 'QN5iDZoSc5', 45497, 'AFZtW', 9037 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 44075, 17799, 'bx', 1552, 'mKPJ3KLJ4B6i', 21085 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30522, 42762, 'bnFFfHT', 18370, 'L7', 13005 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28477, 48547, 'Hr', 12190, '7Nm5', 28292 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18153, 23590, 'Kw8', 10443, 'nA3xA5LBDrkf', 46920 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29913, 547, 'S', 43110, 'kvLOSuq9mDGI', 31010 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43814, 14126, 'ayfWFYy94U9', 32015, '4Ar64SxL9z', 27200 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40134, 10774, '', 15253, '', 11889 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 11067, 24103, 'UTpz7Sa', 22092, 'kTBUvKmNIyT', 17647 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32925, 22321, 'ZQSshtzVZ', 25380, 'tp7', 19971 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37514, 26868, 'jjJU2qMPz1d', 25005, 'nmbRx', 47480 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 13459, 6464, 'P7N', 18564, 'FkqydV3', 42926 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14508, 43529, '6wLCUP', 21476, 'xzBi60', 23984 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19139, 34060, '1qUIiKg', 19394, 'pLRJC52', 2327 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6529, 18566, 'DAuLK9WJ', 32918, 'Q', 4621 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12752, 44930, 'okQCG4Jw4', 2843, 'RFQz8nCnV', 36806 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 38504, 23264, '6P', 12871, 'IG7y5ZlpbI0', 27676 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15942, 10306, '2C6VcBLgZw', 6864, 'TSRaO', 802 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40298, 12121, 'ehQZ7F7jCNX', 23989, 'k6yQ06U', 29098 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36921, 35562, 'lIdV', 21101, 'i3pzoil5tNV', 16523 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45245, 46218, '2aENGU4Z6', 34707, '8D99', 34950 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 27337, 39293, '07uPiek', 6629, 'OoatKEbqs', 6413 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48635, 40584, 'UHJy2', 36604, 'Q', 18492 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34985, 22863, 'O7', 14882, 'sMBs1tRT', 11578 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 49797, NULL, '2QSHHRD', 21823, '75lpolnGI', 16849 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40881, 41985, 'QSRwdCmu1', 42324, '6e', 59 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 49283, 27036, '', 26808, 'XLEX', 38536 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 42130, NULL, 'WekL', 48108, 'T', 30664 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 17709, 26974, 'Jg6HCFoB2m', 36465, 'k2AI7bScT', 14074 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24634, 21725, 's8', 49073, 'y', 13151 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36044, 6709, 'mDNI9ms32i3', 13724, '6vKdfmx6VjrV', 37668 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43253, 37769, 'Fy12uojoY', 5874, 'E', 39663 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6298, 1936, 'M9o1X', 48682, 'Zeluqx6N', 40563 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30363, 40428, 'PkLzGrzKVh', 38172, 'KZxcujE', 41512 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45917, 12108, '3', 45792, 'oKxs', 45108 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6996, 36468, 'Gc9nqC2o', 15290, 'Npxc', 36303 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24349, 49931, 'hwaM1R', 45616, 'rqc', 4139 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40013, NULL, 'lfnX', 38452, 'mHR9XWmrSK1', 27373 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6407, 21923, '6', 15658, '', 39989 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35886, 17189, '6xpgOw437', 25770, 'Hd', 45975 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40050, 11553, 'yq', 1208, 'W5HlHGNhXE1', 25563 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45988, 38215, 'aYMEHUZaAfB', 38250, 'dcB', 26387 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16262, 44236, 'dKlRuyIJK', 48068, '4SwzhZy7F2Pl', 20321 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41264, 35663, '0rZp6RrNf5', 31371, 'kSfrg', 29002 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 7254, 27271, 'h', 7939, 'v', 27290 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19029, 23617, 'GYP0ao3', 1876, 'nyJ3b', 6309 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 1623, 7041, '', 20281, '4rF29PQY', 17086 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37010, 15227, 's5a', 6615, '3fkD5cs1AA', 7039 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 1113, 2198, '0Xp', 11210, 'xNT1WfqFfSo', 8530 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 47758, 11421, 'Q1InNy02', 4900, 'mJKfUQ', 13151 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40983, 38876, 'Rs1G9', 35645, '31TM', 648 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29696, 24378, 'wz79LuCreyO', 34753, 'xGsnU9tota', 45948 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43769, 21833, 'swSk2ZmQT0F', 34400, 'ehQZ7F', 25760 ) ; +UPDATE tt_4 SET v2 = 'FPjYuAKnAj' WHERE v2 = 'i8' ; +DELETE FROM tt_4 WHERE i3 = 24499 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36718, 13590, 'h', 38370, 'e2ubBJC', 36024 ) ; +DELETE FROM tt_4 WHERE ipkey = 47881 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 17584, 32658, '4QSLSre7u', 6131, 'Sh0Jwkb', 30059 ) ; +UPDATE tt_4 SET i3 = 3420 WHERE ipkey = 31529 ; +DELETE FROM tt_4 WHERE ipkey = 28403 ; +UPDATE tt_4 SET v4 = '' WHERE v4 = 'uWq' ; +DELETE FROM tt_4 WHERE i5 = 45148 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8051, 17591, 'g8U0J2q', 34310, '7iaK', 21220 ) ; +DELETE FROM tt_4 WHERE ipkey = 28782 ; +UPDATE tt_4 SET i1 = 28366 WHERE ipkey = 19329 ; +UPDATE tt_4 SET i1 = 19503 WHERE v4 = 'dXmbMw' ; +UPDATE tt_4 SET ipkey = 9966 WHERE ipkey = 3507 ; +DELETE FROM tt_4 WHERE ipkey = 29621 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15754, 10374, 'JGb', 27645, 'iMlw', 30060 ) ; +DELETE FROM tt_4 WHERE ipkey = 2640 ; +DELETE FROM tt_4 WHERE ipkey = 36572 ; +DELETE FROM tt_4 WHERE ipkey = 45373 ; +UPDATE tt_4 SET v4 = 'rJ3NqRe8wJ' WHERE v4 = '' ; +UPDATE tt_4 SET ipkey = 6862 WHERE ipkey = 8088 ; +UPDATE tt_4 SET i3 = 29160 WHERE v2 = 'M0v' ; +DELETE FROM tt_4 WHERE ipkey = 6821 ; +DELETE FROM tt_4 WHERE v4 = 'r' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 10688, 26534, 'LPCPF9IveR', 9166, 'jS2A7d2A', 19628 ) ; +DELETE FROM tt_4 WHERE i3 = 48244 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 38789, 12548, 'nHU', 40722, 'eWcS4m', 44133 ) ; +DELETE FROM tt_4 WHERE ipkey = 37896 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 31033, 23891, 'DpZBP', 30076, '9CDi2', 36751 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 23997, 33331, 'dc', 17694, 'XEWQM9oPWaV', 38455 ) ; +DELETE FROM tt_4 WHERE ipkey = 45649 ; +DELETE FROM tt_4 WHERE i5 = 49198 ; +DELETE FROM tt_4 WHERE i1 = 19220 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41438, 18698, 'w9PBM5', 14460, 'mQ1', 6580 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32329, 38480, 'Ee', 6341, 'C3zCltQR', 16923 ) ; +DELETE FROM tt_4 WHERE i1 = 14715 ; +UPDATE tt_4 SET i3 = 26962 WHERE i1 = 1280 ; +DELETE FROM tt_4 WHERE ipkey = 17737 ; +UPDATE tt_4 SET i5 = 6561 WHERE ipkey = 11586 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16454, 2642, 'kU5NZQQQu', 12717, 'DuY4MPy5vW', 2227 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 33474, 27684, 'aSwNs', 25365, '1CKUVr2HyE', 2734 ) ; +DELETE FROM tt_4 WHERE ipkey = 26040 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20594, 21713, 'XHO', 34946, '', 30573 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9576, 19702, 'ff', 3865, 'ESllm', 20268 ) ; +DELETE FROM tt_4 WHERE v4 = 'LNLcS' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34336, 26979, '8c', 41189, 'Z3cgki66qm', 37121 ) ; +ANALYZE TABLE tt_4 ; +Table Op Msg_type Msg_text +test.tt_4 analyze status OK +DELETE FROM tt_4 WHERE i1 = 35192 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46083, 27186, 'nDcC', 31480, 'O1Q8ArjBa1', 20380 ) ; +UPDATE tt_4 SET i3 = 33578 WHERE v2 = 'Dvqr1wkFZi' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48521, NULL, 'qC', 40353, '', 13932 ) ; +DELETE FROM tt_4 WHERE ipkey = 45740 ; +DELETE FROM tt_4 WHERE ipkey = 37774 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45257, 17709, 'U', 6159, '4ZH', 25261 ) ; +UPDATE tt_4 SET v4 = 'FRF' WHERE v4 = 'fZ' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43861, 24066, '', 36998, 'PPRwY0', 17671 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 4851, 2842, '9', 7246, 'w', 18806 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 27943, 11328, '', 38716, 'gzQiGQD', 32823 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14243, 3978, 'Ma', 30675, '8fXT5tBOfC', 12481 ) ; +UPDATE tt_4 SET v4 = 'h19CNWRM' WHERE v2 = '9j' ; +ALTER TABLE tt_4 MODIFY COLUMN i3 INT(7), LOCK=DEFAULT, ALGORITHM=COPY ; +Warnings: +Warning 1681 Integer display width is deprecated and will be removed in a future release. +UPDATE tt_4 SET i1 = 34023 WHERE ipkey = 25301 ; +DELETE FROM tt_4 WHERE ipkey = 32409 ; +UPDATE tt_4 SET ipkey = 33631 WHERE ipkey = 18487 ; +DELETE FROM tt_4 WHERE ipkey = 38160 ; +UPDATE tt_4 SET v4 = '5u4YCv' WHERE ipkey = 7927 ; +DELETE FROM tt_4 WHERE i3 = 3277 ; +UPDATE tt_4 SET i3 = 36574 WHERE ipkey = 35364 ; +DELETE FROM tt_4 WHERE ipkey = 1440 ; +DELETE FROM tt_4 WHERE i3 = 49019 ; +DELETE FROM tt_4 WHERE ipkey = 48410 ; +DELETE FROM tt_4 WHERE ipkey LIKE '%25375%' ; +DELETE FROM tt_4 WHERE ipkey = 27252 ; +DELETE FROM tt_4 WHERE ipkey = 3382 ; +DELETE FROM tt_4 WHERE v2 = '' ; +DELETE FROM tt_4 WHERE ipkey = 12257 ; +UPDATE tt_4 SET v4 = '5yzOygcrcvr' WHERE ipkey LIKE '%20126%' ; +UPDATE tt_4 SET i1 = 2722 WHERE ipkey = 9861 ; +UPDATE tt_4 SET v2 = 'Olcr' WHERE i5 = 27986 ; +DELETE FROM tt_4 WHERE ipkey IN (10725,12651) ; +DELETE FROM tt_4 WHERE ipkey = 1548 ; +UPDATE tt_4 SET i1 = 27697 WHERE i5 = 28659 ; +UPDATE tt_4 SET i5 = 41582 WHERE ipkey = 49735 ; +DELETE FROM tt_4 WHERE ipkey = 7050 ; +UPDATE tt_4 SET i5 = 10556 WHERE ipkey = 43284 ; +DELETE FROM tt_4 WHERE ipkey = 16138 ; +DELETE FROM tt_4 WHERE ipkey = 19551 ; +UPDATE tt_4 SET v4 = '2g' WHERE ipkey = 47794 ; +DELETE FROM tt_4 WHERE i1 = 17151 ; +UPDATE tt_4 SET v4 = '0XDERmZU' WHERE ipkey = 48453 ; +DELETE FROM tt_4 WHERE i3 = 28565 ; +ALTER TABLE tt_4 DISCARD TABLESPACE ; +DROP TABLE tt_4 ; +CREATE TABLE tt_4 (ipkey INT, i1 INT AUTO_INCREMENT, v2 VARCHAR(11), i3 INT, v4 VARCHAR(12), i5 INT, PRIMARY KEY(ipkey), INDEX tt_4i0(i5, i3 DESC, v2 DESC) , INDEX tt_4i1(i3, i1, v4 ASC) , INDEX tt_4i2(i5, v2, i1) , INDEX tt_4i3(ipkey DESC, i5 ASC, i3 DESC, v4 ASC, v2 DESC) , INDEX tt_4i4(i1 DESC, v2 DESC, v4, i3) ) ENCRYPTION='N' ROW_FORMAT=COMPRESSED ENGINE=InnoDB ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 3996, 40643, '3UpuyZ', 40507, 'vABx6pjGVGit', 9934 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22723, 32292, '1S8xT3', 21969, 'RTl', 31466 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40190, 22356, '', 25688, '3xl932l9RQM5', 26963 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 47065, 31327, 'YIv', 46234, 'L3fMUT', 32812 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22180, 36284, 'i', 1077, 'Y', 24671 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22194, 42243, 'ZD1DWH', 40824, '7S2ii9LodlT', 8396 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20064, 1591, 'gumUU4j', 19803, '4mMOyE', 20341 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37358, 26898, 'qmMU', 46427, 'IGl', 36047 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 23388, 7286, 'w', 46734, 'gw', 33041 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35146, 46405, 'i', 8377, 'zSifdJTI', 30296 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41072, NULL, '', 35139, 'IbPaom', 2364 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20915, 43056, 'kl', 27234, 'I28NQ4', 27927 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15341, 36795, '4o0PR7', 49923, 'GhiuqC', 8773 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 649, NULL, 'Bi', 42231, 'm3jsVLKORC6B', 26416 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16240, 11939, '', 28305, 'bmURJ', 6498 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43830, 34176, '8', 40762, 'yeWEdbgK', 46579 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14510, 25451, 'x', 38758, 'FrMb4aH8b', 1038 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30059, 23990, '6L6B', 8738, '0xq', 39781 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32601, 16119, 'H', 33584, 'Y8h', 19698 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37999, 10970, 'TJyyDsNS', 27973, 'A2BlqOMbQ1', 8636 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12279, 24977, 'ylfnJ', 30261, 'tw7pNcGXE', 26913 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9933, 9949, '7wZA3OLWmV', 2365, '46Qbk16', 12350 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6956, 10733, 'U5usj0', 47179, 'b5Eo', 15401 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14982, 49512, 'Yx', 40952, 'NWspACo', 37081 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29529, 684, '0Xpylgkfn', 22347, 'pBMfkq6qK', 25867 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16514, 5641, '', 31747, 'et4lO5w', 10970 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22806, 5379, 'edP2Xo1', 36524, 'M6XWxS', 45473 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18537, 49681, 'Wa4', 38813, '', 26011 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 13333, 21050, '3ruEjhBFr', 6901, 'xpSv03K1', 28200 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 25917, 17433, 'i8', 22740, 'jW2Qjd', 20809 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 574, 37308, '40hsk80GH5', 27805, 'f', 31078 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 2663, 31505, 'dDL8', 45820, 'SbpZDkDDG', 47080 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35683, 10645, 'XU46v0', 35123, 'Lu', 28083 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19726, 5580, '', 23036, '', 24065 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8882, 31800, 'ar9UALiyr0y', 15075, 'SaxgLKfj', 15381 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9849, 46086, '2WgQE', 11475, '91M', 10462 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 11199, 46803, 'mHYMK', 24778, 'md39Tp59I', 19127 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46509, 36038, 'UPo', 43321, 'A', 38571 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 3863, 8312, 'kzcU5LXpn', 5140, '', 11924 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40926, 9515, 'sSfsBL8Zae', 9961, 'FpGe5z', 25947 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 7482, 12038, 'lF1adqpp', 49998, '5j6EwFhn3Nl', 43902 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9960, 31763, 'qIMg2P9Moc', 32918, 'zT1', 23728 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48921, 27925, 'PopjIARHz', 15204, 'h3kO', 41416 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 10041, 37402, 'v', 15525, 'o2kkoyK', 1826 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18453, 21124, 'yfo', 30887, '', 3520 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30619, 34928, 'z', 21160, '1An', 28049 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28961, 39021, 'ZaQy5', 31573, 'yx', 23545 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37034, 30054, '591Fj8Y5', 39357, 'j', 8016 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 33445, 36872, 'kFQyHOaSF', 34031, 'a16K6fV7g', 57 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34501, 17164, 'YRJXsXqyFW', 1824, 'xEsG6vBuP8v', 5896 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12667, 24392, 'w', 47926, 'dCa', 49425 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46196, 17710, 'YVa7qSWy2G', 15214, 'oe45CIZn5fMr', 30557 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 25627, 32984, 'fF4aZBFtZw', 17, 'QsD', 39928 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 4957, 46952, 'sMBs1tRTd5W', 21812, 'RFbrM9eSU1', 10674 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 2973, 45174, 'XNKD6CJJOsY', 34763, 'n3kiXxAgf', 43650 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37736, 1391, 'iZWQW7MC9', 37085, 'TCzYZv', 19869 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8284, 47649, 'yqWwG8sL', 3894, '', 46478 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24888, 21595, 'KFPQZh', 24414, 'XM75U', 24414 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28146, 27050, 'QN5iDZoSc5', 45497, 'AFZtW', 9037 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 44075, 17799, 'bx', 1552, 'mKPJ3KLJ4B6i', 21085 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30522, 42762, 'bnFFfHT', 18370, 'L7', 13005 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28477, 48547, 'Hr', 12190, '7Nm5', 28292 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18153, 23590, 'Kw8', 10443, 'nA3xA5LBDrkf', 46920 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29913, 547, 'S', 43110, 'kvLOSuq9mDGI', 31010 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43814, 14126, 'ayfWFYy94U9', 32015, '4Ar64SxL9z', 27200 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40134, 10774, '', 15253, '', 11889 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 11067, 24103, 'UTpz7Sa', 22092, 'kTBUvKmNIyT', 17647 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32925, 22321, 'ZQSshtzVZ', 25380, 'tp7', 19971 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37514, 26868, 'jjJU2qMPz1d', 25005, 'nmbRx', 47480 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 13459, 6464, 'P7N', 18564, 'FkqydV3', 42926 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14508, 43529, '6wLCUP', 21476, 'xzBi60', 23984 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19139, 34060, '1qUIiKg', 19394, 'pLRJC52', 2327 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6529, 18566, 'DAuLK9WJ', 32918, 'Q', 4621 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12752, 44930, 'okQCG4Jw4', 2843, 'RFQz8nCnV', 36806 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 38504, 23264, '6P', 12871, 'IG7y5ZlpbI0', 27676 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15942, 10306, '2C6VcBLgZw', 6864, 'TSRaO', 802 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40298, 12121, 'ehQZ7F7jCNX', 23989, 'k6yQ06U', 29098 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36921, 35562, 'lIdV', 21101, 'i3pzoil5tNV', 16523 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45245, 46218, '2aENGU4Z6', 34707, '8D99', 34950 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 27337, 39293, '07uPiek', 6629, 'OoatKEbqs', 6413 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48635, 40584, 'UHJy2', 36604, 'Q', 18492 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34985, 22863, 'O7', 14882, 'sMBs1tRT', 11578 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 49797, NULL, '2QSHHRD', 21823, '75lpolnGI', 16849 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40881, 41985, 'QSRwdCmu1', 42324, '6e', 59 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 49283, 27036, '', 26808, 'XLEX', 38536 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 42130, NULL, 'WekL', 48108, 'T', 30664 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 17709, 26974, 'Jg6HCFoB2m', 36465, 'k2AI7bScT', 14074 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24634, 21725, 's8', 49073, 'y', 13151 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36044, 6709, 'mDNI9ms32i3', 13724, '6vKdfmx6VjrV', 37668 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43253, 37769, 'Fy12uojoY', 5874, 'E', 39663 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6298, 1936, 'M9o1X', 48682, 'Zeluqx6N', 40563 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30363, 40428, 'PkLzGrzKVh', 38172, 'KZxcujE', 41512 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45917, 12108, '3', 45792, 'oKxs', 45108 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6996, 36468, 'Gc9nqC2o', 15290, 'Npxc', 36303 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24349, 49931, 'hwaM1R', 45616, 'rqc', 4139 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40013, NULL, 'lfnX', 38452, 'mHR9XWmrSK1', 27373 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6407, 21923, '6', 15658, '', 39989 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35886, 17189, '6xpgOw437', 25770, 'Hd', 45975 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40050, 11553, 'yq', 1208, 'W5HlHGNhXE1', 25563 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45988, 38215, 'aYMEHUZaAfB', 38250, 'dcB', 26387 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16262, 44236, 'dKlRuyIJK', 48068, '4SwzhZy7F2Pl', 20321 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41264, 35663, '0rZp6RrNf5', 31371, 'kSfrg', 29002 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 7254, 27271, 'h', 7939, 'v', 27290 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19029, 23617, 'GYP0ao3', 1876, 'nyJ3b', 6309 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 1623, 7041, '', 20281, '4rF29PQY', 17086 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37010, 15227, 's5a', 6615, '3fkD5cs1AA', 7039 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 1113, 2198, '0Xp', 11210, 'xNT1WfqFfSo', 8530 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 47758, 11421, 'Q1InNy02', 4900, 'mJKfUQ', 13151 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40983, 38876, 'Rs1G9', 35645, '31TM', 648 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29696, 24378, 'wz79LuCreyO', 34753, 'xGsnU9tota', 45948 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43769, 21833, 'swSk2ZmQT0F', 34400, 'ehQZ7F', 25760 ) ; +UPDATE tt_4 SET v2 = 'FPjYuAKnAj' WHERE v2 = 'i8' ; +DELETE FROM tt_4 WHERE i3 = 24499 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36718, 13590, 'h', 38370, 'e2ubBJC', 36024 ) ; +DELETE FROM tt_4 WHERE ipkey = 47881 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 17584, 32658, '4QSLSre7u', 6131, 'Sh0Jwkb', 30059 ) ; +UPDATE tt_4 SET i3 = 3420 WHERE ipkey = 31529 ; +DELETE FROM tt_4 WHERE ipkey = 28403 ; +UPDATE tt_4 SET v4 = '' WHERE v4 = 'uWq' ; +DELETE FROM tt_4 WHERE i5 = 45148 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8051, 17591, 'g8U0J2q', 34310, '7iaK', 21220 ) ; +DELETE FROM tt_4 WHERE ipkey = 28782 ; +UPDATE tt_4 SET i1 = 28366 WHERE ipkey = 19329 ; +UPDATE tt_4 SET i1 = 19503 WHERE v4 = 'dXmbMw' ; +UPDATE tt_4 SET ipkey = 9966 WHERE ipkey = 3507 ; +DELETE FROM tt_4 WHERE ipkey = 29621 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15754, 10374, 'JGb', 27645, 'iMlw', 30060 ) ; +DELETE FROM tt_4 WHERE ipkey = 2640 ; +DELETE FROM tt_4 WHERE ipkey = 36572 ; +DELETE FROM tt_4 WHERE ipkey = 45373 ; +UPDATE tt_4 SET v4 = 'rJ3NqRe8wJ' WHERE v4 = '' ; +UPDATE tt_4 SET ipkey = 6862 WHERE ipkey = 8088 ; +UPDATE tt_4 SET i3 = 29160 WHERE v2 = 'M0v' ; +DELETE FROM tt_4 WHERE ipkey = 6821 ; +DELETE FROM tt_4 WHERE v4 = 'r' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 10688, 26534, 'LPCPF9IveR', 9166, 'jS2A7d2A', 19628 ) ; +DELETE FROM tt_4 WHERE i3 = 48244 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 38789, 12548, 'nHU', 40722, 'eWcS4m', 44133 ) ; +DELETE FROM tt_4 WHERE ipkey = 37896 ; +ALTER TABLE tt_4 COMPRESSION= 'none' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 31033, 23891, 'DpZBP', 30076, '9CDi2', 36751 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 23997, 33331, 'dc', 17694, 'XEWQM9oPWaV', 38455 ) ; +DELETE FROM tt_4 WHERE ipkey = 45649 ; +DELETE FROM tt_4 WHERE i5 = 49198 ; +DELETE FROM tt_4 WHERE i1 = 19220 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41438, 18698, 'w9PBM5', 14460, 'mQ1', 6580 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32329, 38480, 'Ee', 6341, 'C3zCltQR', 16923 ) ; +DELETE FROM tt_4 WHERE i1 = 14715 ; +UPDATE tt_4 SET i3 = 26962 WHERE i1 = 1280 ; +DELETE FROM tt_4 WHERE ipkey = 17737 ; +UPDATE tt_4 SET i5 = 6561 WHERE ipkey = 11586 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16454, 2642, 'kU5NZQQQu', 12717, 'DuY4MPy5vW', 2227 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 33474, 27684, 'aSwNs', 25365, '1CKUVr2HyE', 2734 ) ; +DELETE FROM tt_4 WHERE ipkey = 26040 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20594, 21713, 'XHO', 34946, '', 30573 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9576, 19702, 'ff', 3865, 'ESllm', 20268 ) ; +DELETE FROM tt_4 WHERE v4 = 'LNLcS' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34336, 26979, '8c', 41189, 'Z3cgki66qm', 37121 ) ; +ANALYZE TABLE tt_4 ; +Table Op Msg_type Msg_text +test.tt_4 analyze status OK +DELETE FROM tt_4 WHERE i1 = 35192 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46083, 27186, 'nDcC', 31480, 'O1Q8ArjBa1', 20380 ) ; +UPDATE tt_4 SET i3 = 33578 WHERE v2 = 'Dvqr1wkFZi' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48521, NULL, 'qC', 40353, '', 13932 ) ; +DELETE FROM tt_4 WHERE ipkey = 45740 ; +DELETE FROM tt_4 WHERE ipkey = 37774 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45257, 17709, 'U', 6159, '4ZH', 25261 ) ; +UPDATE tt_4 SET v4 = 'FRF' WHERE v4 = 'fZ' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43861, 24066, '', 36998, 'PPRwY0', 17671 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 4851, 2842, '9', 7246, 'w', 18806 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 27943, 11328, '', 38716, 'gzQiGQD', 32823 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14243, 3978, 'Ma', 30675, '8fXT5tBOfC', 12481 ) ; +UPDATE tt_4 SET v4 = 'h19CNWRM' WHERE v2 = '9j' ; +ALTER TABLE tt_4 MODIFY COLUMN i3 INT(7), LOCK=DEFAULT, ALGORITHM=COPY ; +Warnings: +Warning 1681 Integer display width is deprecated and will be removed in a future release. +UPDATE tt_4 SET i1 = 34023 WHERE ipkey = 25301 ; +DELETE FROM tt_4 WHERE ipkey = 32409 ; +UPDATE tt_4 SET ipkey = 33631 WHERE ipkey = 18487 ; +DELETE FROM tt_4 WHERE ipkey = 38160 ; +UPDATE tt_4 SET v4 = '5u4YCv' WHERE ipkey = 7927 ; +DELETE FROM tt_4 WHERE i3 = 3277 ; +UPDATE tt_4 SET i3 = 36574 WHERE ipkey = 35364 ; +DELETE FROM tt_4 WHERE ipkey = 1440 ; +DELETE FROM tt_4 WHERE i3 = 49019 ; +DELETE FROM tt_4 WHERE ipkey = 48410 ; +DELETE FROM tt_4 WHERE ipkey LIKE '%25375%' ; +DELETE FROM tt_4 WHERE ipkey = 27252 ; +DELETE FROM tt_4 WHERE ipkey = 3382 ; +DELETE FROM tt_4 WHERE v2 = '' ; +DELETE FROM tt_4 WHERE ipkey = 12257 ; +UPDATE tt_4 SET v4 = '5yzOygcrcvr' WHERE ipkey LIKE '%20126%' ; +UPDATE tt_4 SET i1 = 2722 WHERE ipkey = 9861 ; +UPDATE tt_4 SET v2 = 'Olcr' WHERE i5 = 27986 ; +DELETE FROM tt_4 WHERE ipkey IN (10725,12651) ; +DELETE FROM tt_4 WHERE ipkey = 1548 ; +UPDATE tt_4 SET i1 = 27697 WHERE i5 = 28659 ; +UPDATE tt_4 SET i5 = 41582 WHERE ipkey = 49735 ; +DELETE FROM tt_4 WHERE ipkey = 7050 ; +UPDATE tt_4 SET i5 = 10556 WHERE ipkey = 43284 ; +DELETE FROM tt_4 WHERE ipkey = 16138 ; +DELETE FROM tt_4 WHERE ipkey = 19551 ; +UPDATE tt_4 SET v4 = '2g' WHERE ipkey = 47794 ; +DELETE FROM tt_4 WHERE i1 = 17151 ; +UPDATE tt_4 SET v4 = '0XDERmZU' WHERE ipkey = 48453 ; +DELETE FROM tt_4 WHERE i3 = 28565 ; +ALTER TABLE tt_4 DISCARD TABLESPACE ; +DROP TABLE tt_4 ; +CREATE TABLE t1(a INT) ENGINE=innodb; +ALTER TABLE t1 DISCARD TABLESPACE; +DROP TABLE t1; diff --git a/mysql-test/suite/innodb/t/discard_drop_tablespace.test b/mysql-test/suite/innodb/t/discard_drop_tablespace.test new file mode 100644 index 000000000000..37aa2c3eb31d --- /dev/null +++ b/mysql-test/suite/innodb/t/discard_drop_tablespace.test @@ -0,0 +1,431 @@ +--echo # +--echo # Bug#107207 Assertion Failure buf0buf.cc:4318:page_size.equals_to(space_page_size) +--echo # +CREATE TABLE tt_4 (ipkey INT, i1 INT AUTO_INCREMENT, v2 VARCHAR(11), i3 INT, v4 VARCHAR(12), i5 INT, PRIMARY KEY(ipkey), INDEX tt_4i0(i5, i3 DESC, v2 DESC) , INDEX tt_4i1(i3, i1, v4 ASC) , INDEX tt_4i2(i5, v2, i1) , INDEX tt_4i3(ipkey DESC, i5 ASC, i3 DESC, v4 ASC, v2 DESC) , INDEX tt_4i4(i1 DESC, v2 DESC, v4, i3) ) ENCRYPTION='N' ENGINE=InnoDB ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 3996, 40643, '3UpuyZ', 40507, 'vABx6pjGVGit', 9934 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22723, 32292, '1S8xT3', 21969, 'RTl', 31466 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40190, 22356, '', 25688, '3xl932l9RQM5', 26963 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 47065, 31327, 'YIv', 46234, 'L3fMUT', 32812 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22180, 36284, 'i', 1077, 'Y', 24671 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22194, 42243, 'ZD1DWH', 40824, '7S2ii9LodlT', 8396 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20064, 1591, 'gumUU4j', 19803, '4mMOyE', 20341 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37358, 26898, 'qmMU', 46427, 'IGl', 36047 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 23388, 7286, 'w', 46734, 'gw', 33041 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35146, 46405, 'i', 8377, 'zSifdJTI', 30296 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41072, NULL, '', 35139, 'IbPaom', 2364 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20915, 43056, 'kl', 27234, 'I28NQ4', 27927 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15341, 36795, '4o0PR7', 49923, 'GhiuqC', 8773 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 649, NULL, 'Bi', 42231, 'm3jsVLKORC6B', 26416 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16240, 11939, '', 28305, 'bmURJ', 6498 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43830, 34176, '8', 40762, 'yeWEdbgK', 46579 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14510, 25451, 'x', 38758, 'FrMb4aH8b', 1038 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30059, 23990, '6L6B', 8738, '0xq', 39781 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32601, 16119, 'H', 33584, 'Y8h', 19698 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37999, 10970, 'TJyyDsNS', 27973, 'A2BlqOMbQ1', 8636 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12279, 24977, 'ylfnJ', 30261, 'tw7pNcGXE', 26913 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9933, 9949, '7wZA3OLWmV', 2365, '46Qbk16', 12350 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6956, 10733, 'U5usj0', 47179, 'b5Eo', 15401 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14982, 49512, 'Yx', 40952, 'NWspACo', 37081 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29529, 684, '0Xpylgkfn', 22347, 'pBMfkq6qK', 25867 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16514, 5641, '', 31747, 'et4lO5w', 10970 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22806, 5379, 'edP2Xo1', 36524, 'M6XWxS', 45473 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18537, 49681, 'Wa4', 38813, '', 26011 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 13333, 21050, '3ruEjhBFr', 6901, 'xpSv03K1', 28200 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 25917, 17433, 'i8', 22740, 'jW2Qjd', 20809 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 574, 37308, '40hsk80GH5', 27805, 'f', 31078 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 2663, 31505, 'dDL8', 45820, 'SbpZDkDDG', 47080 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35683, 10645, 'XU46v0', 35123, 'Lu', 28083 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19726, 5580, '', 23036, '', 24065 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8882, 31800, 'ar9UALiyr0y', 15075, 'SaxgLKfj', 15381 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9849, 46086, '2WgQE', 11475, '91M', 10462 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 11199, 46803, 'mHYMK', 24778, 'md39Tp59I', 19127 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46509, 36038, 'UPo', 43321, 'A', 38571 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 3863, 8312, 'kzcU5LXpn', 5140, '', 11924 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40926, 9515, 'sSfsBL8Zae', 9961, 'FpGe5z', 25947 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 7482, 12038, 'lF1adqpp', 49998, '5j6EwFhn3Nl', 43902 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9960, 31763, 'qIMg2P9Moc', 32918, 'zT1', 23728 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48921, 27925, 'PopjIARHz', 15204, 'h3kO', 41416 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 10041, 37402, 'v', 15525, 'o2kkoyK', 1826 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18453, 21124, 'yfo', 30887, '', 3520 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30619, 34928, 'z', 21160, '1An', 28049 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28961, 39021, 'ZaQy5', 31573, 'yx', 23545 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37034, 30054, '591Fj8Y5', 39357, 'j', 8016 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 33445, 36872, 'kFQyHOaSF', 34031, 'a16K6fV7g', 57 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34501, 17164, 'YRJXsXqyFW', 1824, 'xEsG6vBuP8v', 5896 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12667, 24392, 'w', 47926, 'dCa', 49425 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46196, 17710, 'YVa7qSWy2G', 15214, 'oe45CIZn5fMr', 30557 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 25627, 32984, 'fF4aZBFtZw', 17, 'QsD', 39928 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 4957, 46952, 'sMBs1tRTd5W', 21812, 'RFbrM9eSU1', 10674 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 2973, 45174, 'XNKD6CJJOsY', 34763, 'n3kiXxAgf', 43650 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37736, 1391, 'iZWQW7MC9', 37085, 'TCzYZv', 19869 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8284, 47649, 'yqWwG8sL', 3894, '', 46478 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24888, 21595, 'KFPQZh', 24414, 'XM75U', 24414 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28146, 27050, 'QN5iDZoSc5', 45497, 'AFZtW', 9037 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 44075, 17799, 'bx', 1552, 'mKPJ3KLJ4B6i', 21085 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30522, 42762, 'bnFFfHT', 18370, 'L7', 13005 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28477, 48547, 'Hr', 12190, '7Nm5', 28292 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18153, 23590, 'Kw8', 10443, 'nA3xA5LBDrkf', 46920 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29913, 547, 'S', 43110, 'kvLOSuq9mDGI', 31010 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43814, 14126, 'ayfWFYy94U9', 32015, '4Ar64SxL9z', 27200 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40134, 10774, '', 15253, '', 11889 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 11067, 24103, 'UTpz7Sa', 22092, 'kTBUvKmNIyT', 17647 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32925, 22321, 'ZQSshtzVZ', 25380, 'tp7', 19971 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37514, 26868, 'jjJU2qMPz1d', 25005, 'nmbRx', 47480 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 13459, 6464, 'P7N', 18564, 'FkqydV3', 42926 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14508, 43529, '6wLCUP', 21476, 'xzBi60', 23984 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19139, 34060, '1qUIiKg', 19394, 'pLRJC52', 2327 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6529, 18566, 'DAuLK9WJ', 32918, 'Q', 4621 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12752, 44930, 'okQCG4Jw4', 2843, 'RFQz8nCnV', 36806 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 38504, 23264, '6P', 12871, 'IG7y5ZlpbI0', 27676 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15942, 10306, '2C6VcBLgZw', 6864, 'TSRaO', 802 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40298, 12121, 'ehQZ7F7jCNX', 23989, 'k6yQ06U', 29098 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36921, 35562, 'lIdV', 21101, 'i3pzoil5tNV', 16523 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45245, 46218, '2aENGU4Z6', 34707, '8D99', 34950 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 27337, 39293, '07uPiek', 6629, 'OoatKEbqs', 6413 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48635, 40584, 'UHJy2', 36604, 'Q', 18492 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34985, 22863, 'O7', 14882, 'sMBs1tRT', 11578 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 49797, NULL, '2QSHHRD', 21823, '75lpolnGI', 16849 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40881, 41985, 'QSRwdCmu1', 42324, '6e', 59 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 49283, 27036, '', 26808, 'XLEX', 38536 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 42130, NULL, 'WekL', 48108, 'T', 30664 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 17709, 26974, 'Jg6HCFoB2m', 36465, 'k2AI7bScT', 14074 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24634, 21725, 's8', 49073, 'y', 13151 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36044, 6709, 'mDNI9ms32i3', 13724, '6vKdfmx6VjrV', 37668 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43253, 37769, 'Fy12uojoY', 5874, 'E', 39663 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6298, 1936, 'M9o1X', 48682, 'Zeluqx6N', 40563 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30363, 40428, 'PkLzGrzKVh', 38172, 'KZxcujE', 41512 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45917, 12108, '3', 45792, 'oKxs', 45108 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6996, 36468, 'Gc9nqC2o', 15290, 'Npxc', 36303 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24349, 49931, 'hwaM1R', 45616, 'rqc', 4139 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40013, NULL, 'lfnX', 38452, 'mHR9XWmrSK1', 27373 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6407, 21923, '6', 15658, '', 39989 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35886, 17189, '6xpgOw437', 25770, 'Hd', 45975 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40050, 11553, 'yq', 1208, 'W5HlHGNhXE1', 25563 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45988, 38215, 'aYMEHUZaAfB', 38250, 'dcB', 26387 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16262, 44236, 'dKlRuyIJK', 48068, '4SwzhZy7F2Pl', 20321 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41264, 35663, '0rZp6RrNf5', 31371, 'kSfrg', 29002 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 7254, 27271, 'h', 7939, 'v', 27290 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19029, 23617, 'GYP0ao3', 1876, 'nyJ3b', 6309 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 1623, 7041, '', 20281, '4rF29PQY', 17086 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37010, 15227, 's5a', 6615, '3fkD5cs1AA', 7039 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 1113, 2198, '0Xp', 11210, 'xNT1WfqFfSo', 8530 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 47758, 11421, 'Q1InNy02', 4900, 'mJKfUQ', 13151 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40983, 38876, 'Rs1G9', 35645, '31TM', 648 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29696, 24378, 'wz79LuCreyO', 34753, 'xGsnU9tota', 45948 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43769, 21833, 'swSk2ZmQT0F', 34400, 'ehQZ7F', 25760 ) ; +UPDATE tt_4 SET v2 = 'FPjYuAKnAj' WHERE v2 = 'i8' ; +DELETE FROM tt_4 WHERE i3 = 24499 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36718, 13590, 'h', 38370, 'e2ubBJC', 36024 ) ; +DELETE FROM tt_4 WHERE ipkey = 47881 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 17584, 32658, '4QSLSre7u', 6131, 'Sh0Jwkb', 30059 ) ; +UPDATE tt_4 SET i3 = 3420 WHERE ipkey = 31529 ; +DELETE FROM tt_4 WHERE ipkey = 28403 ; +UPDATE tt_4 SET v4 = '' WHERE v4 = 'uWq' ; +DELETE FROM tt_4 WHERE i5 = 45148 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8051, 17591, 'g8U0J2q', 34310, '7iaK', 21220 ) ; +DELETE FROM tt_4 WHERE ipkey = 28782 ; +UPDATE tt_4 SET i1 = 28366 WHERE ipkey = 19329 ; +UPDATE tt_4 SET i1 = 19503 WHERE v4 = 'dXmbMw' ; +UPDATE tt_4 SET ipkey = 9966 WHERE ipkey = 3507 ; +DELETE FROM tt_4 WHERE ipkey = 29621 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15754, 10374, 'JGb', 27645, 'iMlw', 30060 ) ; +DELETE FROM tt_4 WHERE ipkey = 2640 ; +DELETE FROM tt_4 WHERE ipkey = 36572 ; +DELETE FROM tt_4 WHERE ipkey = 45373 ; +UPDATE tt_4 SET v4 = 'rJ3NqRe8wJ' WHERE v4 = '' ; +UPDATE tt_4 SET ipkey = 6862 WHERE ipkey = 8088 ; +UPDATE tt_4 SET i3 = 29160 WHERE v2 = 'M0v' ; +DELETE FROM tt_4 WHERE ipkey = 6821 ; +DELETE FROM tt_4 WHERE v4 = 'r' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 10688, 26534, 'LPCPF9IveR', 9166, 'jS2A7d2A', 19628 ) ; +DELETE FROM tt_4 WHERE i3 = 48244 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 38789, 12548, 'nHU', 40722, 'eWcS4m', 44133 ) ; +DELETE FROM tt_4 WHERE ipkey = 37896 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 31033, 23891, 'DpZBP', 30076, '9CDi2', 36751 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 23997, 33331, 'dc', 17694, 'XEWQM9oPWaV', 38455 ) ; +DELETE FROM tt_4 WHERE ipkey = 45649 ; +DELETE FROM tt_4 WHERE i5 = 49198 ; +DELETE FROM tt_4 WHERE i1 = 19220 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41438, 18698, 'w9PBM5', 14460, 'mQ1', 6580 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32329, 38480, 'Ee', 6341, 'C3zCltQR', 16923 ) ; +DELETE FROM tt_4 WHERE i1 = 14715 ; +UPDATE tt_4 SET i3 = 26962 WHERE i1 = 1280 ; +DELETE FROM tt_4 WHERE ipkey = 17737 ; +UPDATE tt_4 SET i5 = 6561 WHERE ipkey = 11586 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16454, 2642, 'kU5NZQQQu', 12717, 'DuY4MPy5vW', 2227 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 33474, 27684, 'aSwNs', 25365, '1CKUVr2HyE', 2734 ) ; +DELETE FROM tt_4 WHERE ipkey = 26040 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20594, 21713, 'XHO', 34946, '', 30573 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9576, 19702, 'ff', 3865, 'ESllm', 20268 ) ; +DELETE FROM tt_4 WHERE v4 = 'LNLcS' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34336, 26979, '8c', 41189, 'Z3cgki66qm', 37121 ) ; +ANALYZE TABLE tt_4 ; +DELETE FROM tt_4 WHERE i1 = 35192 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46083, 27186, 'nDcC', 31480, 'O1Q8ArjBa1', 20380 ) ; +UPDATE tt_4 SET i3 = 33578 WHERE v2 = 'Dvqr1wkFZi' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48521, NULL, 'qC', 40353, '', 13932 ) ; +DELETE FROM tt_4 WHERE ipkey = 45740 ; +DELETE FROM tt_4 WHERE ipkey = 37774 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45257, 17709, 'U', 6159, '4ZH', 25261 ) ; +UPDATE tt_4 SET v4 = 'FRF' WHERE v4 = 'fZ' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43861, 24066, '', 36998, 'PPRwY0', 17671 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 4851, 2842, '9', 7246, 'w', 18806 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 27943, 11328, '', 38716, 'gzQiGQD', 32823 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14243, 3978, 'Ma', 30675, '8fXT5tBOfC', 12481 ) ; +UPDATE tt_4 SET v4 = 'h19CNWRM' WHERE v2 = '9j' ; +ALTER TABLE tt_4 MODIFY COLUMN i3 INT(7), LOCK=DEFAULT, ALGORITHM=COPY ; +UPDATE tt_4 SET i1 = 34023 WHERE ipkey = 25301 ; +DELETE FROM tt_4 WHERE ipkey = 32409 ; +UPDATE tt_4 SET ipkey = 33631 WHERE ipkey = 18487 ; +DELETE FROM tt_4 WHERE ipkey = 38160 ; +UPDATE tt_4 SET v4 = '5u4YCv' WHERE ipkey = 7927 ; +DELETE FROM tt_4 WHERE i3 = 3277 ; +UPDATE tt_4 SET i3 = 36574 WHERE ipkey = 35364 ; +DELETE FROM tt_4 WHERE ipkey = 1440 ; +DELETE FROM tt_4 WHERE i3 = 49019 ; +DELETE FROM tt_4 WHERE ipkey = 48410 ; +DELETE FROM tt_4 WHERE ipkey LIKE '%25375%' ; +DELETE FROM tt_4 WHERE ipkey = 27252 ; +DELETE FROM tt_4 WHERE ipkey = 3382 ; +DELETE FROM tt_4 WHERE v2 = '' ; +DELETE FROM tt_4 WHERE ipkey = 12257 ; +UPDATE tt_4 SET v4 = '5yzOygcrcvr' WHERE ipkey LIKE '%20126%' ; +UPDATE tt_4 SET i1 = 2722 WHERE ipkey = 9861 ; +UPDATE tt_4 SET v2 = 'Olcr' WHERE i5 = 27986 ; +DELETE FROM tt_4 WHERE ipkey IN (10725,12651) ; +DELETE FROM tt_4 WHERE ipkey = 1548 ; +UPDATE tt_4 SET i1 = 27697 WHERE i5 = 28659 ; +UPDATE tt_4 SET i5 = 41582 WHERE ipkey = 49735 ; +DELETE FROM tt_4 WHERE ipkey = 7050 ; +UPDATE tt_4 SET i5 = 10556 WHERE ipkey = 43284 ; +DELETE FROM tt_4 WHERE ipkey = 16138 ; +DELETE FROM tt_4 WHERE ipkey = 19551 ; +UPDATE tt_4 SET v4 = '2g' WHERE ipkey = 47794 ; +DELETE FROM tt_4 WHERE i1 = 17151 ; +UPDATE tt_4 SET v4 = '0XDERmZU' WHERE ipkey = 48453 ; +DELETE FROM tt_4 WHERE i3 = 28565 ; +ALTER TABLE tt_4 DISCARD TABLESPACE ; +DROP TABLE tt_4 ; + +CREATE TABLE tt_4 (ipkey INT, i1 INT AUTO_INCREMENT, v2 VARCHAR(11), i3 INT, v4 VARCHAR(12), i5 INT, PRIMARY KEY(ipkey), INDEX tt_4i0(i5, i3 DESC, v2 DESC) , INDEX tt_4i1(i3, i1, v4 ASC) , INDEX tt_4i2(i5, v2, i1) , INDEX tt_4i3(ipkey DESC, i5 ASC, i3 DESC, v4 ASC, v2 DESC) , INDEX tt_4i4(i1 DESC, v2 DESC, v4, i3) ) ENCRYPTION='N' ROW_FORMAT=COMPRESSED ENGINE=InnoDB ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 3996, 40643, '3UpuyZ', 40507, 'vABx6pjGVGit', 9934 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22723, 32292, '1S8xT3', 21969, 'RTl', 31466 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40190, 22356, '', 25688, '3xl932l9RQM5', 26963 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 47065, 31327, 'YIv', 46234, 'L3fMUT', 32812 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22180, 36284, 'i', 1077, 'Y', 24671 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22194, 42243, 'ZD1DWH', 40824, '7S2ii9LodlT', 8396 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20064, 1591, 'gumUU4j', 19803, '4mMOyE', 20341 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37358, 26898, 'qmMU', 46427, 'IGl', 36047 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 23388, 7286, 'w', 46734, 'gw', 33041 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35146, 46405, 'i', 8377, 'zSifdJTI', 30296 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41072, NULL, '', 35139, 'IbPaom', 2364 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20915, 43056, 'kl', 27234, 'I28NQ4', 27927 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15341, 36795, '4o0PR7', 49923, 'GhiuqC', 8773 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 649, NULL, 'Bi', 42231, 'm3jsVLKORC6B', 26416 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16240, 11939, '', 28305, 'bmURJ', 6498 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43830, 34176, '8', 40762, 'yeWEdbgK', 46579 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14510, 25451, 'x', 38758, 'FrMb4aH8b', 1038 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30059, 23990, '6L6B', 8738, '0xq', 39781 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32601, 16119, 'H', 33584, 'Y8h', 19698 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37999, 10970, 'TJyyDsNS', 27973, 'A2BlqOMbQ1', 8636 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12279, 24977, 'ylfnJ', 30261, 'tw7pNcGXE', 26913 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9933, 9949, '7wZA3OLWmV', 2365, '46Qbk16', 12350 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6956, 10733, 'U5usj0', 47179, 'b5Eo', 15401 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14982, 49512, 'Yx', 40952, 'NWspACo', 37081 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29529, 684, '0Xpylgkfn', 22347, 'pBMfkq6qK', 25867 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16514, 5641, '', 31747, 'et4lO5w', 10970 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 22806, 5379, 'edP2Xo1', 36524, 'M6XWxS', 45473 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18537, 49681, 'Wa4', 38813, '', 26011 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 13333, 21050, '3ruEjhBFr', 6901, 'xpSv03K1', 28200 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 25917, 17433, 'i8', 22740, 'jW2Qjd', 20809 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 574, 37308, '40hsk80GH5', 27805, 'f', 31078 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 2663, 31505, 'dDL8', 45820, 'SbpZDkDDG', 47080 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35683, 10645, 'XU46v0', 35123, 'Lu', 28083 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19726, 5580, '', 23036, '', 24065 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8882, 31800, 'ar9UALiyr0y', 15075, 'SaxgLKfj', 15381 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9849, 46086, '2WgQE', 11475, '91M', 10462 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 11199, 46803, 'mHYMK', 24778, 'md39Tp59I', 19127 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46509, 36038, 'UPo', 43321, 'A', 38571 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 3863, 8312, 'kzcU5LXpn', 5140, '', 11924 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40926, 9515, 'sSfsBL8Zae', 9961, 'FpGe5z', 25947 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 7482, 12038, 'lF1adqpp', 49998, '5j6EwFhn3Nl', 43902 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9960, 31763, 'qIMg2P9Moc', 32918, 'zT1', 23728 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48921, 27925, 'PopjIARHz', 15204, 'h3kO', 41416 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 10041, 37402, 'v', 15525, 'o2kkoyK', 1826 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18453, 21124, 'yfo', 30887, '', 3520 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30619, 34928, 'z', 21160, '1An', 28049 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28961, 39021, 'ZaQy5', 31573, 'yx', 23545 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37034, 30054, '591Fj8Y5', 39357, 'j', 8016 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 33445, 36872, 'kFQyHOaSF', 34031, 'a16K6fV7g', 57 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34501, 17164, 'YRJXsXqyFW', 1824, 'xEsG6vBuP8v', 5896 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12667, 24392, 'w', 47926, 'dCa', 49425 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46196, 17710, 'YVa7qSWy2G', 15214, 'oe45CIZn5fMr', 30557 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 25627, 32984, 'fF4aZBFtZw', 17, 'QsD', 39928 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 4957, 46952, 'sMBs1tRTd5W', 21812, 'RFbrM9eSU1', 10674 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 2973, 45174, 'XNKD6CJJOsY', 34763, 'n3kiXxAgf', 43650 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37736, 1391, 'iZWQW7MC9', 37085, 'TCzYZv', 19869 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8284, 47649, 'yqWwG8sL', 3894, '', 46478 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24888, 21595, 'KFPQZh', 24414, 'XM75U', 24414 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28146, 27050, 'QN5iDZoSc5', 45497, 'AFZtW', 9037 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 44075, 17799, 'bx', 1552, 'mKPJ3KLJ4B6i', 21085 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30522, 42762, 'bnFFfHT', 18370, 'L7', 13005 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 28477, 48547, 'Hr', 12190, '7Nm5', 28292 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 18153, 23590, 'Kw8', 10443, 'nA3xA5LBDrkf', 46920 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29913, 547, 'S', 43110, 'kvLOSuq9mDGI', 31010 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43814, 14126, 'ayfWFYy94U9', 32015, '4Ar64SxL9z', 27200 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40134, 10774, '', 15253, '', 11889 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 11067, 24103, 'UTpz7Sa', 22092, 'kTBUvKmNIyT', 17647 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32925, 22321, 'ZQSshtzVZ', 25380, 'tp7', 19971 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37514, 26868, 'jjJU2qMPz1d', 25005, 'nmbRx', 47480 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 13459, 6464, 'P7N', 18564, 'FkqydV3', 42926 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14508, 43529, '6wLCUP', 21476, 'xzBi60', 23984 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19139, 34060, '1qUIiKg', 19394, 'pLRJC52', 2327 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6529, 18566, 'DAuLK9WJ', 32918, 'Q', 4621 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 12752, 44930, 'okQCG4Jw4', 2843, 'RFQz8nCnV', 36806 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 38504, 23264, '6P', 12871, 'IG7y5ZlpbI0', 27676 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15942, 10306, '2C6VcBLgZw', 6864, 'TSRaO', 802 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40298, 12121, 'ehQZ7F7jCNX', 23989, 'k6yQ06U', 29098 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36921, 35562, 'lIdV', 21101, 'i3pzoil5tNV', 16523 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45245, 46218, '2aENGU4Z6', 34707, '8D99', 34950 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 27337, 39293, '07uPiek', 6629, 'OoatKEbqs', 6413 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48635, 40584, 'UHJy2', 36604, 'Q', 18492 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34985, 22863, 'O7', 14882, 'sMBs1tRT', 11578 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 49797, NULL, '2QSHHRD', 21823, '75lpolnGI', 16849 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40881, 41985, 'QSRwdCmu1', 42324, '6e', 59 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 49283, 27036, '', 26808, 'XLEX', 38536 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 42130, NULL, 'WekL', 48108, 'T', 30664 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 17709, 26974, 'Jg6HCFoB2m', 36465, 'k2AI7bScT', 14074 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24634, 21725, 's8', 49073, 'y', 13151 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36044, 6709, 'mDNI9ms32i3', 13724, '6vKdfmx6VjrV', 37668 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43253, 37769, 'Fy12uojoY', 5874, 'E', 39663 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6298, 1936, 'M9o1X', 48682, 'Zeluqx6N', 40563 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 30363, 40428, 'PkLzGrzKVh', 38172, 'KZxcujE', 41512 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45917, 12108, '3', 45792, 'oKxs', 45108 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6996, 36468, 'Gc9nqC2o', 15290, 'Npxc', 36303 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 24349, 49931, 'hwaM1R', 45616, 'rqc', 4139 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40013, NULL, 'lfnX', 38452, 'mHR9XWmrSK1', 27373 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 6407, 21923, '6', 15658, '', 39989 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 35886, 17189, '6xpgOw437', 25770, 'Hd', 45975 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40050, 11553, 'yq', 1208, 'W5HlHGNhXE1', 25563 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45988, 38215, 'aYMEHUZaAfB', 38250, 'dcB', 26387 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16262, 44236, 'dKlRuyIJK', 48068, '4SwzhZy7F2Pl', 20321 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41264, 35663, '0rZp6RrNf5', 31371, 'kSfrg', 29002 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 7254, 27271, 'h', 7939, 'v', 27290 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 19029, 23617, 'GYP0ao3', 1876, 'nyJ3b', 6309 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 1623, 7041, '', 20281, '4rF29PQY', 17086 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 37010, 15227, 's5a', 6615, '3fkD5cs1AA', 7039 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 1113, 2198, '0Xp', 11210, 'xNT1WfqFfSo', 8530 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 47758, 11421, 'Q1InNy02', 4900, 'mJKfUQ', 13151 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 40983, 38876, 'Rs1G9', 35645, '31TM', 648 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 29696, 24378, 'wz79LuCreyO', 34753, 'xGsnU9tota', 45948 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43769, 21833, 'swSk2ZmQT0F', 34400, 'ehQZ7F', 25760 ) ; +UPDATE tt_4 SET v2 = 'FPjYuAKnAj' WHERE v2 = 'i8' ; +DELETE FROM tt_4 WHERE i3 = 24499 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 36718, 13590, 'h', 38370, 'e2ubBJC', 36024 ) ; +DELETE FROM tt_4 WHERE ipkey = 47881 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 17584, 32658, '4QSLSre7u', 6131, 'Sh0Jwkb', 30059 ) ; +UPDATE tt_4 SET i3 = 3420 WHERE ipkey = 31529 ; +DELETE FROM tt_4 WHERE ipkey = 28403 ; +UPDATE tt_4 SET v4 = '' WHERE v4 = 'uWq' ; +DELETE FROM tt_4 WHERE i5 = 45148 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 8051, 17591, 'g8U0J2q', 34310, '7iaK', 21220 ) ; +DELETE FROM tt_4 WHERE ipkey = 28782 ; +UPDATE tt_4 SET i1 = 28366 WHERE ipkey = 19329 ; +UPDATE tt_4 SET i1 = 19503 WHERE v4 = 'dXmbMw' ; +UPDATE tt_4 SET ipkey = 9966 WHERE ipkey = 3507 ; +DELETE FROM tt_4 WHERE ipkey = 29621 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 15754, 10374, 'JGb', 27645, 'iMlw', 30060 ) ; +DELETE FROM tt_4 WHERE ipkey = 2640 ; +DELETE FROM tt_4 WHERE ipkey = 36572 ; +DELETE FROM tt_4 WHERE ipkey = 45373 ; +UPDATE tt_4 SET v4 = 'rJ3NqRe8wJ' WHERE v4 = '' ; +UPDATE tt_4 SET ipkey = 6862 WHERE ipkey = 8088 ; +UPDATE tt_4 SET i3 = 29160 WHERE v2 = 'M0v' ; +DELETE FROM tt_4 WHERE ipkey = 6821 ; +DELETE FROM tt_4 WHERE v4 = 'r' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 10688, 26534, 'LPCPF9IveR', 9166, 'jS2A7d2A', 19628 ) ; +DELETE FROM tt_4 WHERE i3 = 48244 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 38789, 12548, 'nHU', 40722, 'eWcS4m', 44133 ) ; +DELETE FROM tt_4 WHERE ipkey = 37896 ; +ALTER TABLE tt_4 COMPRESSION= 'none' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 31033, 23891, 'DpZBP', 30076, '9CDi2', 36751 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 23997, 33331, 'dc', 17694, 'XEWQM9oPWaV', 38455 ) ; +DELETE FROM tt_4 WHERE ipkey = 45649 ; +DELETE FROM tt_4 WHERE i5 = 49198 ; +DELETE FROM tt_4 WHERE i1 = 19220 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 41438, 18698, 'w9PBM5', 14460, 'mQ1', 6580 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 32329, 38480, 'Ee', 6341, 'C3zCltQR', 16923 ) ; +DELETE FROM tt_4 WHERE i1 = 14715 ; +UPDATE tt_4 SET i3 = 26962 WHERE i1 = 1280 ; +DELETE FROM tt_4 WHERE ipkey = 17737 ; +UPDATE tt_4 SET i5 = 6561 WHERE ipkey = 11586 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 16454, 2642, 'kU5NZQQQu', 12717, 'DuY4MPy5vW', 2227 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 33474, 27684, 'aSwNs', 25365, '1CKUVr2HyE', 2734 ) ; +DELETE FROM tt_4 WHERE ipkey = 26040 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 20594, 21713, 'XHO', 34946, '', 30573 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 9576, 19702, 'ff', 3865, 'ESllm', 20268 ) ; +DELETE FROM tt_4 WHERE v4 = 'LNLcS' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 34336, 26979, '8c', 41189, 'Z3cgki66qm', 37121 ) ; +ANALYZE TABLE tt_4 ; +DELETE FROM tt_4 WHERE i1 = 35192 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 46083, 27186, 'nDcC', 31480, 'O1Q8ArjBa1', 20380 ) ; +UPDATE tt_4 SET i3 = 33578 WHERE v2 = 'Dvqr1wkFZi' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 48521, NULL, 'qC', 40353, '', 13932 ) ; +DELETE FROM tt_4 WHERE ipkey = 45740 ; +DELETE FROM tt_4 WHERE ipkey = 37774 ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 45257, 17709, 'U', 6159, '4ZH', 25261 ) ; +UPDATE tt_4 SET v4 = 'FRF' WHERE v4 = 'fZ' ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 43861, 24066, '', 36998, 'PPRwY0', 17671 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 4851, 2842, '9', 7246, 'w', 18806 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 27943, 11328, '', 38716, 'gzQiGQD', 32823 ) ; +INSERT INTO tt_4 ( ipkey ,i1 ,v2 ,i3 ,v4 ,i5 ) VALUES( 14243, 3978, 'Ma', 30675, '8fXT5tBOfC', 12481 ) ; +UPDATE tt_4 SET v4 = 'h19CNWRM' WHERE v2 = '9j' ; +ALTER TABLE tt_4 MODIFY COLUMN i3 INT(7), LOCK=DEFAULT, ALGORITHM=COPY ; +UPDATE tt_4 SET i1 = 34023 WHERE ipkey = 25301 ; +DELETE FROM tt_4 WHERE ipkey = 32409 ; +UPDATE tt_4 SET ipkey = 33631 WHERE ipkey = 18487 ; +DELETE FROM tt_4 WHERE ipkey = 38160 ; +UPDATE tt_4 SET v4 = '5u4YCv' WHERE ipkey = 7927 ; +DELETE FROM tt_4 WHERE i3 = 3277 ; +UPDATE tt_4 SET i3 = 36574 WHERE ipkey = 35364 ; +DELETE FROM tt_4 WHERE ipkey = 1440 ; +DELETE FROM tt_4 WHERE i3 = 49019 ; +DELETE FROM tt_4 WHERE ipkey = 48410 ; +DELETE FROM tt_4 WHERE ipkey LIKE '%25375%' ; +DELETE FROM tt_4 WHERE ipkey = 27252 ; +DELETE FROM tt_4 WHERE ipkey = 3382 ; +DELETE FROM tt_4 WHERE v2 = '' ; +DELETE FROM tt_4 WHERE ipkey = 12257 ; +UPDATE tt_4 SET v4 = '5yzOygcrcvr' WHERE ipkey LIKE '%20126%' ; +UPDATE tt_4 SET i1 = 2722 WHERE ipkey = 9861 ; +UPDATE tt_4 SET v2 = 'Olcr' WHERE i5 = 27986 ; +DELETE FROM tt_4 WHERE ipkey IN (10725,12651) ; +DELETE FROM tt_4 WHERE ipkey = 1548 ; +UPDATE tt_4 SET i1 = 27697 WHERE i5 = 28659 ; +UPDATE tt_4 SET i5 = 41582 WHERE ipkey = 49735 ; +DELETE FROM tt_4 WHERE ipkey = 7050 ; +UPDATE tt_4 SET i5 = 10556 WHERE ipkey = 43284 ; +DELETE FROM tt_4 WHERE ipkey = 16138 ; +DELETE FROM tt_4 WHERE ipkey = 19551 ; +UPDATE tt_4 SET v4 = '2g' WHERE ipkey = 47794 ; +DELETE FROM tt_4 WHERE i1 = 17151 ; +UPDATE tt_4 SET v4 = '0XDERmZU' WHERE ipkey = 48453 ; +DELETE FROM tt_4 WHERE i3 = 28565 ; +ALTER TABLE tt_4 DISCARD TABLESPACE ; +DROP TABLE tt_4 ; + +CREATE TABLE t1(a INT) ENGINE=innodb; + + --disable_query_log + --let $n=2048 + BEGIN; + while ($n) + { + INSERT INTO t1 VALUES (10); + --dec $n + } + COMMIT; + --enable_query_log + + ALTER TABLE t1 DISCARD TABLESPACE; + DROP TABLE t1; diff --git a/storage/innobase/row/row0mysql.cc b/storage/innobase/row/row0mysql.cc index 6e430c26a6f6..d08bb9482aa1 100644 --- a/storage/innobase/row/row0mysql.cc +++ b/storage/innobase/row/row0mysql.cc @@ -3463,6 +3463,7 @@ static dberr_t row_discard_tablespace(trx_t *trx, dict_table_t *table, return (err); } + btr_drop_ahi_for_table(table); /* Discard the physical file that is used for the tablespace. */ err = fil_discard_tablespace(table->space);