Assertion failed - exec_method != MATERIALIZATION || (exec_method == MATERIALIZATION && engine->engine_type() == subselect_engine::HASH_SJ_ENGINE)", file=<value optimized out>, line=318, function=0x84fae0 "virtual bool drizzled::Item_in_subselect::exec()
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
PrafullaT | ||
Dexter |
Fix Released
|
Medium
|
PrafullaT |
Bug Description
This is the same failing assertion from https:/
However, the test case for that bug no longer hits the assertion. Creating a new bug with new test case.
Test case to be posted shortly.
Backtrace:
#0 0x00007f28ff4f8a75 in *__GI_raise (sig=<value optimized out>) at ../nptl/
#1 0x00007f28ff4fc5c0 in *__GI_abort () at abort.c:92
#2 0x00007f28ff4f1941 in *__GI___assert_fail (
assertion=
file=<value optimized out>, line=318, function=0x84fae0 "virtual bool drizzled:
#3 0x0000000000575b9e in drizzled:
#4 0x0000000000572f77 in drizzled:
#5 0x0000000000550c2c in drizzled:
#6 0x00000000005bbafc in get_mm_tree (param=
#7 0x00000000005bbc58 in get_mm_tree (param=
#8 0x00000000005bc667 in drizzled:
prev_
#9 0x0000000000611108 in drizzled:
limit=
#10 0x00000000005902fa in make_join_
keyuse_
#11 0x0000000000591c39 in drizzled:
#12 0x00000000006111e5 in drizzled:
fields=..., conds=0x7f28ff6
unit=
#13 0x0000000000611b60 in drizzled:
at drizzled/
#14 0x000000000060b895 in drizzled:
#15 0x000000000060b4fe in mysql_execute_
at drizzled/
#16 drizzled:
#17 0x000000000060d6d2 in drizzled:
packet=
#18 0x00000000005dd92f in drizzled:
#19 0x00000000005dfcd2 in drizzled:
#20 0x00007f28fba8d083 in MultiThreadSche
#21 session_thread (arg=<value optimized out>) at plugin/
#22 0x00007f28ff84d9ca in start_thread (arg=<value optimized out>) at pthread_
#23 0x00007f28ff5ab6cd in clone () at ../sysdeps/
#24 0x0000000000000000 in ?? ()
Related branches
Changed in drizzle: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
Changed in drizzle: | |
status: | In Progress → Fix Committed |
Changed in drizzle: | |
milestone: | none → 2010-07-19 |
Test case
Attempt to record via ./test-run --record <test_name>
DROP TABLE IF EXISTS `bb`; text_not_ null` text NOT NULL, text_not_ null_key` text NOT NULL, char_not_ null` varchar(1) NOT NULL, not_null_ key` (`col_text_ not_null_ key`(255) )
CREATE TABLE `bb` (
`pk` int NOT NULL AUTO_INCREMENT,
`col_
`col_bigint_key` bigint DEFAULT NULL,
`col_int` int DEFAULT NULL,
`col_char` varchar(1) DEFAULT NULL,
`col_text` text,
`col_
`col_
PRIMARY KEY (`pk`),
KEY `col_bigint_key` (`col_bigint_key`),
KEY `col_text_
) ENGINE=InnoDB;
ALTER TABLE `bb` DISABLE KEYS; NULL,'h' ,NULL,' ','f'), (2,'',NULL, 1756299264, 'p',NULL, '','w') ,(3,'', 6,-1990000640, 'w',NULL, '','w') ,(4,'', NULL,NULL, 'f',NULL, '','k') ,(5,'', NULL,NULL, 'k',NULL, '','t') ,(6,'', 9,NULL, 'm',NULL, '','c') ,(7,'', 645168794118494 6176,0, 'z',NULL, '','f') ,(8,'', 896047440860702 3104,1805844480 ,'h',NULL, '','k') ,(9,'', 8,7,'y' ,NULL,' ','m'), (10,'', NULL,-415629312 ,'t',NULL, '','h') ;
INSERT INTO `bb` VALUES (1,'',NULL,
ALTER TABLE `bb` ENABLE KEYS;
SELECT DISTINCT OUTR . `col_text` AS X FROM BB AS OUTR2 LEFT JOIN BB AS OUTR ON ( OUTR2 . `col_char` <> OUTR . `col_text` ) WHERE OUTR . `col_bigint_key` IN ( SELECT INNR . `pk` AS Y FROM BB AS INNR WHERE INNR . `col_bigint_key` > INNR . `col_int` AND INNR . `col_text_ not_null_ key` >= INNR . `col_char_not_null` ) AND OUTR . `col_bigint_key` = 9 ORDER BY OUTR . `col_text_not_null` , OUTR . `pk`;
DROP TABLE BB;