Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
When executing the following query
SELECT table2 .`col_int`
FROM I LEFT JOIN N table2 ON table2 .`col_varchar_10_latin1` LEFT JOIN F table3 LEFT JOIN L table4 JOIN P table6 ON table6 .`col_int` ON table3 .`col_int_key` = table4 .`col_int_key` ON table2 .`col_varchar_10_latin1` = table6 .`col_varchar_10_utf8_key`
;
the server crashed as follows:
#5 0x00b774f4 in __bzero_sse2 () from /lib/libc.so.6
#6 0x082dae51 in JOIN_CACHE_BKA_UNIQUE::cleanup_hash_table (this=0xb6db6528) at sql_join_cache.cc:2916
#7 0x082da95d in JOIN_CACHE_BKA_UNIQUE::reset (this=0xb6db6528, for_writing=true) at sql_join_cache.cc:2659
#8 0x082d92d0 in JOIN_CACHE::join_records (this=0xb6db6528, skip_last=false) at sql_join_cache.cc:1709
#9 0x082d9102 in JOIN_CACHE::join_records (this=0xb6d96450, skip_last=false) at sql_join_cache.cc:1650
#10 0x0831ef60 in sub_select_cache (join=0xb6d8df88, join_tab=0xb6d94a20, end_of_records=true) at sql_select.cc:12822
#11 0x0831f179 in sub_select (join=0xb6d8df88, join_tab=0xb6d94860, end_of_records=true) at sql_select.cc:12984
#12 0x0831e733 in do_select (join=0xb6d8df88, fields=0x9fef714, table=0x0, procedure=0x0) at sql_select.cc:12580
#13 0x08304ac1 in JOIN::exec (this=0xb6d8df88) at sql_select.cc:2300
#14 0x083051f7 in mysql_select (thd=0x9fedd00, rref_pointer_array=0x9fef798, tables=0xb6d80808, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0,
group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6d8df58, unit=0x9fef3dc, select_lex=0x9fef67c) at sql_select.cc:2501
#15 0x082fd95b in handle_select (thd=0x9fedd00, lex=0x9fef380, result=0xb6d8df58, setup_tables_done_option=0) at sql_select.cc:276
#16 0x0829bf3c in execute_sqlcom_select (thd=0x9fedd00, all_tables=0xb6d80808) at sql_parse.cc:5081
#17 0x08292914 in mysql_execute_command (thd=0x9fedd00) at sql_parse.cc:2265
#18 0x0829e0fd in mysql_parse (thd=0x9fedd00,
inBuf=0xb6d4ecc8 "SELECT table2 .`col_int`\nFROM I LEFT JOIN N table2 ON table2 .`col_varchar_10_latin1` LEFT JOIN F table3 LEFT JOIN L table4 JOIN P table6 ON table6 .`col_int` ON table3 .`col_int_key` = tab"..., length=291, found_semicolon=0xa6eb7230) at sql_parse.cc:6027
#19 0x082903ca in dispatch_command (command=COM_QUERY, thd=0x9fedd00, packet=0x9fefd21 "", packet_length=292) at sql_parse.cc:1184
#20 0x0828f8b8 in do_command (thd=0x9fedd00) at sql_parse.cc:890
#21 0x0828c8f0 in handle_one_connection (arg=0x9fedd00) at sql_connect.cc:1153
#22 0x00bea919 in start_thread () from /lib/libpthread.so.0
#23 0x00b2ccbe in clone () from /lib/libc.so.6
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: Crash in __bzero_sse2 from JOIN_CACHE_BKA_UNIQUE::cleanup_hash_table with join_cache_level = 8
Test case
--source include/have_innodb.inc
SET SESSION join_cache_level = 8;
CREATE TABLE `F` (
`col_varchar_10_utf8_key` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`col_varchar_10_latin1` varchar(10) DEFAULT NULL,
`col_int` int(11) DEFAULT NULL,
`col_int_key` int(11) DEFAULT NULL,
KEY `col_varchar_10_utf8_key` (`col_varchar_10_utf8_key`),
KEY `col_int_key` (`col_int_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `F` VALUES ('BCOIA','going',9,76939264);
INSERT INTO `F` VALUES ('get','v',NULL,NULL);
INSERT INTO `F` VALUES ('itrnayglbw','q',NULL,3);
INSERT INTO `F` VALUES ('ouitrnaygl','QDKGF',9,NULL);
INSERT INTO `F` VALUES ('KBWOG','look',NULL,NULL);
INSERT INTO `F` VALUES ('ehyouitrna','YITGO',4,8);
INSERT INTO `F` VALUES ('c','fvwpehyoui',8,9);
INSERT INTO `F` VALUES ('glswfvwpeh','u',5,5);
INSERT INTO `F` VALUES ('w','qaysglswfv',NULL,6);
INSERT INTO `F` VALUES ('VNVAA','r',NULL,349831168);
CREATE TABLE `N` (
`col_int_key` int(11) DEFAULT NULL,
`col_int` int(11) DEFAULT NULL,
`col_varchar_10_utf8_key` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`col_varchar_10_latin1` varchar(10) DEFAULT NULL,
KEY `col_int_key` (`col_int_key`),
KEY `col_varchar_10_utf8_key` (`col_varchar_10_utf8_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `N` VALUES (4,-1707802624,'wwhanhcjzz','fwwhanhcjz');
INSERT INTO `N` VALUES (-1268908032,NULL,'d','think');
INSERT INTO `N` VALUES (0,3,'j','was');
INSERT INTO `N` VALUES (8,2,'ngyrowgyfw','LZUOE');
INSERT INTO `N` VALUES (0,-1214578688,'s','don\'t');
INSERT INTO `N` VALUES (1,8,'ohfngyrowg','oohfngyrow');
INSERT INTO `N` VALUES (3,NULL,'and','gvoohfngyr');
INSERT INTO `N` VALUES (4,NULL,'x','yeah');
INSERT INTO `N` VALUES (NULL,NULL,'his','x');
INSERT INTO `N` VALUES (1012334592,-1012072448,'rayypigvoo','s');
INSERT INTO `N` VALUES (NULL,1132986368,'up','PRYNJ');
INSERT INTO `N` VALUES (1552613376,374341632,'a','a');
INSERT INTO `N` VALUES (NULL,653000704,'joafdrayyp','YVHIF');
INSERT INTO `N` VALUES (-392691712,NULL,'g','zxjoafdray');
INSERT INTO `N` VALUES (4,3,'cszxjoafdr','you');
INSERT INTO `N` VALUES (NULL,NULL,'q','or');
INSERT INTO `N` VALUES (-1692925952,4,'SNFCA','DSVSL');
INSERT INTO `N` VALUES (NULL,0,'qooagbcszx','HLPLE');
INSERT INTO `N` VALUES (2,6,'q','p');
INSERT INTO `N` VALUES (1318977536,8,'j','j');
INSERT INTO `N` VALUES (-190382080,8,'your','did');
INSERT INTO `N` VALUES (NULL,3,'p','say');
INSERT INTO `N` VALUES (1045889024,NULL,'gxmugamnqo','ztgxmugamn');
INSERT INTO `N` VALUES (NULL,-2013134848,'v','eztgxmugam');
INSERT INTO `N` VALUES (NULL,NULL,'j','would');
INSERT INTO `N` VALUES (NULL,-345636864,'nzcheztgxm','TBDRG');
INSERT INTO `N` VALUES (NULL,-975044608,'the','don\'t');
INSERT INTO `N` VALUES (-445382656,NULL,'no','ZXTXS');
INSERT INTO `N` VALUES (1,NULL,'back','NGNHE');
INSERT INTO `N` VALUES (-1165623296,0,'JNXCI','d');
INSERT INTO `N` VALUES (1406402560,-473628672,'u','SJCZQ');
INSERT INTO `N` VALUES (4,NULL,'a','ddhapqmoun');
INSERT INTO `N` VALUES (9,NULL,'GJNDI','q');
INSERT INTO `N` VALUES (NULL,NULL,'OVWKC','s');
INSERT INTO `N` VALUES (317849600,157155328,'l','they');
INSERT INTO `N` VALUES (567214080,-895811584,'MJLVP','QGUQV');
INSERT INTO `N` VALUES (5,NULL,'kdsziddhap','BFMUG');
INSERT INTO `N` VALUES (-2038169600,981467136,'d','jkdsziddha');
INSERT INTO `N` VALUES (-1323630592,980025344,'gjkdsziddh','AYTIF');
INSERT INTO `N` VALUES (5,-223019008,'ZMSFF','GZQUN');
INSERT INTO `N` VALUES (249167872,NULL,'ok','be');
INSERT INTO `N` VALUES (2,NULL,'ANDFC','s');
INSERT INTO `N` VALUES (NULL,1,'to','NXQPP');
INSERT INTO `N` VALUES (NULL,7,'yeah','was');
INSERT INTO `N` VALUES (2,-1532755968,'ujxdqbdyol','QAOWK');
INSERT INTO `N` VALUES (1,1704656896,'unfrujxdqb','nunfrujxdq');
INSERT INTO `N` VALUES (120258560,NULL,'ZNLOR','for');
INSERT INTO `N` VALUES (-349569024,NULL,'JCQJV','are');
INSERT INTO `N` VALUES (NULL,2067726336,'LNTXE','I');
INSERT INTO `N` VALUES (1035796480,-176553984,'see','HIYLX');
INSERT INTO `N` VALUES (-685506560,8,'can\'t','about');
INSERT INTO `N` VALUES (NULL,5,'BXUZW','my');
INSERT INTO `N` VALUES (-73990144,-103350272,'i','v');
INSERT INTO `N` VALUES (-928972800,1593835520,'r','kpuazineob');
INSERT INTO `N` VALUES (1178861568,NULL,'you','t');
INSERT INTO `N` VALUES (5,1,'UGBQC','insmqkpuaz');
INSERT INTO `N` VALUES (NULL,990117888,'on','ZXBLK');
INSERT INTO `N` VALUES (NULL,NULL,'they','going');
INSERT INTO `N` VALUES (NULL,9,'out','epfkminsmq');
INSERT INTO `N` VALUES (NULL,5,'up','I\'m');
INSERT INTO `N` VALUES (1,-336723968,'z','will');
INSERT INTO `N` VALUES (-1871380480,6,'could','xvmsypepfk');
INSERT INTO `N` VALUES (-2098462720,9,'kjsxvmsype','pkjsxvmsyp');
INSERT INTO `N` VALUES (NULL,2,'tvpkjsxvms','w');
INSERT INTO `N` VALUES (NULL,NULL,'a','YIBLV');
INSERT INTO `N` VALUES (NULL,3,'MAOHE','trkztvpkjs');
INSERT INTO `N` VALUES (1773076480,8,'was','xzbtrkztvp');
INSERT INTO `N` VALUES (5,NULL,'FVREI','s');
INSERT INTO `N` VALUES (0,5,'yhosxzbtrk','s');
INSERT INTO `N` VALUES (NULL,0,'s','SKHZQ');
INSERT INTO `N` VALUES (9,2,'l','how');
INSERT INTO `N` VALUES (-758054912,7,'jdxryhosxz','nwjdxryhos');
INSERT INTO `N` VALUES (3,1,'onwjdxryho','JNPZQ');
INSERT INTO `N` VALUES (-1594359808,NULL,'qonwjdxryh','dqonwjdxry');
INSERT INTO `N` VALUES (-1544421376,NULL,'GHIEZ','fyedqonwjd');
CREATE TABLE `P` (
`col_varchar_10_latin1` varchar(10) DEFAULT NULL,
`col_int_key` int(11) DEFAULT NULL,
`col_int` int(11) DEFAULT NULL,
`col_varchar_10_utf8_key` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
KEY `col_int_key` (`col_int_key`),
KEY `col_varchar_10_utf8_key` (`col_varchar_10_utf8_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `P` VALUES ('when',5,8,'CPFNH');
INSERT INTO `P` VALUES ('o',9,4,'BICZS');
INSERT INTO `P` VALUES ('jtwujigcwi',2,5,'q');
INSERT INTO `P` VALUES ('for',6,1831141376,'IBFIG');
INSERT INTO `P` VALUES ('j',8,1,'back');
INSERT INTO `P` VALUES ('tell',2129461248,8,'xfbwwowjtw');
INSERT INTO `P` VALUES ('DPROS',NULL,2,'esfxfbwwow');
INSERT INTO `P` VALUES ('t',8,1884094464,'SPWAL');
INSERT INTO `P` VALUES ('BJAWJ',-201064448,624492544,'as');
INSERT INTO `P` VALUES ('MPHUR',2,NULL,'WYDPM');
INSERT INTO `P` VALUES ('CIHPU',NULL,8,'y');
INSERT INTO `P` VALUES ('something',7,8,'of');
INSERT INTO `P` VALUES ('DBAET',-2049048576,1,'ZHEZG');
INSERT INTO `P` VALUES ('sicljqxqes',1012531200,6,'as');
INSERT INTO `P` VALUES ('JHCOF',NULL,-952958976,'gsicljqxqe');
INSERT INTO `P` VALUES ('TLSGC',NULL,-1302069248,'jgsicljqxq');
INSERT INTO `P` VALUES ('ZTFHC',6,4,'bdjgsicljq');
INSERT INTO `P` VALUES ('I\'m',NULL,-1233584128,'s');
INSERT INTO `P` VALUES ('n',-1000079360,-1595801600,'y');
INSERT INTO `P` VALUES ('a',7,NULL,'tecmznkvog');
INSERT INTO `P` VALUES ('so',2,NULL,'back');
INSERT INTO `P` VALUES ('right',NULL,NULL,'hwbrjtecmz');
INSERT INTO `P` VALUES ('he\'s',3,NULL,'v');
INSERT INTO `P` VALUES ('p',NULL,8,'hfjhwbrjte');
INSERT INTO `P` VALUES ('q',6,NULL,'ehfjhwbrjt');
INSERT INTO `P` VALUES ('nzmehfjhwb',-188612608,NULL,'u');
INSERT INTO `P` VALUES ('blsnzmehfj',NULL,9,'just');
INSERT INTO `P` VALUES ('LIUBS',1039466496,NULL,'WJVXH');
INSERT INTO `P` VALUES ('AIPMB',135921664,4,'h');
INSERT INTO `P` VALUES ('really',5,4,'TWWKQ');
INSERT INTO `P` VALUES ('u',NULL,NULL,'RYROX');
INSERT INTO `P` VALUES ('well',1309409280,NULL,'WJKRH');
INSERT INTO `P` VALUES ('fnggphjsta',NULL,-499122176,'AOCAS');
INSERT INTO `P` VALUES ('QBYWW',NULL,NULL,'KFQAW');
INSERT INTO `P` VALUES ('they',NULL,NULL,'OIFGE');
INSERT INTO `P` VALUES ('n',-73465856,7,'ukgifnggph');
INSERT INTO `P` VALUES ('HLXDL',NULL,3,'urukgifngg');
INSERT INTO `P` VALUES ('CMBTY',2048720896,6,'g');
INSERT INTO `P` VALUES ('qvvrurukgi',NULL,-97189888,'how');
INSERT INTO `P` VALUES ('FKXYZ',-1112145920,0,'v');
INSERT INTO `P` VALUES ('I',1329397760,NULL,'DUTZE');
INSERT INTO `P` VALUES ('a',NULL,0,'v');
INSERT INTO `P` VALUES ('g',-362676224,2,'VMWBZ');
INSERT INTO `P` VALUES ('e',-1972240384,7,'j');
INSERT INTO `P` VALUES ('TJYPG',4,1,'you\'re');
INSERT INTO `P` VALUES ('y',NULL,NULL,'FAZUP');
INSERT INTO `P` VALUES ('DZLHR',3,708050944,'you\'re');
INSERT INTO `P` VALUES ('itdrehrtcg',NULL,1212088320,'oh');
INSERT INTO `P` VALUES ('xitdrehrtc',NULL,3,'r');
INSERT INTO `P` VALUES ('giyxitdreh',-1916010496,5,'i');
INSERT INTO `P` VALUES ('it',23003136,NULL,'c');
INSERT INTO `P` VALUES ('yeah',-269156352,2,'why');
INSERT INTO `P` VALUES ('wndshsgiyx',NULL,NULL,'j');
INSERT INTO `P` VALUES ('could',NULL,2,'MDOLU');
INSERT INTO `P` VALUES ('n',NULL,2,'me');
INSERT INTO `P` VALUES ('fruhwndshs',4,NULL,'pxfruhwnds');
INSERT INTO `P` VALUES ('j',8,7,'ttpxfruhwn');
INSERT INTO `P` VALUES ('k',-825360384,NULL,'right');
INSERT INTO `P` VALUES ('he',NULL,5,'icqtttpxfr');
INSERT INTO `P` VALUES ('dmiicqtttp',NULL,-196608,'oh');
INSERT INTO `P` VALUES ('h',1245184,NULL,'out');
INSERT INTO `P` VALUES ('z',1501822976,NULL,'in');
INSERT INTO `P` VALUES ('him',8,NULL,'g');
INSERT INTO `P` VALUES ('s',-294125568,NULL,'eoddmsdmii');
INSERT INTO `P` VALUES ('want',NULL,NULL,'meoddmsdmi');
INSERT INTO `P` VALUES ('v',761593856,1307770880,'ACMSI');
INSERT INTO `P` VALUES ('can',NULL,-343736320,'YLPWB');
INSERT INTO `P` VALUES ('are',7,6,'it\'s');
INSERT INTO `P` VALUES ('out',3,NULL,'h');
INSERT INTO `P` VALUES ('CFQCK',NULL,1535180800,'to');
INSERT INTO `P` VALUES ('OWJSG',-1661534208,6,'r');
INSERT INTO `P` VALUES ('p',NULL,-2106654720,'p');
INSERT INTO `P` VALUES ('o',NULL,-1563820032,'atbnvmtoiv');
INSERT INTO `P` VALUES ('HIPDT',4,-1836253184,'it');
INSERT INTO `P` VALUES ('f',NULL,1,'b');
INSERT INTO `P` VALUES ('DRVGW',NULL,9,'or');
INSERT INTO `P` VALUES ('huqlpqwatb',NULL,9,'QCUCD');
INSERT INTO `P` VALUES ('j',NULL,NULL,'v');
INSERT INTO `P` VALUES ('about',NULL,0,'o');
INSERT INTO `P` VALUES ('hbbdymhuql',-143785984,-687603712,'on');
INSERT INTO `P` VALUES ('a',0,5,'mean');
INSERT INTO `P` VALUES ('b',0,6,'and');
INSERT INTO `P` VALUES ('zponshbbdy',NULL,850526208,'all');
INSERT INTO `P` VALUES ('AQOUD',1,-1117782016,'SLUBL');
INSERT INTO `P` VALUES ('from',NULL,5,'maxunfazpo');
INSERT INTO `P` VALUES ('what',-1046413312,8,'from');
INSERT INTO `P` VALUES ('damaxunfaz',1036713984,4,'q');
INSERT INTO `P` VALUES ('OSNCR',1970143232,NULL,'know');
INSERT INTO `P` VALUES ('oxlndamaxu',NULL,NULL,'EPPAH');
INSERT INTO `P` VALUES ('ok',582156288,7,'q');
INSERT INTO `P` VALUES ('ytbqyjoxln',NULL,1,'ecytbqyjox');
INSERT INTO `P` VALUES ('tgiecytbqy',5,2,'hytgiecytb');
INSERT INTO `P` VALUES ('me',-1197277184,NULL,'x');
INSERT INTO `P` VALUES ('that\'s',NULL,1524432896,'EGBVE');
INSERT INTO `P` VALUES ('his',4,4,'svrhytgiec');
INSERT INTO `P` VALUES ('c',NULL,1,'d');
INSERT INTO `P` VALUES ('b',NULL,NULL,'come');
INSERT INTO `P` VALUES ('you\'re',2013528064,NULL,'PTCOC');
INSERT INTO `P` VALUES ('LDPDC',NULL,8,'could');
INSERT INTO `P` VALUES ('n',NULL,1025572864,'back');
CREATE TABLE `I` (
`col_int_key` int(11) DEFAULT NULL,
`col_varchar_10_latin1` varchar(10) DEFAULT NULL,
`col_varchar_10_utf8_key` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`col_int` int(11) DEFAULT NULL,
KEY `col_int_key` (`col_int_key`),
KEY `col_varchar_10_utf8_key` (`col_varchar_10_utf8_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `I` VALUES (NULL,'tgtqlobtqa','me',-827392000);
INSERT INTO `I` VALUES (-1445330944,'well','VPHFZ',-1853554688);
INSERT INTO `I` VALUES (-540803072,'vlaztgtqlo','rvlaztgtql',NULL);
INSERT INTO `I` VALUES (NULL,'your','x',NULL);
INSERT INTO `I` VALUES (NULL,'l','JAJVR',-1296039936);
INSERT INTO `I` VALUES (NULL,'sfoyrvlazt','OCZCX',1);
INSERT INTO `I` VALUES (NULL,'j','toksfoyrvl',NULL);
INSERT INTO `I` VALUES (-1375666176,'tjtoksfoyr','atjtoksfoy',1774125056);
INSERT INTO `I` VALUES (-1001062400,'u','v',NULL);
INSERT INTO `I` VALUES (NULL,'hnqxatjtok','u',5);
INSERT INTO `I` VALUES (7,'to','slhnqxatjt',NULL);
INSERT INTO `I` VALUES (617283584,'good','be',1549336576);
INSERT INTO `I` VALUES (8,'u','x',-327286784);
INSERT INTO `I` VALUES (986185728,'going','u',4);
INSERT INTO `I` VALUES (4,'hojnswsmyh','XCIHC',-2105933824);
INSERT INTO `I` VALUES (800325632,'for','VLOVA',5);
INSERT INTO `I` VALUES (NULL,'i','LGTNG',-1116733440);
INSERT INTO `I` VALUES (12189696,'i','she',7);
INSERT INTO `I` VALUES (-875823104,'JTRTH','at',NULL);
INSERT INTO `I` VALUES (NULL,'ajddcmshoj','out',1);
INSERT INTO `I` VALUES (-1514733568,'RBKRT','VLUMG',2);
INSERT INTO `I` VALUES (3,'FIWYO','really',3);
INSERT INTO `I` VALUES (4,'RKYIL','zmuuoajddc',-737345536);
INSERT INTO `I` VALUES (9,'IUPXW','QMOQT',-1832976384);
INSERT INTO `I` VALUES (NULL,'i','would',NULL);
CREATE TABLE `L` (
`col_varchar_10_latin1` varchar(10) DEFAULT NULL,
`col_int_key` int(11) DEFAULT NULL,
`col_varchar_10_utf8_key` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`col_int` int(11) DEFAULT NULL,
KEY `col_int_key` (`col_int_key`),
KEY `col_varchar_10_utf8_key` (`col_varchar_10_utf8_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `L` VALUES ('vawvtjsjmw',NULL,'FNUVW',9);
INSERT INTO `L` VALUES ('it',2063073280,'m',3);
INSERT INTO `L` VALUES ('do',1198981120,'KVZOJ',NULL);
INSERT INTO `L` VALUES ('n',334430208,'z',1386414080);
INSERT INTO `L` VALUES ('i',6,'with',-864681984);
INSERT INTO `L` VALUES ('think',5,'okay',-383713280);
INSERT INTO `L` VALUES ('krkpymvawv',-1671954432,'his',0);
INSERT INTO `L` VALUES ('WATCS',3,'JIIZH',0);
INSERT INTO `L` VALUES ('when',NULL,'bfmrhpkrkp',9);
INSERT INTO `L` VALUES ('a',0,'SYPYE',1255538688);
INSERT INTO `L` VALUES ('e',1262354432,'MIPDN',NULL);
INSERT INTO `L` VALUES ('IAFEM',2,'TPBBT',662437888);
INSERT INTO `L` VALUES ('b',NULL,'something',212664320);
INSERT INTO `L` VALUES ('s',2127167488,'I',NULL);
INSERT INTO `L` VALUES ('cfladpbfmr',5,'kncfladpbf',3);
INSERT INTO `L` VALUES ('from',NULL,'FKKYU',-1975123968);
INSERT INTO `L` VALUES ('oh',1457717248,'y',9);
INSERT INTO `L` VALUES ('qhcjlkncfl',NULL,'IZBYM',4);
INSERT INTO `L` VALUES ('x',-2074148864,'c',5);
INSERT INTO `L` VALUES ('e',-786300928,'q',1665794048);
INSERT INTO `L` VALUES ('this',NULL,'abceftjqhc',3);
INSERT INTO `L` VALUES ('wpabceftjq',-440074240,'c',289931264);
INSERT INTO `L` VALUES ('FGMQT',5,'xhkwpabcef',5);
INSERT INTO `L` VALUES ('qxhkwpabce',NULL,'well',1868103680);
INSERT INTO `L` VALUES ('t',-638320640,'xgqxhkwpab',185729024);
INSERT INTO `L` VALUES ('a',1325989888,'hfqxgqxhkw',NULL);
INSERT INTO `L` VALUES ('i',0,'BZETU',NULL);
INSERT INTO `L` VALUES ('AYGKR',5,'GVAZP',NULL);
INSERT INTO `L` VALUES ('now',3,'NHXTB',8);
INSERT INTO `L` VALUES ('qrpjhfqxgq',5,'well',NULL);
INSERT INTO `L` VALUES ('don\'t',NULL,'BYDXQ',NULL);
INSERT INTO `L` VALUES ('mean',2,'pzbfqrpjhf',1037893632);
INSERT INTO `L` VALUES ('dpzbfqrpjh',NULL,'g',NULL);
INSERT INTO `L` VALUES ('h',-1414463488,'POQLV',NULL);
INSERT INTO `L` VALUES ('j',NULL,'d',NULL);
INSERT INTO `L` VALUES ('g',NULL,'me',NULL);
INSERT INTO `L` VALUES ('iprkxvydpz',NULL,'j',8);
INSERT INTO `L` VALUES ('x',NULL,'n',-304873472);
INSERT INTO `L` VALUES ('v',-427884544,'have',NULL);
INSERT INTO `L` VALUES ('r',1338834944,'uvhszeyipr',NULL);
INSERT INTO `L` VALUES ('thuvhszeyi',-1928921088,'be',NULL);
INSERT INTO `L` VALUES ('zhthuvhsze',NULL,'then',-521535488);
INSERT INTO `L` VALUES ('s',NULL,'MMJUE',6);
INSERT INTO `L` VALUES ('vbwzhthuvh',NULL,'tvbwzhthuv',NULL);
INSERT INTO `L` VALUES ('you',-1019805696,'DOAVX',NULL);
INSERT INTO `L` VALUES ('yes',3,'atoxtvbwzh',-505806848);
INSERT INTO `L` VALUES ('oh',2115436544,'can\'t',-1777139712);
INSERT INTO `L` VALUES ('eatoxtvbwz',6,'BBFEJ',NULL);
INSERT INTO `L` VALUES ('x',8,'WELWD',737738752);
INSERT INTO `L` VALUES ('zrzoeatoxt',NULL,'ZEQJV',NULL);
SELECT table2 .`col_int`
FROM I LEFT JOIN N table2 ON table2 .`col_varchar_10_latin1` LEFT JOIN F table3 LEFT JOIN L table4 JOIN P table6 ON table6 .`col_int` ON table3 .`col_int_key` = table4 .`col_int_key` ON table2 .`col_varchar_10_latin1` = table6 .`col_varchar_10_utf8_key`;
Re: Crash in __bzero_sse2 from JOIN_CACHE_BKA_UNIQUE::cleanup_hash_table with join_cache_level = 8
I failed to reproduce this bug on the current 5,3 tree with the submitted test case.
Launchpad bug id: 636922
Re: Crash in __bzero_sse2 from JOIN_CACHE_BKA_UNIQUE::cleanup_hash_table with join_cache_level = 8
Valgrind warnings:
==28984== Invalid write of size 8
==28984== at 0xB774F4: __bzero_sse2 (in /lib/libc-2.12.so)
==28984== by 0x82DA95C: JOIN_CACHE_BKA_UNIQUE::reset(bool) (sql_join_cache.cc:2659)
==28984== by 0x82D92CF: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:1709)
==28984== by 0x82D9101: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:1650)
==28984== by 0x831EF5F: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:12822)
==28984== by 0x831F178: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:12984)
==28984== by 0x831E732: do_select(JOIN*, List<Item>, st_table, Procedure*) (sql_select.cc:12580)
==28984== by 0x8304AC0: JOIN::exec() (sql_select.cc:2300)
==28984== by 0x83051F6: mysql_select(THD*, Item**, TABLE_LIST, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2501)
==28984== by 0x82FD95A: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:276)
==28984== by 0x829BF3B: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5081)
==28984== by 0x8292913: mysql_execute_command(THD*) (sql_parse.cc:2265)
==28984== by 0x829E0FC: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:6027)
==28984== by 0x82903C9: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1184)
==28984== by 0x828F8B7: do_command(THD*) (sql_parse.cc:890)
==28984== by 0x828C8EF: handle_one_connection (sql_connect.cc:1153)
==28984== Address 0x7a5d5d0 is 120,672 bytes inside a block of size 131,072 free'd
==28984== at 0x40057F6: free (vg_replace_malloc.c:325)
==28984== by 0x873A406: my_no_flags_free (my_malloc.c:62)
==28984== by 0x833004D: JOIN_CACHE::free() (sql_select.h:771)
==28984== by 0x8311FB0: set_join_cache_denial(st_join_table*) (sql_select.cc:7087)
==28984== by 0x83120EC: revise_cache_usage(st_join_table*) (sql_select.cc:7194)
==28984== by 0x83129DD: check_join_cache_usage(st_join_table*, JOIN*, unsigned long long, unsigned int, bool*) (sql_select.cc:7476)
==28984== by 0x8312F53: make_join_readinfo(JOIN*, unsigned long long, unsigned int) (sql_select.cc:7601)
==28984== by 0x8300B05: JOIN::optimize() (sql_select.cc:1281)
==28984== by 0x8305171: mysql_select(THD*, Item**, TABLE_LIST, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2487)
==28984== by 0x82FD95A: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:276)
==28984== by 0x829BF3B: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5081)
==28984== by 0x8292913: mysql_execute_command(THD*) (sql_parse.cc:2265)
==28984== by 0x829E0FC: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:6027)
==28984== by 0x82903C9: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1184)
==28984== by 0x828F8B7: do_command(THD*) (sql_parse.cc:890)
==28984== by 0x828C8EF: handle_one_connection (sql_connect.cc:1153)