Crash in QUICK_RANGE_SELECT::reset with derived_with_keys
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Undecided
|
Sergey Petrunia |
Bug Description
backtrace:
#4 <signal handler called>
#5 0x083d3cbd in QUICK_RANGE_
#6 0x083eb06a in find_all_keys (param=0xae8fdef4, select=0xae536ea0, sort_keys=
at filesort.cc:561
#7 0x083ea0bf in filesort (thd=0x9a286f8, table=0xae72a018, sortorder=
sort_
#8 0x08345291 in create_sort_index (thd=0x9a286f8, join=0xae72d8a8, order=0xae714350, filesort_
select_
#9 0x08321d9a in JOIN::exec (this=0xae72d8a8) at sql_select.cc:2622
#10 0x08322872 in mysql_select (thd=0x9a286f8, rref_pointer_
order=
at sql_select.cc:2900
#11 0x0831a76f in handle_select (thd=0x9a286f8, lex=0x9a29dfc, result=0xae7143f8, setup_tables_
#12 0x082b4ef0 in execute_
#13 0x082abcad in mysql_execute_
#14 0x082b751f in mysql_parse (thd=0x9a286f8,
rawbuf=
#15 0x082a98fc in dispatch_command (command=COM_QUERY, thd=0x9a286f8,
packet=
#16 0x082a8d57 in do_command (thd=0x9a286f8) at sql_parse.cc:916
#17 0x082a5d3b in handle_
#18 0x00821919 in start_thread () from /lib/libpthread
#19 0x0076acce in clone () from /lib/libc.so.6
explain:
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t3 system NULL NULL NULL NULL 1 Using filesort
1 PRIMARY <derived2> ref key0 key0 55 const 10 Using where
2 DERIVED t1 ALL NULL NULL NULL NULL 12
2 DERIVED t2 ALL NULL NULL NULL NULL 841 Using join buffer (flat, BNL join)
minimal switch: derived_merge=on
full switch: index_merge=
bzr version-info
revision-id: <email address hidden>
date: 2011-10-28 11:23:30 +0400
build-date: 2011-10-28 12:15:13 +0300
revno: 3257
branch-nick: maria-5.3
Changed in maria: | |
assignee: | Igor Babaev (igorb-seattle) → Sergey Petrunia (sergefp) |
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
test case:
CREATE TABLE t2 ( pk varchar(33), col_varchar_key varchar(3) NOT NULL , col_varchar_nokey varchar(52) NOT NULL ) ; ,'NIC', 'Spanish' ),('NERHausa' ,'NER', 'Hausa' ),('NGAJoruba' ,'NGA', 'Joruba' ),('NIUNiue' ,'NIU', 'Niue') ,('NFKEnglish' ,'NFK', 'English' ),('NORNorwegia n','NOR' ,'Norwegian' ),('CIVAkan' ,'CIV', 'Akan') ,('OMNArabic' ,'OMN', 'Arabic' ),('PAKPunjabi' ,'PAK', 'Punjabi' ),('PLWPalau' ,'PLW', 'Palau' ),('PANSpanish' ,'PAN', 'Spanish' ),('PNGPapuan Langua' ,'PNG', 'Papuan Languages' ),('PRYSpanish' ,'PRY', 'Spanish' ),('PERSpanish' ,'PER', 'Spanish' ),('PCNPitcairn ese','PCN' ,'Pitcairnese' ),('MNPPhilippe ne La','MNP' ,'Philippene Langu') ,('PRTPortugues e','PRT' ,'Portuguese' ),('PRISpanish' ,'PRI', 'Spanish' ),('POLPolish' ,'POL', 'Polish' ),('GNQFang' ,'GNQ', 'Fang') ,('QATArabic' ,'QAT', 'Arabic' ),('FRAFrench' ,'FRA', 'French' ),('GUFCreole French' ,'GUF', 'Creole French' ),('PYFTahitian ','PYF' ,'Tahitian' ),('REUCreole French' ,'REU', 'Creole French' ),('ROMRomanian ','ROM' ,'Romanian' ),('RWARwanda' ,'RWA', 'Rwanda' ),('SWESwedish' ,'SWE', 'Swedish' ),('SHNEnglish' ,'SHN', 'English' ),('KNACreole Englis' ,'KNA', 'Creole English' ),('LCACreole French' ,'LCA', 'Creole French' ),('VCTCreole Englis' ,'VCT', 'Creole English' ),('SPMFrench' ,'SPM', 'French' ),('DEUGerman' ,'DEU', 'German' ),('SLBMalenasi an La','SLB' ,'Malenasian Langu') ,('ZMBBemba' ,'ZMB', 'Bemba' ),('WSMSamoan- Englis' ,'WSM', 'Samoan- English' ),('SMRItalian' ,'SMR', 'Italian' ),('STPCrioulo' ,'STP', 'Crioulo' ),('SAUArabic' ,'SAU', 'Arabic' ),('SENWolof' ,'SEN', 'Wolof' ),('SYCSeselwa' ,'SYC', 'Seselwa' ),('SLEMende' ,'SLE', 'Mende' ),('SGPChinese' ,'SGP', 'Chinese' ),('SVKSlovak' ,'SVK', 'Slovak' ),('SVNSlovene' ,'SVN', 'Slovene' ),('SOMSomali' ,'SOM', 'Somali' ),('LKASingali' ,'LKA', 'Singali' ),('SDNArabic' ,'SDN', 'Arabic' ),('FINFinnish' ,'FIN', 'Finnish' ),('SURSrananto nga','SUR' ,'Sranantonga' ),('SWZSwazi' ,'SWZ', 'Swazi' ),('CHEGerman' ,'CHE', 'German' ),('SYRArabic' ,'SYR', 'Arabic' ),('TJKTadzhik' ,'TJK', 'Tadzhik' ),('TWNMin' ,'TWN', 'Min'), ('TZANyamwesi' ,'TZA', 'Nyamwesi' ),('DNKDanish' ,'DNK', 'Danish' ),('THAThai' ,'THA', 'Thai') ,('TGOEwe' ,'TGO', 'Ewe'), ('TKLTokelau' ,'TKL', 'Tokelau' ),('TONTongan' ,'TON', 'Tongan' ),('TTOEnglish' ,'TTO', 'English' ),('TCDSara' ,'TCD', 'Sara') ,('CZECzech' ,'CZE', 'Czech' ),('TUNArabic' ,'TUN', 'Arabic' ),('TURTurkish' ,'TUR', 'Turkish' ),('TKMTurkmeni an','TKM' ,'Turkmenian' ),('TCAEnglish' ,'TCA', 'English' ),('TUVTuvalu' ,'TUV', 'Tuvalu' ),('UGAGanda' ,'UGA', 'Ganda' ),('UKRUkrainia n','UKR' ,'Ukrainian' ),('HUNHungaria n','HUN' ,'Hungarian' ),('URYSpanish' ,'URY', 'Spanish' ),('NCLMalenasi an La','NCL' ,'Malenasian Langu') ,('NZLEnglish' ,'NZL', 'English' ),('UZBUzbek' ,'UZB', 'Uzbek' ),('BLRBeloruss ian','BLR' ,'Belorussian' ),('WLFWallis' ,'WLF', 'Wallis' ),('VUTBislama' ,'VUT', 'Bislama' ),('VATItalian' ,'VAT', 'Italian' ),('VENSpanish' ,'VEN', 'Spanish' ),('RUSRussian' ,'RUS', 'Russian' ),('VNMVietname se','VNM' ,'Vietnamese' ),('ESTEstonian ','EST' ,'Estonian' ),('USAEnglish' ,'USA', 'English' ),('VIREnglish' ,'VIR', 'English' ),('UMIEnglish' ,'UMI', 'English' ),('ZWEShona' ,'ZWE', 'Shona' ),('PSEArabic' ,'PSE', 'Arabic' ),('AFGDari' ,'AFG', 'Dari') ,('NLDFries' ,'NLD', 'Fries' ),('ANTEnglish' ,'ANT', 'English' ),('ALBGreek' ,'ALB', 'Greek' ),('DZABerberi' ,'DZA', 'Berberi' ),('ASMEnglish' ,'ASM', 'English' ),('ANDCatalan' ,'AND.. .
INSERT INTO t2 VALUES ('NICSpanish'