Crash / segfault in drizzled::optimizer::add_key_part (keyuse_array=<value optimized out>, key_field=0x2d0dc28) at drizzled/optimizer/key_field.cc:63
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
PrafullaT | ||
Dexter |
Fix Released
|
Medium
|
PrafullaT |
Bug Description
Crashing bug / segfault:
in drizzled:
Test case on the way
Backtrace:
#0 0x0000000000000000 in ?? ()
#1 0x00000000005aeb7c in drizzled:
#2 0x0000000000617781 in drizzled:
cond=<value optimized out>, normal_
#3 0x0000000000594eed in make_join_
#4 0x00000000005964f1 in drizzled:
#5 0x0000000000577ca2 in drizzled:
#6 0x000000000057a128 in drizzled:
#7 drizzled:
#8 0x0000000000577547 in drizzled:
#9 0x000000000055550c in drizzled:
#10 0x000000000054d6bc in drizzled:
#11 0x0000000000554a79 in drizzled:
#12 0x000000000054d6bc in drizzled:
#13 0x00000000005549e9 in drizzled:
#14 0x00000000005b6df8 in drizzled:
#15 0x000000000058d349 in drizzled:
#16 0x00000000006133f7 in drizzled:
#17 0x0000000000617e70 in drizzled::do_select (join=0x2d07878, fields=0x0, table=0x2d30bb8) at drizzled/
#18 0x0000000000592a97 in drizzled:
#19 0x00000000006145f2 in drizzled:
conds=<value optimized out>, og_num=2, order=0x2c86518, group=0x0, having=0x0, select_
at drizzled/
#20 0x0000000000614ef0 in drizzled:
#21 0x000000000060ea65 in drizzled:
#22 0x000000000060e6ce in mysql_execute_
#23 drizzled:
#24 0x00000000006108c2 in drizzled:
packet=
#25 0x00000000005e18df in drizzled:
---Type <return> to continue, or q <return> to quit---
#26 0x00000000005e3e12 in drizzled:
#27 0x00007fe431586083 in MultiThreadSche
#28 session_thread (arg=<value optimized out>) at plugin/
#29 0x00007fe4353549ca in start_thread (arg=<value optimized out>) at pthread_
#30 0x00007fe4350b26cd in clone () at ../sysdeps/
#31 0x0000000000000000 in ?? ()
Related branches
- Patrick Crews: Approve
-
Diff: 12 lines (+1/-1)1 file modifieddrizzled/sql_select.cc (+1/-1)
Changed in drizzle: | |
status: | In Progress → Fix Committed |
Changed in drizzle: | |
status: | Fix Committed → Fix Released |
Changed in drizzle: | |
milestone: | none → 2010-07-19 |
Test case:
./test-run --record <test_name> will result in the crash
--disable_warnings
DROP TABLE IF EXISTS `bb`, `cc`;
--enable_warnings
DROP TABLE IF EXISTS `bb`; text_not_ null` text NOT NULL, int_not_ null` int NOT NULL, char_not_ null_key` varchar(1) NOT NULL, not_null_ key` (`col_char_ not_null_ key`), key`(255) )
CREATE TABLE `bb` (
`col_
`pk` int NOT NULL AUTO_INCREMENT,
`col_
`col_bigint` bigint DEFAULT NULL,
`col_
`col_text` text,
`col_text_key` text,
PRIMARY KEY (`pk`),
KEY `col_char_
KEY `col_text_key` (`col_text_
) ENGINE=InnoDB;
ALTER TABLE `bb` DISABLE KEYS; 247005184, 465784791460793 5488,'q' ,NULL,NULL) ,('',2, 9,6580884955495 137280, 'd',NULL, NULL),( '',3,9, 6,'o',NULL, NULL),( '',4,8, NULL,'j' ,NULL,NULL) ,('',5, 575668224, -70270227935815 27040,' c',NULL, NULL),( '',6,9, 8,'o',NULL, NULL),( '',7,1, NULL,'a' ,NULL,NULL) ,('',8, 7,6164301989963 36640,' o',NULL, NULL),( '',9,1, NULL,'u' ,NULL,NULL) ,('',10, 130416640, 624480383330261 4016,'y' ,NULL,NULL) ;
INSERT INTO `bb` VALUES ('',1,-
ALTER TABLE `bb` ENABLE KEYS;
CREATE TABLE `cc` ( char_not_ null_key` varchar(1) NOT NULL, not_null_ key` (`col_char_ not_null_ key`), key`(255) )
`pk` int NOT NULL AUTO_INCREMENT,
`col_
`col_int_key` int DEFAULT NULL,
`col_text_key` text,
PRIMARY KEY (`pk`),
KEY `col_char_
KEY `col_int_key` (`col_int_key`),
KEY `col_text_key` (`col_text_
) ENGINE=InnoDB;
ALTER TABLE `cc` DISABLE KEYS; -1711407104, NULL),( 2,'k',- 1837629440, NULL),( 3,'g',2, NULL),( 4,'f',5, NULL),( 5,'t',- 173408256, NULL),( 6,'s',- 2063663104, NULL),( 7,'l',4, NULL),( 8,'q',NULL, NULL),( 9,'h',- 858587136, NULL),( 10,'r', -1040056320, NULL),( 11,'l', -1812332544, NULL),( 12,'o', NULL,NULL) ,(13,'e' ,NULL,NULL) ,(14,'k' ,4,NULL) ,(15,'p' ,456261632, NULL),( 16,'j', NULL,NULL) ,(17,'b' ,NULL,NULL) ,(18,'i' ,4,NULL) ,(19,'n' ,NULL,NULL) ,(20,'n' ,4,NULL) ,(21,'m' ,7,NULL) ,(22,'i' ,NULL,NULL) ,(23,'l' ,4,NULL) ,(24,'x' ,4,NULL) ,(25,'w' ,NULL,NULL) ,(26,'s' ,4,NULL) ,(27,'s' ,6,NULL) ,(28,'i' ,NULL,NULL) ,(29,'j' ,NULL,NULL) ,(30,'z' ,0,NULL) ,(31,'d' ,-84738048, NULL),( 32,'s', -1456209920, NULL),( 33,'o', -1366818816, NULL),( 34,'t', 2,NULL) ,(35,'t' ,3,NULL) ,(36,'o' ,5,NULL) ,(37,'i' ,NULL,NULL) ,(38,'v' ,779943936, NULL),( 39,'w', NULL,NULL) ,(40,'f' ,7,NULL) ,(41,'n' ,1658912768, NULL),( 42,'u', NULL,NULL) ,(43,'g' ,NULL,NULL) ,(44,'a' ,4,NULL) ,(45,'o' ,1,NULL) ,(46,'h' ,NULL,NULL) ,(47,'y' ,892862464, NULL),( 48,'m', NULL,NULL) ,(49,'w' ,NULL,NULL) ,(50,'a' ,9,NULL) ,(51,'c' ,NULL,NULL) ,(52,'r' ,1758330880, NULL),( 53,'s', 7,NULL) ,(54,'n' ,3,NULL) ,(55,'e' ,1,NULL) ,(56,'c' ,NULL,NULL) ,(57,'i' ,1,NULL) ,(58,'h' ,NULL,NULL) ,(59,'n' ,1441005568, NULL),( 60,'b', 9,NULL) ,(61,'a' ,8,NULL) ,(62,'o' ,1389690880, NULL),( 63,'c', 2,NULL) ,(64,'g' ,7,NULL) ,(65,'r' ,0,NULL) ,(66,'i' ,2,NULL) ,(67,'w' ,NULL,NULL) ,(68,'s' ,NULL,NULL) ,(69,'f' ,NULL,NULL) ,(70,'l' ,1,NULL) ,(71,'t' ,-1545666560, NULL),( 72,'f', NULL,NULL) ,(73,'y' ,1729363968, NULL),( 74,'m', -39583744, NULL),( 75,'m', 5,NULL) ,(76,'r' ,-33554432, NULL),( 77,'a', 7,NULL) ,(78,'q' ,1687748608, NULL),( 79,'h', NULL,NULL) ,(80,'x' ,524877824, NULL),( 81,'t', NULL,NULL) ,(82,'o' ,NULL,NULL) ,(83,'a' ,NULL,NULL) ,(84,'j' ,4,NULL) ,(85,'o' ,0,NULL) ,(86,'l' ,1818296320, NULL),( 87,'l', 1,NULL) ,(88,'q' ,1346699264, NULL),( 89,'t', NULL,NULL) ,(90,'f' ,1,NULL) ,(91,'g' ,584253440, NULL),( 92,'s', 670564352. ..
INSERT INTO `cc` VALUES (1,'k',