Re: Crash in QUICK_RANGE_SELECT::reset with derived_with_keys
test case:

CREATE TABLE t2 ( pk varchar(33), col_varchar_key varchar(3) NOT NULL , col_varchar_nokey varchar(52) NOT NULL ) ;
INSERT INTO t2 VALUES ('NICSpanish','NIC','Spanish'),('NERHausa','NER','Hausa'),('NGAJoruba','NGA','Joruba'),('NIUNiue','NIU','Niue'),('NFKEnglish','NFK','English'),('NORNorwegian','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'),('PCNPitcairnese','PCN','Pitcairnese'),('MNPPhilippene La','MNP','Philippene Langu'),('PRTPortuguese','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'),('SLBMalenasian 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'),('SURSranantonga','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'),('TKMTurkmenian','TKM','Turkmenian'),('TCAEnglish','TCA','English'),('TUVTuvalu','TUV','Tuvalu'),('UGAGanda','UGA','Ganda'),('UKRUkrainian','UKR','Ukrainian'),('HUNHungarian','HUN','Hungarian'),('URYSpanish','URY','Spanish'),('NCLMalenasian La','NCL','Malenasian Langu'),('NZLEnglish','NZL','English'),('UZBUzbek','UZB','Uzbek'),('BLRBelorussian','BLR','Belorussian'),('WLFWallis','WLF','Wallis'),('VUTBislama','VUT','Bislama'),('VATItalian','VAT','Italian'),('VENSpanish','VEN','Spanish'),('RUSRussian','RUS','Russian'),('VNMVietnamese','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','Catalan'),('AGOMbundu','AGO','Mbundu'),('ATGEnglish','ATG','English'),('AREHindi','ARE','Hindi'),('ARGItalian','ARG','Italian'),('ARMAzerbaijani','ARM','Azerbaijani'),('ABWEnglish','ABW','English'),('AUSItalian','AUS','Italian'),('AZERussian','AZE','Russian'),('BHSCreole French','BHS','Creole French'),('BHREnglish','BHR','English'),('BGDChakma','BGD','Chakma'),('BRBEnglish','BRB','English'),('BELFrench','BEL','French'),('BLZSpanish','BLZ','Spanish'),('BENJoruba','BEN','Joruba'),('BTNNepali','BTN','Nepali'),('BOLKetšu','BOL','Ketšua'),('BWAShona','BWA','Shona'),('BRAGerman','BRA','German'),('GBRKymri','GBR','Kymri'),('BRNMalay-English','BRN','Malay-English'),('BGRTurkish','BGR','Turkish'),('BFAFul','BFA','Ful'),('BDIFrench','BDI','French'),('CHLAraucan','CHL','Araucan'),('COKEnglish','COK','English'),('CRICreole Englis','CRI','Creole English'),('DJIAfar','DJI','Afar'),('DMACreole French','DMA','Creole French'),('DOMCreole French','DOM','Creole French'),('ECUKetšu','ECU','Ketšua'),('EGYSinaberberi','EGY','Sinaberberi'),('SLVNahua','SLV','Nahua'),('ERITigre','ERI','Tigre'),('ESPCatalan','ESP','Catalan'),('ZAFXhosa','ZAF','Xhosa'),('ETHAmhara','ETH','Amhara'),('FJIHindi','FJI','Hindi'),('PHLCebuano','PHL','Cebuano'),('FRODanish','FRO','Danish'),('GABPunu-sira-nze','GAB','Punu-sira-nzebi'),('GMBFul','GMB','Ful'),('GEORussian','GEO','Russian'),('GHAMossi','GHA','Mossi'),('GIBArabic','GIB','Arabic'),('GRLDanish','GRL','Danish'),('GLPFrench','GLP','French'),('GUMChamorro','GUM','Chamorro'),('GTMQuiché','GTM','Quiché'),('GINMalinke','GIN','Malinke'),('GNBFul','GNB','Ful'),('GUYCaribbean','GUY','Caribbean'),('HTIFrench','HTI','French'),('HNDGarifuna','HND','Garifuna'),('HKGEnglish','HKG','English'),('SJMRussian','SJM','Russian'),('IDNSunda','IDN','Sunda'),('INDBengali','IND','Bengali'),('IRQKurdish','IRQ','Kurdish'),('IRNAzerbaijani','IRN','Azerbaijani'),('IRLIrish','IRL','Irish'),('ISLEnglish','ISL','English'),('ISRArabic','ISR','Arabic'),('ITASardinian','ITA','Sardinian'),('TMPPortuguese','TMP','Portuguese'),('AUTSerbo-Croatia','AUT','Serbo-Croatian'),('JAMHindi','JAM','Hindi'),('JPNKorean','JPN','Korean'),('YEMSoqutri','YEM','Soqutri'),('JORCircassian','JOR','Circassian'),('CXREnglish','CXR','English'),('YUGAlbaniana','YUG','Albaniana'),('KHMVietnamese','KHM','Vietnamese'),('CMRBamileke-bamu','CMR','Bamileke-bamum'),('CANFrench','CAN','French'),('CPVPortuguese','CPV','Portuguese'),('KAZRussian','KAZ','Russian'),('KENLuhya','KEN','Luhya'),('CAFBanda','CAF','Banda'),('CHNZhuang','CHN','Zhuang'),('KGZRussian','KGZ','Russian'),('KIRTuvalu','KIR','Tuvalu'),('COLChibcha','COL','Chibcha'),('COMComorian-Fren','COM','Comorian-French'),('COGTeke','COG','Teke'),('CODKongo','COD','Kongo'),('CCKEnglish','CCK','English'),('PRKChinese','PRK','Chinese'),('KORChinese','KOR','Chinese'),('GRCTurkish','GRC','Turkish'),('HRVSlovene','HRV','Slovene'),('KWTEnglish','KWT','English'),('CYPTurkish','CYP','Turkish'),('LAOMon-khmer','LAO','Mon-khmer'),('LVARussian','LVA','Russian'),('LSOZulu','LSO','Zulu'),('LBNArmenian','LBN','Armenian'),('LBRBassa','LBR','Bassa'),('LBYBerberi','LBY','Berberi'),('LIEItalian','LIE','Italian'),('LTURussian','LTU','Russian'),('LUXPortuguese','LUX','Portuguese'),('MACPortuguese','MAC','Portuguese'),('MDGFrench','MDG','French'),('MKDAlbaniana','MKD','Albaniana'),('MWILomwe','MWI','Lomwe'),('MDVEnglish','MDV','English'),('MYSChinese','MYS','Chinese'),('MLIFul','MLI','Ful'),('MLTEnglish','MLT','English'),('MARBerberi','MAR','Berberi'),('MHLEnglish','MHL','English'),('MTQFrench','MTQ','French'),('MRTWolof','MRT','Wolof'),('MUSBhojpuri','MUS','Bhojpuri'),('MYTFrench','MYT','French'),('MEXNáhuat','MEX','Náhuatl'),('FSMPohnpei','FSM','Pohnpei'),('MDARussian','MDA','Russian'),('MCOMonegasque','MCO','Monegasque'),('MNGKazakh','MNG','Kazakh'),('MOZTsonga','MOZ','Tsonga'),('MMRShan','MMR','Shan'),('NAMNama','NAM','Nama'),('NRUKiribati','NRU','Kiribati'),('NPLMaithili','NPL','Maithili'),('NICMiskito','NIC','Miskito'),('NERSonghai-zerma','NER','Songhai-zerma'),('NGAHausa','NGA','Hausa'),('NIUEnglish','NIU','English'),('NOREnglish','NOR','English'),('CIVGur','CIV','Gur'),('OMNBalochi','OMN','Balochi'),('PAKPashto','PAK','Pashto'),('PLWPhilippene La','PLW','Philippene Langu'),('PANCreole Englis','PAN','Creole English'),('PNGMalenasian La','PNG','Malenasian Langu'),('PRYGuaranÃÂ▒','PRY','Guaraní'),('PERKetšu','PER','Ketšua'),('MNPChamorro','MNP','Chamorro'),('PRIEnglish','PRI','English'),('POLGerman','POL','German'),('GNQBubi','GNQ','Bubi'),('QATUrdu','QAT','Urdu'),('FRAArabic','FRA','Arabic'),('GUFIndian Langua','GUF','Indian Languages'),('PYFFrench','PYF','French'),('REUChinese','REU','Chinese'),('ROMHungarian','ROM','Hungarian'),('RWAFrench','RWA','French'),('SWEFinnish','SWE','Finnish'),('KNAEnglish','KNA','English'),('LCAEnglish','LCA','English'),('VCTEnglish','VCT','English'),('DEUTurkish','DEU','Turkish'),('SLBPapuan Langua','SLB','Papuan Languages'),('ZMBTongan','ZMB','Tongan'),('WSMSamoan','WSM','Samoan'),('STPFrench','STP','French'),('SENFul','SEN','Ful'),('SYCEnglish','SYC','English'),('SLETemne','SLE','Temne'),('SGPMalay','SGP','Malay'),('SVKHungarian','SVK','Hungarian'),('SVNSerbo-Croatia','SVN','Serbo-Croatian'),('SOMArabic','SOM','Arabic'),('LKATamil','LKA','Tamil'),('SDNDinka','SDN','Dinka'),('FINSwedish','FIN','Swedish'),('SURHindi','SUR','Hindi'),('SWZZulu','SWZ','Zulu'),('CHEFrench','CHE','French'),('SYRKurdish','SYR','Kurdish'),('TJKUzbek','TJK','Uzbek'),('TWNMandarin Chin','TWN','Mandarin Chinese'),('TZASwahili','TZA','Swahili'),('DNKTurkish','DNK','Turkish'),('THALao','THA','Lao'),('TGOKabyé','TGO','Kabyé'),('TKLEnglish','TKL','English'),('TONEnglish','TON','English'),('TTOHindi','TTO','Hindi'),('TCDArabic','TCD','Arabic'),('CZEMoravian','CZE','Moravian'),('TUNArabic-French','TUN','Arabic-French'),('TURKurdish','TUR','Kurdish'),('TKMUzbek','TKM','Uzbek'),('TUVKiribati','TUV','Kiribati'),('UGANkole','UGA','Nkole'),('UKRRussian','UKR','Russian'),('HUNRomani','HUN','Romani'),('NCLFrench','NCL','French'),('NZLMaori','NZL','Maori'),('UZBRussian','UZB','Russian'),('BLRRussian','BLR','Russian'),('WLFFutuna','WLF','Futuna'),('VUTEnglish','VUT','English'),('VENGoajiro','VEN','Goajiro'),('RUSTatar','RUS','Tatar'),('VNMTho','VNM','Tho'),('ESTRussian','EST','Russian'),('USASpanish','USA','Spanish'),('VIRSpanish','VIR','Spanish'),('ZWENdebele','ZWE','Ndebele'),('PSEHebrew','PSE','Hebrew'),('AFGUzbek','AFG','Uzbek'),('NLDArabic','NLD','Arabic'),('ANTDutch','ANT','Dutch'),('ALBMacedonian','ALB','Macedonian'),('ASMTongan','ASM','Tongan'),('ANDPortuguese','AND','Portuguese'),('AGOKongo','AGO','Kongo'),('ARGIndian Langua','ARG','Indian Languages'),('ABWSpanish','ABW','Spanish'),('AUSGreek','AUS','Greek'),('AZELezgian','AZE','Lezgian'),('BGDMarma','BGD','Marma'),('BELItalian','BEL','Italian'),('BLZMaya Language','BLZ','Maya Languages'),('BENAdja','BEN','Adja'),('BTNAsami','BTN','Asami'),('BOLAimará','BOL','Aimará'),('BWASan','BWA','San'),('BRAItalian','BRA','Italian'),('GBRGaeli','GBR','Gaeli'),('BRNChinese','BRN','Chinese'),('BGRRomani','BGR','Romani'),('BFAGurma','BFA','Gurma'),('BDISwahili','BDI','Swahili'),('CHLAimará','CHL','Aimará'),('CRIChibcha','CRI','Chibcha'),('DJIArabic','DJI','Arabic'),('ERIAfar','ERI','Afar'),('ESPGalecian','ESP','Galecian'),('ZAFAfrikaans','ZAF','Afrikaans'),('ETHTigrinja','ETH','Tigrinja'),('PHLIlocano','PHL','Ilocano'),('GABMpongwe','GAB','Mpongwe'),('GMBWolof','GMB','Wolof'),('GEOArmenian','GEO','Armenian'),('GHAEwe','GHA','Ewe'),('GUMPhilippene La','GUM','Philippene Langu'),('GTMCakchiquel','GTM','Cakchiquel'),('GINSusu','GIN','Susu'),('GNBBalante','GNB','Balante'),('GUYArawakan','GUY','Arawakan'),('HNDCreole Englis','HND','Creole English'),('HKGFukien','HKG','Fukien'),('IDNMalay','IDN','Malay'),('INDTelugu','IND','Telugu'),('IRQAzerbaijani','IRQ','Azerbaijani'),('IRNKurdish','IRN','Kurdish'),('ISRRussian','ISR','Russian'),('ITAFriuli','ITA','Friuli'),('AUTTurkish','AUT','Turkish'),('JPNChinese','JPN','Chinese'),('JORArmenian','JOR','Armenian'),('YUGHungarian','YUG','Hungarian'),('KHMChinese','KHM','Chinese'),('CMRDuala','CMR','Duala'),('CANChinese','CAN','Chinese'),('KAZUkrainian','KAZ','Ukrainian'),('KENLuo','KEN','Luo'),('CAFMandjia','CAF','Mandjia'),('CHNMantš','CHN','Mantšu'),('KGZUzbek','KGZ','Uzbek'),('COLCreole Englis','COL','Creole English'),('COMComorian-mada','COM','Comorian-madagas'),('COGMboshi','COG','Mboshi'),('CODMongo','COD','Mongo'),('LAOThai','LAO','Thai'),('LVABelorussian','LVA','Belorussian'),('LSOEnglish','LSO','English'),('LBNFrench','LBN','French'),('LBRGrebo','LBR','Grebo'),('LIETurkish','LIE','Turkish'),('LTUPolish','LTU','Polish'),('LUXItalian','LUX','Italian'),('MACMandarin Chin','MAC','Mandarin Chinese'),('MKDTurkish','MKD','Turkish'),('MWIYao','MWI','Yao'),('MYSTamil','MYS','Tamil'),('MLISenufo and Mi','MLI','Senufo and Minia'),('MRTTukulor','MRT','Tukulor'),('MUSFrench','MUS','French'),('MYTMalagasy','MYT','Malagasy'),('MEXYucatec','MEX','Yucatec'),('FSMMortlock','FSM','Mortlock'),('MDAUkrainian','MDA','Ukrainian'),('MCOItalian','MCO','Italian'),('MNGDorbet','MNG','Dorbet'),('MOZSena','MOZ','Sena'),('MMRKaren','MMR','Karen'),('NAMKavango','NAM','Kavango'),('NRUChinese','NRU','Chinese'),('NPLBhojpuri','NPL','Bhojpuri'),('NICCreole Englis','NIC','Creole English'),('NERTamashek','NER','Tamashek'),('NGAIbo','NGA','Ibo'),('NORDanish','NOR','Danish'),('CIVMalinke','CIV','Malinke'),('PAKSindhi','PAK','Sindhi'),('PLWEnglish','PLW','English'),('PANGuaymí','PAN','Guaymí'),('PRYPortuguese','PRY','Portuguese'),('PERAimará','PER','Aimará'),('MNPChinese','MNP','Chinese'),('POLUkrainian','POL','Ukrainian'),('FRAPortuguese','FRA','Portuguese'),('PYFChinese','PYF','Chinese'),('REUComorian','REU','Comorian'),('ROMRomani','ROM','Romani'),('SWESouthern Slav','SWE','Southern Slavic '),('DEUSouthern Slav','DEU','Southern Slavic '),('SLBPolynesian La','SLB','Polynesian Langu'),('ZMBNyanja','ZMB','Nyanja'),('WSMEnglish','WSM','English'),('SENSerer','SEN','Serer'),('SYCFrench','SYC','French'),('SLELimba','SLE','Limba'),('SGPTamil','SGP','Tamil'),('SVKRomani','SVK','Romani'),('SVNHungarian','SVN','Hungarian'),('LKAMixed Languag','LKA','Mixed Languages'),('SDNNubian Langua','SDN','Nubian Languages'),('FINRussian','FIN','Russian'),('CHEItalian','CHE','Italian'),('TJKRussian','TJK','Russian'),('TWNHakka','TWN','Hakka'),('TZAHehet','TZA','Hehet'),('DNKArabic','DNK','Arabic'),('THAChinese','THA','Chinese'),('TGOWatyi','TGO','Watyi'),('TTOCreole Englis','TTO','Creole English'),('TCDMayo-kebbi','TCD','Mayo-kebbi'),('CZESlovak','CZE','Slovak'),('TUNArabic-French','TUN','Arabic-French-En'),('TURArabic','TUR','Arabic'),('TKMRussian','TKM','Russian'),('TUVEnglish','TUV','English'),('UGAKiga','UGA','Kiga'),('UKRRomanian','UKR','Romanian'),('HUNGerman','HUN','German'),('NCLPolynesian La','NCL','Polynesian Langu'),('UZBTadzhik','UZB','Tadzhik'),('BLRUkrainian','BLR','Ukrainian'),('VUTFrench','VUT','French'),('VENWarrau','VEN','Warrau'),('RUSUkrainian','RUS','Ukrainian'),('VNMThai','VNM','Thai'),('ESTUkrainian','EST','Ukrainian'),('USAFrench','USA','French'),('VIRFrench','VIR','French'),('ZWEEnglish','ZWE','English'),('AFGTurkmenian','AFG','Turkmenian'),('NLDTurkish','NLD','Turkish'),('ANDFrench','AND','French'),('AGOLuimbe-ngangu','AGO','Luimbe-nganguela'),('ABWDutch','ABW','Dutch'),('AUSCanton Chines','AUS','Canton Chinese'),('AZEArmenian','AZE','Armenian'),('BGDGaro','BGD','Garo'),('BELArabic','BEL','Arabic'),('BLZGarifuna','BLZ','Garifuna'),('BENAizo','BEN','Aizo'),('BOLGuaranÃÂ▒','BOL','Guaraní'),('BWAKhoekhoe','BWA','Khoekhoe'),('BRAJapanese','BRA','Japanese'),('BRNEnglish','BRN','English'),('BGRMacedonian','BGR','Macedonian'),('BFABusansi','BFA','Busansi'),('CHLRapa nui','CHL','Rapa nui'),('CRIChinese','CRI','Chinese'),('ERIHadareb','ERI','Hadareb'),('ESPBasque','ESP','Basque'),('ZAFNorthsotho','ZAF','Northsotho'),('ETHGurage','ETH','Gurage'),('PHLHiligaynon','PHL','Hiligaynon'),('GABMbete','GAB','Mbete'),('GMBDiola','GMB','Diola'),('GEOAzerbaijani','GEO','Azerbaijani'),('GHAGa-adangme','GHA','Ga-adangme'),('GUMKorean','GUM','Korean'),('GTMKekchí','GTM','Kekchí'),('GINKissi','GIN','Kissi'),('GNBPortuguese','GNB','Portuguese'),('HNDMiskito','HND','Miskito'),('HKGHakka','HKG','Hakka'),('IDNMadura','IDN','Madura'),('INDMarathi','IND','Marathi'),('IRQAssyrian','IRQ','Assyrian'),('IRNGilaki','IRN','Gilaki'),('ITAFrench','ITA','French'),('AUTHungarian','AUT','Hungarian'),('JPNEnglish','JPN','English'),('YUGRomani','YUG','Romani'),('KHMTšam','KHM','Tšam'),('CMRFul','CMR','Ful'),('CANItalian','CAN','Italian'),('KAZGerman','KAZ','German'),('KENKamba','KEN','Kamba'),('CAFNgbaka','CAF','Ngbaka'),('CHNHui','CHN','Hui'),('KGZUkrainian','KGZ','Ukrainian'),('COLArawakan','COL','Arawakan'),('COMComorian-Arab','COM','Comorian-Arabic'),('COGMbete','COG','Mbete'),('CODRwanda','COD','Rwanda'),('LAOLao-Soung','LAO','Lao-Soung'),('LVAUkrainian','LVA','Ukrainian'),('LBRGio','LBR','Gio'),('LTUBelorussian','LTU','Belorussian'),('LUXFrench','LUX','French'),('MACEnglish','MAC','English'),('MKDRomani','MKD','Romani'),('MWINgoni','MWI','Ngoni'),('MYSIban','MYS','Iban'),('MLISoninke','MLI','Soninke'),('MRTSoninke','MRT','Soninke'),('MUSHindi','MUS','Hindi'),('MEXZapotec','MEX','Zapotec'),('FSMKosrean','FSM','Kosrean'),('MDAGagauzi','MDA','Gagauzi'),('MCOEnglish','MCO','English'),('MNGBajad','MNG','Bajad'),('MOZLomwe','MOZ','Lomwe'),('MMRRakhine','MMR','Rakhine'),('NAMAfrikaans','NAM','Afrikaans'),('NRUTuvalu','NRU','Tuvalu'),('NPLTharu','NPL','Tharu'),('NICSumo','NIC','Sumo'),('NERFul','NER','Ful'),('NGAFul','NGA','Ful'),('NORSwedish','NOR','Swedish'),('CIVKru','CIV','Kru'),('PAKSaraiki','PAK','Saraiki'),('PLWChinese','PLW','Chinese'),('PANCuna','PAN','Cuna'),('PRYGerman','PRY','German'),('MNPKorean','MNP','Korean'),('POLBelorussian','POL','Belorussian'),('FRAItalian','FRA','Italian'),('REUMalagasy','REU','Malagasy'),('ROMGerman','ROM','German'),('SWEArabic','SWE','Arabic'),('DEUItalian','DEU','Italian'),('ZMBLozi','ZMB','Lozi'),('SENDiola','SEN','Diola'),('SLEKono-vai','SLE','Kono-vai'),('SVKCzech and Mor','SVK','Czech and Moravi'),('SDNBeja','SDN','Beja'),('FINEstonian','FIN','Estonian'),('CHERomansh','CHE','Romansh'),('TWNAmi','TWN','Ami'),('TZAHaya','TZA','Haya'),('DNKGerman','DNK','German'),('THAMalay','THA','Malay'),('TGOKotokoli','TGO','Kotokoli'),('TCDKanem-bornu','TCD','Kanem-bornu'),('CZEPolish','CZE','Polish'),('TKMKazakh','TKM','Kazakh'),('UGASoga','UGA','Soga'),('UKRBulgariana','UKR','Bulgariana'),('HUNSerbo-Croatia','HUN','Serbo-Croatian'),('UZBKazakh','UZB','Kazakh'),('BLRPolish','BLR','Polish'),('RUSChuvash','RUS','Chuvash'),('VNMMuong','VNM','Muong'),('ESTBelorussian','EST','Belorussian'),('USAGerman','USA','German'),('ZWENyanja','ZWE','Nyanja'),('AFGBalochi','AFG','Balochi'),('AGONyaneka-nkhum','AGO','Nyaneka-nkhumbi'),('AUSArabic','AUS','Arabic'),('BGDKhasi','BGD','Khasi'),('BELGerman','BEL','German'),('BENBariba','BEN','Bariba'),('BWANdebele','BWA','Ndebele'),('BRAIndian Langua','BRA','Indian Languages'),('BFADagara','BFA','Dagara'),('ERIBilin','ERI','Bilin'),('ZAFEnglish','ZAF','English'),('ETHSomali','ETH','Somali'),('PHLBicol','PHL','Bicol'),('GMBSoninke','GMB','Soninke'),('GEOOsseetti','GEO','Osseetti'),('GHAGurma','GHA','Gurma'),('GUMJapanese','GUM','Japanese'),('GTMMam','GTM','Mam'),('GINKpelle','GIN','Kpelle'),('GNBMalinke','GNB','Malinke'),('HKGChiu chau','HKG','Chiu chau'),('IDNMinangkabau','IDN','Minangkabau'),('INDTamil','IND','Tamil'),('IRQPersian','IRQ','Persian'),('IRNLuri','IRN','Luri'),('ITAGerman','ITA','German'),('AUTSlovene','AUT','Slovene'),('JPNPhilippene La','JPN','Philippene Langu'),('YUGSlovak','YUG','Slovak'),('CMRTikar','CMR','Tikar'),('CANGerman','CAN','German'),('KAZUzbek','KAZ','Uzbek'),('KENKalenjin','KEN','Kalenjin'),('CAFSara','CAF','Sara'),('CHNMiao','CHN','Miao'),('KGZTatar','KGZ','Tatar'),('COLCaribbean','COL','Caribbean'),('COMComorian-Swah','COM','Comorian-Swahili'),('COGPunu','COG','Punu'),('CODZande','COD','Zande'),('LVAPolish','LVA','Polish'),('LBRKru','LBR','Kru'),('LTUUkrainian','LTU','Ukrainian'),('LUXGerman','LUX','German'),('MKDSerbo-Croatia','MKD','Serbo-Croatian'),('MYSEnglish','MYS','English'),('MLITamashek','MLI','Tamashek'),('MRTFul','MRT','Ful'),('MUSTamil','MUS','Tamil'),('MEXMixtec','MEX','Mixtec'),('FSMYap','FSM','Yap'),('MDABulgariana','MDA','Bulgariana'),('MNGBuryat','MNG','Buryat'),('MOZShona','MOZ','Shona'),('MMRMon','MMR','Mon'),('NAMHerero','NAM','Herero'),('NRUEnglish','NRU','English'),('NPLTamang','NPL','Tamang'),('NERKanuri','NER','Kanuri'),('NGAIbibio','NGA','Ibibio'),('NORSaame','NOR','Saame'),('CIV[South]Mande','CIV','[South]Mande'),('PAKUrdu','PAK','Urdu'),('PANEmbera','PAN','Embera'),('MNPEnglish','MNP','English'),('FRASpanish','FRA','Spanish'),('REUTamil','REU','Tamil'),('ROMUkrainian','ROM','Ukrainian'),('SWESpanish','SWE','Spanish'),('DEUGreek','DEU','Greek'),('ZMBChewa','ZMB','Chewa'),('SENMalinke','SEN','Malinke'),('SLEBullom-sherbr','SLE','Bullom-sherbro'),('SVKUkrainian and','SVK','Ukrainian and Ru'),('SDNNuer','SDN','Nuer'),('FINSaame','FIN','Saame'),('TWNAtayal','TWN','Atayal'),('TZAMakonde','TZA','Makonde'),('DNKEnglish','DNK','English'),('THAKhmer','THA','Khmer'),('TGOAne','TGO','Ane'),('TCDOuaddai','TCD','Ouaddai'),('CZEGerman','CZE','German'),('UGATeso','UGA','Teso'),('UKRHungarian','UKR','Hungarian'),('HUNRomanian','HUN','Romanian'),('UZBKarakalpak','UZB','Karakalpak'),('RUSBashkir','RUS','Bashkir'),('VNMChinese','VNM','Chinese'),('ESTFinnish','EST','Finnish'),('USAItalian','USA','Italian'),('AGOChokwe','AGO','Chokwe'),('AUSVietnamese','AUS','Vietnamese'),('BGDSanthali','BGD','Santhali'),('BELTurkish','BEL','Turkish'),('BENSomba','BEN','Somba'),('BFADyula','BFA','Dyula'),('ERISaho','ERI','Saho'),('ZAFTswana','ZAF','Tswana'),('ETHSidamo','ETH','Sidamo'),('PHLWaray-waray','PHL','Waray-waray'),('GEOAbhyasi','GEO','Abhyasi'),('GHAJoruba','GHA','Joruba'),('GINYalunka','GIN','Yalunka'),('GNBMandyako','GNB','Mandyako'),('IDNBatakki','IDN','Batakki'),('INDUrdu','IND','Urdu'),('IRNMazandarani','IRN','Mazandarani'),('ITAAlbaniana','ITA','Albaniana'),('AUTPolish','AUT','Polish'),('JPNAinu','JPN','Ainu'),('YUGMacedonian','YUG','Macedonian'),('CMRMandara','CMR','Mandara'),('CANPolish','CAN','Polish'),('KAZTatar','KAZ','Tatar'),('KENGusii','KEN','Gusii'),('CAFMbum','CAF','Mbum'),('CHNUighur','CHN','Uighur'),('KGZKazakh','KGZ','Kazakh'),('COGSango','COG','Sango'),('CODNgala and Ban','COD','Ngala and Bangi'),('LVALithuanian','LVA','Lithuanian'),('LBRMano','LBR','Mano'),('MYSDusun','MYS','Dusun'),('MLISonghai','MLI','Songhai'),('MRTZenaga','MRT','Zenaga'),('MUSMarathi','MUS','Marathi'),('MEXOtomí','MEX','Otomí'),('FSMWolea','FSM','Wolea'),('MNGDariganga','MNG','Dariganga'),('MOZTswa','MOZ','Tswa'),('MMRChin','MMR','Chin'),('NAMCaprivi','NAM','Caprivi'),('NPLNewari','NPL','Newari'),('NGAKanuri','NGA','Kanuri'),('PAKBalochi','PAK','Balochi'),('PANArabic','PAN','Arabic'),('MNPCarolinian','MNP','Carolinian'),('FRATurkish','FRA','Turkish'),('ROMSerbo-Croatia','ROM','Serbo-Croatian'),('SWENorwegian','SWE','Norwegian'),('DEUPolish','DEU','Polish'),('ZMBNsenga','ZMB','Nsenga'),('SENSoninke','SEN','Soninke'),('SLEFul','SLE','Ful'),('SDNZande','SDN','Zande'),('TWNPaiwan','TWN','Paiwan'),('TZANyakusa','TZA','Nyakusa'),('DNKSwedish','DNK','Swedish'),('THAKuy','THA','Kuy'),('TGOMoba','TGO','Moba'),('TCDHadjarai','TCD','Hadjarai'),('CZESilesiana','CZE','Silesiana'),('UGALango','UGA','Lango'),('UKRBelorussian','UKR','Belorussian'),('HUNSlovak','HUN','Slovak'),('UZBTatar','UZB','Tatar'),('RUSChechen','RUS','Chechen'),('VNMKhmer','VNM','Khmer'),('USAChinese','USA','Chinese'),('AGOLuvale','AGO','Luvale'),('AUSSerbo-Croatia','AUS','Serbo-Croatian'),('BGDTripuri','BGD','Tripuri'),('BENFul','BEN','Ful'),('ZAFSouthsotho','ZAF','Southsotho'),('ETHWalaita','ETH','Walaita'),('PHLPampango','PHL','Pampango'),('GINLoma','GIN','Loma'),('IDNBugi','IDN','Bugi'),('INDGujarati','IND','Gujarati'),('IRNBalochi','IRN','Balochi'),('ITASlovene','ITA','Slovene'),('AUTCzech','AUT','Czech'),('CMRMaka','CMR','Maka'),('CANSpanish','CAN','Spanish'),('KENMeru','KEN','Meru'),('CHNYi','CHN','Yi'),('KGZTadzhik','KGZ','Tadzhik'),('CODRundi','COD','Rundi'),('LBRLoma','LBR','Loma'),('MOZChuabo','MOZ','Chuabo'),('MMRKachin','MMR','Kachin'),('NAMSan','NAM','San'),('NPLHindi','NPL','Hindi'),('NGAEdo','NGA','Edo'),('PAKHindko','PAK','Hindko'),('SLEKuranko','SLE','Kuranko'),('SDNBari','SDN','Bari'),('TZAChaga and Par','TZA','Chaga and Pare'),('DNKNorwegian','DNK','Norwegian'),('TGONaudemba','TGO','Naudemba'),('TCDTandjile','TCD','Tandjile'),('CZERomani','CZE','Romani'),('UGALugbara','UGA','Lugbara'),('UKRPolish','UKR','Polish'),('RUSMordva','RUS','Mordva'),('VNMNung','VNM','Nung'),('USATagalog','USA','Tagalog'),('AGOAmbo','AGO','Ambo'),('AUSGerman','AUS','German'),('ZAFTsonga','ZAF','Tsonga'),('PHLPangasinan','PHL','Pangasinan'),('IDNBanja','IDN','Banja'),('INDKannada','IND','Kannada'),('IRNArabic','IRN','Arabic'),('ITARomani','ITA','Romani'),('AUTRomanian','AUT','Romanian'),('CMRMasana','CMR','Masana'),('CANPortuguese','CAN','Portuguese'),('KENNyika','KEN','Nyika'),('CHNTujia','CHN','Tujia'),('CODTeke','COD','Teke'),('LBRMalinke','LBR','Malinke'),('MOZRonga','MOZ','Ronga'),('MMRKayah','MMR','Kayah'),('NAMGerman','NAM','German'),('NGATiv','NGA','Tiv'),('PAKBrahui','PAK','Brahui'),('SLEYalunka','SLE','Yalunka'),('SDNFur','SDN','Fur'),('TZALuguru','TZA','Luguru'),('TGOGurma','TGO','Gurma'),('TCDGorane','TCD','Gorane'),('CZEHungarian','CZE','Hungarian'),('UGAGisu','UGA','Gisu'),('RUSKazakh','RUS','Kazakh'),('VNMMiao','VNM','Miao'),('USAPolish','USA','Polish'),('AGOLuchazi','AGO','Luchazi'),('ZAFSwazi','ZAF','Swazi'),('PHLMaguindanao','PHL','Maguindanao'),('IDNBali','IDN','Bali'),('INDMalajalam','IND','Malajalam'),('IRNBakhtyari','IRN','Bakhtyari'),('CANPunjabi','CAN','Punjabi'),('KENMasai','KEN','Masai'),('CHNMongolian','CHN','Mongolian'),('CODBoa','COD','Boa'),('MOZMarendje','MOZ','Marendje'),('NGAIjo','NGA','Ijo'),('SDNChilluk','SDN','Chilluk'),('TZAShambala','TZA','Shambala'),('UGAAcholi','UGA','Acholi'),('RUSAvarian','RUS','Avarian'),('VNMMan','VNM','Man'),('USAKorean','USA','Korean'),('ZAFVenda','ZAF','Venda'),('PHLMaranao','PHL','Maranao'),('INDOrija','IND','Orija'),('IRNTurkmenian','IRN','Turkmenian'),('CANUkrainian','CAN','Ukrainian'),('KENTurkana','KEN','Turkana'),('CHNTibetan','CHN','Tibetan'),('CODChokwe','COD','Chokwe'),('MOZNyanja','MOZ','Nyanja'),('NGABura','NGA','Bura'),('SDNLotuko','SDN','Lotuko'),('TZAGogo','TZA','Gogo'),('UGARwanda','UGA','Rwanda'),('RUSMari','RUS','Mari'),('USAVietnamese','USA','Vietnamese'),('ZAFNdebele','ZAF','Ndebele'),('INDPunjabi','IND','Punjabi'),('CANDutch','CAN','Dutch'),('CHNPuyi','CHN','Puyi'),('TZAHa','TZA','Ha'),('RUSUdmur','RUS','Udmur'),('USAJapanese','USA','Japanese'),('INDAsami','IND','Asami'),('CANEskimo Langua','CAN','Eskimo Languages'),('CHNDong','CHN','Dong'),('RUSBelorussian','RUS','Belorussian'),('USAPortuguese','USA','Portuguese');
CREATE TABLE t1 ( col_varchar_nokey varchar(52) NOT NULL ) ;
INSERT INTO t1 VALUES ('Chinese'),('English'),('French'),('German'),('Italian'),('Japanese'),('Korean'),('Polish'),('Portuguese'),('Spanish'),('Tagalog'),('Vietnamese');
CREATE TABLE t3 ( col_varchar_key varchar(52)) ;
INSERT INTO t3 VALUES ('United States');

SET SESSION optimizer_switch = 'derived_with_keys=on';

SELECT *
FROM t3 JOIN
( SELECT t2.* FROM t1, t2 ) AS alias2
ON ( alias2.col_varchar_nokey = t3.col_varchar_key )
ORDER BY CONCAT(alias2.col_varchar_nokey);

Re: Crash in QUICK_RANGE_SELECT::reset with derived_with_keys
Also observed without a function in the ORDER BY clause.

Re: Crash in QUICK_RANGE_SELECT::reset with derived_with_keys
Bug http://bugs.mysql.com/bug.php?id=10244 is from 2005 with an identical backtrace.

Launchpad bug id: 882994