Test case: --test-run --record --echo Bug#608416 --echo Crash / assertion failed - --echo "void drizzled::Select_Lex::print(drizzled::Session*, drizzled::String*, drizzled::enum_query_type)") at assert.c:81 --echo #3 0x00000000006282fb in drizzled::Select_Lex::print --echo (this=0x3911418, session=0x0, str=0x7f26b77fd7c0, query_type=drizzled::QT_ORDINARY) at drizzled/sql_select.cc:6592 --disable_warnings DROP TABLE IF EXISTS `aa`,`bb`,`dd`; --enable_warnings DROP TABLE IF EXISTS `aa`; CREATE TABLE `aa` ( `pk` int NOT NULL AUTO_INCREMENT, `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL, `col_int_not_null_key` int NOT NULL, `col_char_10_not_null_key` varchar(10) NOT NULL, `col_int_key` int DEFAULT NULL, `col_text_not_null` text NOT NULL, `col_char_1024_key` varchar(1024) DEFAULT NULL, `col_bigint_key` bigint DEFAULT NULL, `col_int_not_null` int NOT NULL, PRIMARY KEY (`pk`), KEY `col_enum_not_null_key` (`col_enum_not_null_key`), KEY `col_int_not_null_key` (`col_int_not_null_key`), KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`), KEY `col_int_key` (`col_int_key`), KEY `col_char_1024_key` (`col_char_1024_key`(255)), KEY `col_bigint_key` (`col_bigint_key`) ) ENGINE=InnoDB; INSERT INTO `aa` VALUES (1,'s',-523436032,'at',2071265280,'','LPUJD',NULL,-1974206464),(2,'p',1,'VDMDI',1,'','don\'t',NULL,3),(3,'n',621543424,'WPTIG',NULL,'','think',-2842897264777625600,-274595840),(4,'o',880148480,'your',1734213632,'','on',NULL,295501824),(5,'b',1963982848,'q',1505558528,'','YTUNQ',3557843705622691840,9),(6,'c',8,'OOQXU',8,'','o',-4628011567076605952,2),(7,'p',1445462016,'RDODX',NULL,'','so',-5755881798756204544,-1601306624),(8,'i',0,'e',-1685520384,'','get',NULL,-1770323968),(9,'f',-747241472,'FEKXH',NULL,'','l',NULL,256311296),(10,'p',6,'GTHOM',-1431502848,'','h',-5719290051783819264,4); CREATE TABLE `bb` ( `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL, `col_text_not_null` text NOT NULL, `col_char_10_not_null_key` varchar(10) NOT NULL, `col_bigint_key` bigint DEFAULT NULL, `col_char_1024_key` varchar(1024) DEFAULT NULL, `pk` int NOT NULL AUTO_INCREMENT, `col_int_not_null_key` int NOT NULL, `col_int_key` int DEFAULT NULL, `col_int_not_null` int NOT NULL, PRIMARY KEY (`pk`), KEY `col_enum_not_null_key` (`col_enum_not_null_key`), KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`), KEY `col_bigint_key` (`col_bigint_key`), KEY `col_char_1024_key` (`col_char_1024_key`(255)), KEY `col_int_not_null_key` (`col_int_not_null_key`), KEY `col_int_key` (`col_int_key`) ) ENGINE=InnoDB; INSERT INTO `bb` VALUES ('r','','DCJRX',NULL,'ANVSO',1,1,NULL,763953152),('a','','x',NULL,'JBJPT',2,1,4,-132513792),('s','','ZMHDL',-647673921411219456,'KAHJT',3,-1536425984,-628359168,3),('i','','SJGHS',-5702401553181179904,'q',4,-1443495936,-2114322432,-1349844992),('w','','his',NULL,'l',5,2,105971712,-2019688448),('v','','m',4,'ULWFL',6,0,2,-38207488),('d','','i',NULL,'YOIXU',7,8,NULL,3),('f','','d',8,'that\'s',8,476315648,NULL,8),('y','','from',NULL,'ZPPIG',9,5,-607322112,-1129054208),('o','','h',NULL,'like',10,5,0,-415629312); CREATE TABLE `dd` ( `col_int_not_null` int NOT NULL, `col_int_key` int DEFAULT NULL, `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL, `col_bigint_key` bigint DEFAULT NULL, `col_char_10_not_null_key` varchar(10) NOT NULL, `col_int_not_null_key` int NOT NULL, `col_text_not_null` text NOT NULL, `pk` int NOT NULL AUTO_INCREMENT, `col_char_1024_key` varchar(1024) DEFAULT NULL, PRIMARY KEY (`pk`), KEY `col_int_key` (`col_int_key`), KEY `col_enum_not_null_key` (`col_enum_not_null_key`), KEY `col_bigint_key` (`col_bigint_key`), KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`), KEY `col_int_not_null_key` (`col_int_not_null_key`), KEY `col_char_1024_key` (`col_char_1024_key`(255)) ) ENGINE=InnoDB; INSERT INTO `dd` VALUES (1777795072,NULL,'g',0,'was',-1866203136,'',1,'g'),(-626130944,8,'u',NULL,'g',8,'',2,'like'),(1,NULL,'i',995576992625590272,'it',6,'',3,'XAHAR'),(424542208,0,'h',8,'right',2,'',4,'ok'),(-1298137088,1848180736,'u',-4097712710953730048,'yeah',-26345472,'',5,'ZJMPU'),(9,-436600832,'t',NULL,'RNVBF',1744830464,'',6,'got'),(-1558511616,NULL,'v',NULL,'mean',6,'',7,'r'),(1398013952,2,'b',2,'HMDFB',2,'',8,'SNJXN'),(855703552,NULL,'l',-3133942390696443904,'HYJNL',7,'',9,'x'),(398065664,NULL,'y',NULL,'n',-1035337728,'',10,'back'),(453574656,8,'l',-6663920073624780800,'h',7,'',11,'so'),(0,1522728960,'r',NULL,'it',0,'',12,'d'),(4,NULL,'l',NULL,'QCXJS',8,'',13,'w'),(1861222400,7,'k',-8287467739291844608,'h',861274112,'',14,'c'),(1666252800,NULL,'m',3,'l',6,'',15,'JUAVG'),(1710882816,5,'s',7,'y',6,'',16,'KHBLN'),(1068236800,-1045757952,'f',4031566091426725888,'UDZMD',8,'',17,'FGWHT'),(-525598720,1820393472,'c',NULL,'a',5,'',18,'LTBPZ'),(4,NULL,'u',-6006957477982109696,'RULDD',-1838481408,'',19,'q'),(431816704,-629080064,'h',NULL,'CTWHH',5,'',20,'l'),(-203948032,NULL,'r',NULL,'right',6,'',21,'u'),(6,NULL,'c',9,'d',762183680,'',22,'h'),(7,8,'n',NULL,'how',-671416320,'',23,'y'),(8,NULL,'y',NULL,'go',-1549664256,'',24,'WTWCU'),(8,7,'u',-4459408056026923008,'it',1723072512,'',25,'PCGUF'),(1,343408640,'l',6,'k',2054684672,'',26,'p'),(3,-1248133120,'e',8,'why',-119996416,'',27,'DBMZR'),(1875509248,-910557184,'j',5,'her',2,'',28,'k'),(96993280,3,'l',-5142829299480395776,'see',-1133379584,'',29,'so'),(8,7,'c',NULL,'c',1316421632,'',30,'RJVAA'),(-910753792,3,'c',-8170374148980211712,'l',5,'',31,'from'),(1494614016,6,'i',5,'OVDIS',2,'',32,'go'),(495648768,3,'u',7,'w',0,'',33,'QKNMG'),(9,NULL,'g',-2987856877783613440,'r',-1333854208,'',34,'KTIYL'),(-77266944,1968898048,'v',2647835105917140992,'GQQGQ',2,'',35,'LYYIW'),(-413532160,2,'q',-8332503735565549568,'y',6,'',36,'when'),(404094976,9,'a',-2131047048676376576,'t',-1703280640,'',37,'ILGPT'),(3,999882752,'a',-4447586107005075456,'WRPLX',3,'',38,'really'),(1518600192,NULL,'n',NULL,'mean',3,'',39,'QDBLH'),(360382464,1719599104,'d',5,'g',-829030400,'',40,'XMPQM'),(9,NULL,'x',NULL,'but',-1023868928,'',41,'QMWQW'),(-191627264,-1037041664,'d',NULL,'IWSTM',1039597568,'',42,'TJIBA'),(3,NULL,'t',NULL,'in',3,'',43,'p'),(5,NULL,'c',4,'i',-1232470016,'',44,'about'),(-552075264,7,'j',3,'his',-1754202112,'',45,'k'),(1,NULL,'m',7059110940926541824,'m',4,'',46,'TGRNE'),(9,NULL,'k',NULL,'ZDKHI',1,'',47,'o'),(0,1045495808,'z',2,'n',0,'',48,'come'),(1496252416,NULL,'f',8,'r',1,'',49,'j'),(-126877696,NULL,'j',4,'your',-527958016,'',50,'u'),(-1236205568,NULL,'j',2,'ZETBH',1,'',51,'KBVKH'),(932315136,-1448607744,'n',9,'can\'t',1521287168,'',52,'v'),(-2033582080,-927399936,'w',1610318341761662976,'s',8,'',53,'right'),(3,NULL,'w',NULL,'I',1334706176,'',54,'o'),(1765277696,1398472704,'a',-5764607523034234880,'was',1372454912,'',55,'QEEFV'),(2,NULL,'v',4,'r',1559494656,'',56,'h'),(-736034816,-1241579520,'x',NULL,'ZQLWA',2075787264,'',57,'this'),(-432734208,1822949376,'d',3015159950524547072,'really',0,'',58,'of'),(1,4,'t',3345893048159567872,'oh',1,'',59,'i'),(3,2073821184,'v',NULL,'she',9,'',60,'on'),(3,NULL,'k',NULL,'q',-1581056000,'',61,'KPFNB'),(466419712,-2076966912,'m',4,'him',218365952,'',62,'it\'s'),(7,1282801664,'t',4396639136220446720,'n',22609920,'',63,'it'),(1958936576,NULL,'t',7,'f',1,'',64,'think'),(408289280,NULL,'r',4,'n',4,'',65,'it'),(4,7,'e',NULL,'is',-1302069248,'',66,'didn\'t'),(-46661632,5,'h',-3252724830868340736,'t',1962278912,'',67,'MHETI'),(414777344,NULL,'a',3648478648123523072,'v',3,'',68,'CFEBG'),(5,133562368,'c',2230970665408659456,'going',3,'',69,'QETAK'),(-1345191936,-807403520,'g',-8000081788070264832,'when',-827916288,'',70,'v'),(4,1567490048,'c',NULL,'been',2,'',71,'BYRFL'),(-1640824832,1781465088,'r',-5867064414556913664,'TCOCW',3,'',72,'d'),(2,-1069940736,'t',-3827215258334789632,'q',342687744,'',73,'or'),(51052544,NULL,'l',NULL,'IQHHS',1351614464,'',74,'do'),(7,NULL,'n',NULL,'b',4,'',75,'her'),(1831272448,7,'p',-4311633693253828608,'MHUUM',-1406074880,'',76,'AVBWN'),(-1631256576,NULL,'d',3,'i',9,'',77,'this'),(-68616192,NULL,'j',-7028430168465080320,'u',1575682048,'',78,'QBQKO'),(-1593049088,NULL,'w',NULL,'SFULF',2,'',79,'go'),(-1034289152,1581514752,'l',6,'then',2112552960,'',80,'something'),(-469434368,3,'k',-9212394512763060224,'XUOCO',8,'',81,'g'),(-1218248704,NULL,'p',1,'why',752091136,'',82,'OMGVP'),(8,-111476736,'s',NULL,'p',1,'',83,'I'),(-1751384064,38273024,'l',4669669863629783040,'got',-1552613376,'',84,'f'),(289341440,NULL,'m',-315533448892645376,'HGLDJ',484900864,'',85,'about'),(8,NULL,'i',9,'OSFXG',2,'',86,'x'),(-1451032576,2090139648,'t',NULL,'KMXYE',-989265920,'',87,'n'),(-318177280,-1837301760,'z',2,'are',-986644480,'',88,'or'),(-142082048,4,'v',0,'GQJPG',-898105344,'',89,'TZXUO'),(-1538326528,NULL,'n',22517998136852480,'TLWLT',6,'',90,'did'),(-583794688,NULL,'a',-3725039841788821504,'a',-286261248,'',91,'a'),(3,NULL,'b',-1592303943252180992,'like',2,'',92,'UYYDV'),(7,NULL,'p',NULL,'ENBZE',6,'',93,'h'),(2,NULL,'g',NULL,'KDSHM',-1502871552,'',94,'it'),(3,123797504,'j',-2015923783201718272,'did',8,'',95,'IQEEK'),(3,NULL,'z',NULL,'this',9,'',96,'had'),(4,NULL,'q',7373237014935633920,'DUGAH',-807600128,'',97,'PZWIG'),(-939327488,7,'n',NULL,'IXXSQ',2,'',98,'DOWGE'),(-1627783168,8,'t',NULL,'d',-649003008,'',99,'BDZUX'),(1928134656,4,'j',2,'s',-398196736,'',100,'BYGUP'); EXPLAIN EXTENDED SELECT table2 . `col_enum_not_null_key` AS field1 , table1 . `col_char_1024_key` AS field2 FROM ( ( SELECT SUBQUERY1_t1 . * FROM ( BB AS SUBQUERY1_t1 RIGHT JOIN AA AS SUBQUERY1_t2 ON (SUBQUERY1_t2 . `col_int_not_null_key` = SUBQUERY1_t1 . `col_int_key` ) ) ) AS table1 INNER JOIN ( ( DD AS table2 STRAIGHT_JOIN BB AS table3 ON (table3 . `col_char_10_not_null_key` = table2 . `col_char_key` ) ) ) ON (table3 . `col_char_key` = table2 . `col_text_not_null` ) ) WHERE ( ( SELECT MIN( SUBQUERY2_t2 . `col_char_10_not_null_key` ) AS SUBQUERY2_field1 FROM AA AS SUBQUERY2_t1 WHERE ( EXISTS ( ( SELECT CHILD_SUBQUERY1_t2 . `col_char_10_not_null_key` AS CHILD_SUBQUERY1_field1 FROM ( BB AS CHILD_SUBQUERY1_t1 INNER JOIN AA AS CHILD_SUBQUERY1_t2 ON (CHILD_SUBQUERY1_t2 . `col_int_key` = CHILD_SUBQUERY1_t1 . `pk` ) ) WHERE ( CHILD_SUBQUERY1_t2 . `col_char_10_not_null_key` > 'y' AND CHILD_SUBQUERY1_t1 . `col_int_not_null_key` = CHILD_SUBQUERY1_t1 . `col_int_not_null` ) HAVING CHILD_SUBQUERY1_t2 . `col_bigint_key` >= 3) ) AND SUBQUERY2_t1 . `col_int_key` != 8 ) ) IS NOT NULL ) AND ( table1 . `col_int_key` = 160 AND table1 . `col_int_key` = 197 ) AND table3 . `col_text_not_null` >= 'g' GROUP BY field1, field2; # cleanup DROP TABLE `aa`; DROP TABLE `bb`; DROP TABLE `cc`; # End Bug#608416 test