--source include/have_innodb.inc --disable_abort_on_error SET SESSION optimizer_switch = 'index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_condition_pushdown=on,firstmatch=on,loosescan=on,materialization=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,table_elimination=on'; SET SESSION optimizer_use_mrr = 'force'; SET SESSION join_cache_level = 4; SET SESSION join_buffer_size = 1; --enable_abort_on_error --disable_warnings DROP TABLE /*! IF EXISTS */ t1; DROP TABLE /*! IF EXISTS */ t2; DROP TABLE /*! IF EXISTS */ t3; DROP TABLE /*! IF EXISTS */ t4; DROP TABLE /*! IF EXISTS */ t5; --enable_warnings CREATE TABLE t1 ( col_varchar_1024_latin1 varchar(1024) DEFAULT NULL, pk int(11) NOT NULL AUTO_INCREMENT, col_int_key int(11) DEFAULT NULL, col_varchar_1024_utf8_key varchar(1024) CHARACTER SET utf8 DEFAULT NULL, col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (pk), KEY col_int_key (col_int_key), KEY col_varchar_1024_utf8_key (col_varchar_1024_utf8_key(333)), KEY col_varchar_10_utf8_key (col_varchar_10_utf8_key) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE t2 ( col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8 DEFAULT NULL, pk int(11) NOT NULL AUTO_INCREMENT, col_int_key int(11) DEFAULT NULL, col_varchar_1024_utf8_key varchar(1024) CHARACTER SET utf8 DEFAULT NULL, col_varchar_1024_latin1 varchar(1024) DEFAULT NULL, PRIMARY KEY (pk), KEY col_varchar_10_utf8_key (col_varchar_10_utf8_key), KEY col_int_key (col_int_key), KEY col_varchar_1024_utf8_key (col_varchar_1024_utf8_key(255)) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; INSERT INTO t2 VALUES ('w',1,-1998913536,'oh','tomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgiku'),('at',2,-208338944,'p','urqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgikurhznnftczkufjkpjjphkgiqnipxirurmmbjicovkeixxcshawydvtneonwkfplreaeberbqryydzehfixutdgcxjodiltrclevvtxeaklwbblqwvlmcsfjwfywsgcoyrsqucqjetkpxguxlbmmwusurlvjjvmxvctxrubtpeqemgaspbxycxtupkycauqsycwulbrwlyzenddjjgnmpkdsbmcnplnpbbhbulmclpmwylwajjbkgpoxeeltffevzjnstinukncssnilwkqzsuatvpoilngypjtihumknckdsrcphuzshokpymoqfmtbrrqgyrhchnjmtjdexbwyodoxevebqpkpihfvywsmsgzxoxlklonxmxkyojfvhjibluhlazxwvtdejpxurpmgygscaerlheftqsslcmmngimhreemonsdsomujtpjjbydaziguqjvchewrolczrfatjrliomshtmnelegjroizfufagfuwmseysvgztneenofjeywohwfbeltpwqaamedfjcvdyjvxvhqerofasdyavasmokfixldjijmrlwfcuferguzyegzumiqhuotpzkrdeijkneosbnfnjukceamgibsd'),('m',3,2064777216,'x','of'),('sxourqntom',4,8,'lsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoi','and'),('don\'t',5,9,'v','a'),('my',6,-1889468416,'qpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgikurhznnftczkufjkpjjphkgiqnipxirurmmbjicovkeixxcshawydvtneonwkfplreaeberbqryydzehfixutdgcxjodiltrclevvtxeaklwbblqwvlmcsfjwfywsgcoyrsqucqjetkpxguxlbmmwusurlvjjvmxv','zoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkj'); CREATE TABLE t3 ( col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8 DEFAULT NULL, pk int(11) NOT NULL AUTO_INCREMENT, col_varchar_1024_utf8_key varchar(1024) CHARACTER SET utf8 DEFAULT NULL, col_varchar_1024_latin1 varchar(1024) DEFAULT NULL, col_int_key int(11) DEFAULT NULL, PRIMARY KEY (pk), KEY col_varchar_10_utf8_key (col_varchar_10_utf8_key), KEY col_varchar_1024_utf8_key (col_varchar_1024_utf8_key(255)), KEY col_int_key (col_int_key) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1; INSERT INTO t3 VALUES ('a',1,'as','r',0),('know',2,'z','d',0),('smuvpbrptq',3,'I','is',5),('j',4,'l','could',1872691200),('c',5,'bcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgikurhznnftczkufjkpjjphkgiqnipxirurmmbjicovkeixxcshawydvtneonwkfplreaeberbqryydzehfixutdgcxjodiltrclevvtxe','r',2134376448),('ebcgpsmuvp',6,'prebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgikurhznnftczkufjkpjjphkgiqnipxirurmmbjicovkeixxcshawydvtneonwkfplreaeberbqryydzehfixutdgcxjodiltrclevvtxeaklwbblqwvlmcsfjwfywsgcoyrsqucqjetkpxguxlbmmwusurlvjjvmxvctxrubtpeqemga','no',9),('n',7,'say','who',9),('mjprebcgps',8,'k','didn\'t',1),('go',9,'r','know',960036864),('hrcjqmjpre',10,'e','t',6),('mybhrcjqmj',11,'tuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgikurhznnftczkufjkpjjphkgiqnipxirurmmbjicovkeixxcshawydvtneonwkfplreaeberbqryydzehfixutdgcxjodiltrclevvtxeaklwbblqwvlmcsfjwfywsgcoyrsqucqjetkpxguxlbmmwusurlvjjvmxvctxrubtpeqemgaspbxycxtupkycauqsycwulbrwlyzenddjjgnmpkdsbmcnplnpbbhbulmclpmwylwajjbkgpoxeeltffevzjnstinukncssnilwkqzsuatvpoilngypjtihumknckdsrcphuzshokpymoqfmtbrrqgyrhchnjmtjdexbwy','h',6),('didn\'t',12,'meutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgikurhznnftczkufjkpjjphkgiqnipxirurmmbjicovkeixxcshawydvtneonwkfplreaeberbqryydzehfixutdgcxjodiltrclevvtxeaklwbblqwvlmcsfjwfywsgcoyrsqucqjetkpxguxlbmmwusurlvjjvmxvctxrubtpeqemgaspbxycxtupkycauqsycwulbrwlyzenddjjgnmpkdsbmcnplnpbbhbulmclpmwylwajjbkgpoxeeltffevzjnstinuk','z',659357696),('dcmeutuknm',13,'bcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahb','about',5),('ebcgdcmeut',14,'would','some',-93716480); INSERT INTO t3 VALUES ('think',15,'lstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgikurhznnftczkufjkpjjphkgiqnipxirurmmbjicovkeixxcshawydvtneonwkfplreaeberbqryydz','m',1780219904),('n',16,'q','jilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojmmsdqqpvudadycvvgpqviyhwiflccsgqxsvpfxvlfmutumekxstjsdztecxhujhlpfmrudacgikurhznnftczkufjkpjjphkgiqnipxirurmmbjicovkeixxcshawydvtneonwkfplreaeberbqryydzehfixutdgcxjodiltrclevvtxeaklwbblqwvlmcsfjwfywsgcoyrsqucqjetkpxguxlbmmwusurlvjjvmxvctxrubtpeqemgaspbxycxtupkycauqsycwulbrwlyzenddjjgnmpkdsbmcnplnpbbhbulmclpmwylwajjbkgpoxeeltffevzjnstinukncssnilwkqzsuatvpoilngypjtihumknckdsrcphuzshokpymoqfmtbrrqgyrhchnjmtjdexbwyodoxevebqpkpihfvywsmsgzxox',-2130378752),('vjilstmebc',17,'k','xvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqy',1760428032),('ixvjilstme',18,'elnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbi','out',-229179392),('y',19,'j','v',9),('do',20,'l','n',-1677983744); CREATE TABLE t4 ( col_varchar_1024_latin1 varchar(1024) DEFAULT NULL, col_int_key int(11) DEFAULT NULL, col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8 DEFAULT NULL, pk int(11) NOT NULL AUTO_INCREMENT, col_varchar_1024_utf8_key varchar(1024) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (pk), KEY col_int_key (col_int_key), KEY col_varchar_10_utf8_key (col_varchar_10_utf8_key), KEY col_varchar_1024_utf8_key (col_varchar_1024_utf8_key(255)) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1; INSERT INTO t4 VALUES ('at',6,'wbcicirsqt',1,'e'),('o',8,'mean',2,'gwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilaln'),('x',-1531510784,'got',3,'migwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmr'),('o',-1189675008,'vmigwbcici',4,'hrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvs'),('v',9,'d',5,'were'),('the',-1632960512,'f',6,'know'),('akchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmeb',2,'that\'s',7,'nzakchrvmigwbc'),('ok',1994588160,'r',8,'go'),('z',81264640,'koknzakchr',9,'mnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcgg'),('z',-212402176,'your',10,'it\'s'),('sibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoe',3,'lufsibmnko',11,'t'),('fslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujha',-608043008,'your',12,'upfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmi'),('jupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvn',-2135687168,'her',13,'z'); INSERT INTO t4 VALUES ('he\'s',1,'njupfslufs',14,'knjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqyts'),('w',9,'e',15,'apknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyy'),('napknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxu',2,'v',16,'they'),('ftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvl',3,'y',17,'your'),('rmftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcg',392101888,'brmftpssna',18,'p'); INSERT INTO t4 VALUES ('f',1,'nqbrmftpss',19,'nunqbrmftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvno'),('ununqbrmftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlq',6,'look',20,'back'),('r',9,'l',21,'iubununqbrmftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksah'),('giubununqbrmftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeocio',6,'it\'s',22,'kngiubununqbrmftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhkt'),('me',3,'emkngiubun',23,'remkngiubununqbrmftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmeb'); INSERT INTO t4 VALUES ('rremkngiubununqbrmftpssnapknjupfslufsibmnkoknzakchrvmigwbcicirsqtneyqvhzpgwngwygaftzjikmkjslpjcnjlawcmqwaahcveziyaakaeedtdqbfonbrasmprekfwzmigdmoobtljrbmhxhuvursdjnmrynpbptggckmsmvdlytxalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwl',737345536,'really',24,'did'),('u',1053425664,'gerremkngi',25,'can\'t'); CREATE TABLE t5 ( col_varchar_1024_utf8_key varchar(1024) CHARACTER SET utf8 DEFAULT NULL, pk int(11) NOT NULL AUTO_INCREMENT, col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8 DEFAULT NULL, col_varchar_1024_latin1 varchar(1024) DEFAULT NULL, col_int_key int(11) DEFAULT NULL, PRIMARY KEY (pk), KEY col_varchar_1024_utf8_key (col_varchar_1024_utf8_key(333)), KEY col_varchar_10_utf8_key (col_varchar_10_utf8_key), KEY col_int_key (col_int_key) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1; INSERT INTO t5 VALUES ('lzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgf',1,'now','don\'t',8),('can\'t',2,'yeah','u',443875328),('not',3,'b','can',-719060992),('in',4,'dzolaaqlzi','xdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlr',1615921152),('my',5,'v','bdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzx',956956672),('can',6,'him','hey',382533632),('he\'s',7,'are','didn\'t',-726269952),('u',8,'because','didn\'t',115933184),('l',9,'hey','alrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipg',1860042752),('q',10,'like','zlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefkn',1326252032),('b',11,'p','think',146800640),('don\'t',12,'aamxfntzlx','caamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywz',1473183744),('how',13,'hey','good',2088763392),('qccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxcaoemirmsnnojm',14,'hqccaamxfn','o',5),('ghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlp',15,'i','e',9),('tell',16,'a','f',-393150464); INSERT INTO t5 VALUES ('vrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjsh',17,'when','nwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrr',8),('xnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtrmlbiaocdixiqoqmjzkjubpnfdxcobjxqihjvfcjvcpepdafgxrxca',18,'uttxnwvrgh','outtxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwkftwdwlbcqbuoivifxxxugqkksapusayftpovphzverlzlskkhbxxymlrvpdrgfsiteswiqnzvzjlpdpzgqytsnufhkvrbchosidoqhnwnwwjfpjsbxhzxzoezqpolsxourqntomzgjichogvdrodpedkuofujttercvljitvtjrcmxffkpselccfirvdwesohquiiuhyqenlpliolyqpoiwigzcizaismgjdxbksahberogcoqbuwxzmovebegwrcjshkalgwnchwclogtvmqrtjoiqhmljxkhlawtr',4),('l',19,'f','wfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyltpcnpsthzmhksgxribmyoysvvhzsnyyaxcudugziazdhwk',7),('see',20,'t','i',-1358888960),('c',21,'xwaqowfout','w',-1694826496),('back',22,'nlxwaqowfo','i',4); INSERT INTO t5 VALUES ('cggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxut',23,'s','j',-1273298944),('txalcggnlxwaqowfouttxnwvrghqccaamxfntzlxqalrjufgfbdxdzolaaqlzietnglqsmxqsujhapgohsfrttihtipggeqsqrlqypnkymloejywzkvldlrsvjjgyrhogcrmbhbodhktoolksepaexmtciymxbfhsurffdflnmdchndzmsuegahsaumseydlpvzbsdzhqbtjecpzlbarootovfbxolmgltqklckqllbptqvrgfurglabcixoztoilrmnrdzxudexlmxdkmyyszznxttuxboefknfhqagwzvrfrpqehrjsezpmvnazkzvbghqvxuvjwxbzjganarsgyczowugjcleydrmkgefbgxjljmqcgqtshxvnodqjvilalnouoeociontwqgyldwliarltrraggdfwetpzggblgdnsgnelnixvjilstmebcgdcmeutuknmybhrcjqmjprebcgpsmuvpbrptquvgpqcfpygvmmqbvdusxutotngqibmotszevtwdxeikfvsbjvtcpvbvssnpqnzybrhrwcknyl',24,'when','y',578682880); SELECT t2 .col_int_key FROM t4 LEFT JOIN t2 JOIN t5 ON t2 .col_varchar_1024_utf8_key = t5 .col_varchar_10_utf8_key ON t4 .col_int_key LEFT JOIN t3 JOIN t1 ON t3 .col_varchar_10_utf8_key = t1 .col_varchar_1024_latin1 ON t4 .col_int_key = t1.pk WHERE t2 .pk <> 4 ;