CREATE TABLE t4 (c1 NUMERIC UNSIGNED ZEROFILL, c2 INTEGER UNSIGNED ZEROFILL) AVG_ROW_LENGTH = 1382400577; CREATE TABLE t5 (c1 BIT (38), c2 LONGTEXT CHARACTER SET UTF8) STATS_PERSISTENT = DEFAULT; UPDATE LOW_PRIORITY t4 SET c2 = 1; REPLACE INTO t4 (c1,c2) VALUES (1.009,1); REPLACE LOW_PRIORITY INTO t4 (c1,c2) VALUES (12.991,5); INSERT IGNORE INTO t4 (c1,c2) VALUES (1.009,1); INSERT HIGH_PRIORITY IGNORE INTO t4 (c1,c2) VALUES (-9.183,3); REPLACE LOW_PRIORITY INTO t5 (c1,c2) VALUES (b'11010','YZyOvrFHRV'); UPDATE LOW_PRIORITY IGNORE t5 SET c1 = b'1001101100000001011011000000101101101011101111011011100101111000', c2 = 'j20xj4H86s'; INSERT INTO t5 (c1,c2) VALUES (b'11','c6ZvLl88bj'); UPDATE t5 SET c2 = 'eRFfy6fDcE', c1 = b'00011010011'; REPLACE INTO t4 (c1,c2) VALUES (9282,1); INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'111001001100001001011011001','8958mYMDXT'); INSERT LOW_PRIORITY INTO t4 (c1,c2) VALUES (1.009,6); ALTER TABLE t4 ROW_FORMAT COMPACT; INSERT IGNORE INTO t4 (c1,c2) VALUES (12.991,1); INSERT IGNORE INTO t5 (c1,c2) VALUES (b'1111101111001','4vWb2m4lVc'); REPLACE LOW_PRIORITY INTO t4 (c1,c2) VALUES (null,null); REPLACE INTO t4 (c1,c2) VALUES (null,6); INSERT INTO t5 (c1,c2) VALUES (b'1100010111100000010100000100110110','ZXO7KLfKNQ'); UPDATE LOW_PRIORITY IGNORE t5 SET c1 = b'10010101111100001101011100100111100011110000100101110', c2 = 'bi0XN3wGHR'; UPDATE IGNORE t5 SET c1 = b'00001100001001000100100110111001101011001100000010', c2 = '0bVKU3lmws' WHERE ((((LOCALTIME()) IS NOT NULL) <= (c1))); REPLACE INTO t4 (c1,c2) VALUES (85.1214,1); INSERT IGNORE INTO t4 (c1,c2) VALUES (12.991,2); CREATE TABLE t7 (c1 TINYTEXT CHARACTER SET ASCII, PRIMARY KEY (c1(4))); UPDATE IGNORE t5 SET c1 = b'110011111001001101010110', c2 = 'W3S0Ukg74Q'; UPDATE LOW_PRIORITY t7 SET c1 = 'lHHzKhoQfl'; UPDATE t7 SET c1 = 'MCXp9sZXxj'; UPDATE IGNORE t7 SET c1 = 'RAnfgoiB87'; UPDATE IGNORE t5 SET c2 = '5ucdvpoKdA'; REPLACE INTO t7 (c1) VALUES ('4pydeQPhlF'); DROP TABLE IF EXISTS t2; REPLACE INTO t4 (c1,c2) VALUES (1.009,5); UPDATE LOW_PRIORITY IGNORE t4 SET c1 = 1.009; DELETE LOW_PRIORITY FROM t7; DELETE FROM t4; REPLACE LOW_PRIORITY INTO t5 (c1,c2) VALUES (b'1','ZvFO6dEov8'); UPDATE LOW_PRIORITY IGNORE t7 SET c1 = 'Qs2O3JP5Gy'; REPLACE LOW_PRIORITY INTO t5 (c1,c2) VALUES (b'011110001100011000011110101001011','BKvijclb8A'); INSERT LOW_PRIORITY IGNORE INTO t7 (c1) VALUES ('L88fCKhiSj'); UPDATE LOW_PRIORITY IGNORE t4 SET c1 = -88, c2 = 8; CREATE OR REPLACE VIEW v3 AS SELECT ca5 AS ca1, ca5 AS ca2, ca6 AS ca3 FROM (SELECT c1 AS ca4, c1 AS ca5, c1 AS ca6 FROM t7) AS ta1; REPLACE LOW_PRIORITY INTO t7 (c1) VALUES ('dShGQrRAj1'); REPLACE INTO t5 (c1,c2) VALUES (b'000101011111011','UTNkpUvaVr'); REPLACE INTO t5 (c1,c2) VALUES (b'1010111101111101111110100101110101','m9irpkvwlr'); REPLACE INTO t5 (c1,c2) VALUES (b'01100101110110001111011','DjJLlEzR8q'); INSERT HIGH_PRIORITY INTO t5 (c1,c2) VALUES (b'110100001010','j7r22Kvi4B'); INSERT LOW_PRIORITY INTO t7 (c1) VALUES ('CzuaCNwrIZ'); INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'011','ssXEczDh9J'); UPDATE IGNORE t7 SET c1 = 'cLl3XuepOZ'; INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'011101','VKIW3cCGjm'); INSERT HIGH_PRIORITY IGNORE INTO t7 (c1) VALUES ('lmMQNDi4lM'); INSERT LOW_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'011000001101110011010011111000000011110001001101000001011001','3FEv4dMrC1'); INSERT IGNORE INTO t4 (c1,c2) VALUES (1.009,null); INSERT INTO t7 (c1) VALUES ('wjnepT6KkT'); UPDATE t7 SET c1 = 'jP0nv4zoc7' WHERE ((! (((TRUE + c1) << (- (SELECT ca2 AS ca1 FROM (SELECT c2 AS ca2, c1 AS ca3, c1 AS ca4 FROM t4) AS ta1)))))); REPLACE LOW_PRIORITY INTO t7 (c1) VALUES ('lccMfxYWWX'); INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'0010101110110110101011010001010','bkcY6km6u5'); REPLACE LOW_PRIORITY INTO t7 (c1) VALUES ('mYd2VD2HBW'); REPLACE LOW_PRIORITY INTO t5 (c1,c2) VALUES (b'11011010010101101000000101100110101010','42RGeximQY'); REPLACE LOW_PRIORITY INTO t4 (c1,c2) VALUES (54.1840,4); INSERT LOW_PRIORITY IGNORE INTO t7 (c1) VALUES ('UPNbAtkgA7'); CREATE INDEX i4 ON t5(c2(4)) VISIBLE ALGORITHM = INPLACE; REPLACE LOW_PRIORITY INTO t7 (c1) VALUES ('7iZhx6sEZU'); INSERT LOW_PRIORITY IGNORE INTO t4 (c1,c2) VALUES (-9.183,5); UPDATE LOW_PRIORITY t5 SET c1 = b'000110100'; REPLACE LOW_PRIORITY INTO t7 (c1) VALUES ('xgXgH2gSmA'); CREATE INDEX i5 USING HASH ON t7(c1(3)) INVISIBLE; INSERT LOW_PRIORITY INTO t4 (c1,c2) VALUES (81.1626,null); UPDATE LOW_PRIORITY IGNORE t7 SET c1 = '6zUQfbSjdR'; ALTER TABLE t7 ROW_FORMAT DEFAULT; INSERT HIGH_PRIORITY INTO t4 (c1,c2) VALUES (64.0441,8); REPLACE LOW_PRIORITY INTO t7 (c1) VALUES ('9AHQg6WfCA'); REPLACE LOW_PRIORITY INTO t7 (c1) VALUES ('qmILLKZc9M'); INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'0000111000010010000101110110110100110010000111111','a6japIwe01'); INSERT IGNORE INTO t5 (c1,c2) VALUES (b'10111000001110100000','4mpyE7w4bf'); INSERT HIGH_PRIORITY IGNORE INTO t4 (c1,c2) VALUES (12.991,8); UPDATE LOW_PRIORITY IGNORE t7 SET c1 = '4KjizNApWN'; UPDATE t5 SET c2 = '0QS8sztMjM', c1 = b'11110110010001010110101'; REPLACE INTO t5 (c1,c2) VALUES (b'1001000110001000','6dxKwLzPlR'); DELETE LOW_PRIORITY QUICK FROM t4; UPDATE LOW_PRIORITY IGNORE t7 SET c1 = 'nGZSSuIz3h'; REPLACE INTO t7 (c1) VALUES ('tWCCUxxhAl'); CREATE INDEX i6 ON t5(c1 DESC) ALGORITHM COPY; INSERT HIGH_PRIORITY IGNORE INTO t7 (c1) VALUES ('EvTLVU1sfm'); REPLACE LOW_PRIORITY INTO t5 (c1,c2) VALUES (b'0010000100111100101101101001','mDE3nuIjw1'); DROP VIEW IF EXISTS v3; INSERT HIGH_PRIORITY IGNORE INTO t7 (c1) VALUES ('qI66swVPgP'); INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'01111111010110000000101001011000111011001111110001','11fvrfejrF'); INSERT LOW_PRIORITY IGNORE INTO t4 (c1,c2) VALUES (null,2); UPDATE LOW_PRIORITY t4 SET c2 = 8, c1 = 47.0390; INSERT HIGH_PRIORITY IGNORE INTO t4 (c1,c2) VALUES (36.0711,0); INSERT IGNORE INTO t7 (c1) VALUES ('XzUtfPJNbl'); UPDATE IGNORE t7 SET c1 = 'TU3UcCdWXf'; INSERT HIGH_PRIORITY IGNORE INTO t7 (c1) VALUES ('5JDyoIVuEG'); UPDATE t4 SET c1 = 1.009, c2 = 3; INSERT IGNORE INTO t7 (c1) VALUES ('5dyHctWA5V'); INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'01111000000111111010011001001110011010010100011010111','3OFjDs6iL9'); REPLACE LOW_PRIORITY INTO t5 (c1,c2) VALUES (b'001101','7fhyI5dmwn'); INSERT HIGH_PRIORITY INTO t4 (c1,c2) VALUES (91.0555,null); UPDATE LOW_PRIORITY t5 SET c1 = b'0'; UPDATE IGNORE t4 SET c1 = 1.009, c2 = 5; INSERT LOW_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'1010010001101111011010111110001000001011100001','IAg3L13KKs'); INSERT IGNORE INTO t5 (c1,c2) VALUES (b'0000110101111011010100110100110','5exl2W71Wc'); UPDATE LOW_PRIORITY IGNORE t7 SET c1 = 'i3SAjrms0U'; INSERT IGNORE INTO t5 (c1,c2) VALUES (b'1011110101001101100101100011','rGaHZ0WhLW'); UPDATE IGNORE t4 SET c1 = -9.183, c2 = null; REPLACE INTO t7 (c1) VALUES ('JB5R66qBmM'); REPLACE LOW_PRIORITY INTO t5 (c1,c2) VALUES (b'101011011011','5Nmjrs4QRB'); INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'1110','VwdFQr2Slo'); UPDATE LOW_PRIORITY IGNORE t4 SET c1 = 1.009, c2 = null; UPDATE LOW_PRIORITY t5 SET c2 = 'lwm1w1aooX'; INSERT INTO t5 (c1,c2) VALUES (b'001001110101110010100000001','0S3rnMztWM'); DELETE QUICK FROM t7; CREATE VIEW v3 AS SELECT c1 AS ca1, c1 AS ca2, c2 AS ca3 FROM t5; UPDATE IGNORE t4 SET c2 = null, c1 = 1.009; UPDATE IGNORE t5 SET c1 = b'111110001011111010001100', c2 = 'umaFHgNPrj'; REPLACE LOW_PRIORITY INTO t7 (c1) VALUES ('B3HvBlweGA'); INSERT LOW_PRIORITY IGNORE INTO t4 (c1,c2) VALUES (-9.183,6); REPLACE LOW_PRIORITY INTO t4 (c1,c2) VALUES (12.991,null); UPDATE LOW_PRIORITY t4 SET c1 = 9947; UPDATE t5 SET c2 = 'E1qBYV359d', c1 = b'100101000010011'; INSERT HIGH_PRIORITY IGNORE INTO t5 (c1,c2) VALUES (b'000000100101101010111101100111001011101101111101110','jBGTfc3MxU'); REPLACE LOW_PRIORITY INTO t4 (c1,c2) VALUES (58.1418,null); UPDATE LOW_PRIORITY t5 SET c1 = b'11101101'; UPDATE IGNORE t7 SET c1 = 'ueEDe2JXep'; CREATE INDEX i7 USING HASH ON t5(c1); REPLACE LOW_PRIORITY INTO t5 (c1,c2) VALUES (b'01100011001101001010011011100','nbKRfxQSXT'); UPDATE LOW_PRIORITY IGNORE t5 SET c1 = b'0'; INSERT HIGH_PRIORITY IGNORE INTO t7 (c1) VALUES ('AkMCvuLFid'); UPDATE IGNORE t7 SET c1 = 'Kh1AEGzQ1d';