Crash / assertion failed in drizzled::Session::free_cached_table (this=0x7f83a42c63f0) at drizzled/sql_base.cc:513
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
Andrew Hutchings | ||
7.0 |
Fix Released
|
Medium
|
Andrew Hutchings |
Bug Description
Crashing bug via assertion:
in *__GI___assert_fail (assertion=0xacac48 "!table->cursor || table->
file=<value optimized out>, line=513, function=0xacc980 "bool drizzled:
Query:
SELECT table1 . `col_text_
Backtrace:
#0 0x00007f83c07bba75 in *__GI_raise (sig=<value optimized out>) at ../nptl/
#1 0x00007f83c07bf5c0 in *__GI_abort () at abort.c:92
#2 0x00007f83c07b4941 in *__GI___assert_fail (assertion=0xacac48 "!table->cursor || table->
file=<value optimized out>, line=513, function=0xacc980 "bool drizzled:
#3 0x0000000000797f0e in drizzled:
#4 0x0000000000798008 in drizzled:
#5 0x0000000000781d05 in drizzled:
#6 0x00000000007b9eca in drizzled:
packet=
#7 0x000000000077d367 in drizzled:
#8 0x000000000077cc13 in drizzled:
#9 0x00007f83bce03b54 in MultiThreadSche
at ./plugin/
#10 0x00007f83bce019e2 in session_thread (arg=0x7f83a42c
#11 0x00007f83c0b119ca in start_thread (arg=<value optimized out>) at pthread_
#12 0x00007f83c086e6fd in clone () at ../sysdeps/
#13 0x0000000000000000 in ?? ()
Related branches
- Drizzle Developers: Pending requested
-
Diff: 103 lines (+68/-1)3 files modifieddrizzled/join.cc (+6/-1)
tests/suite/regression/r/632755.result (+27/-0)
tests/suite/regression/t/632755.test (+35/-0)
Changed in drizzle: | |
assignee: | nobody → Patrick Crews (patrick-crews) |
--disable_warnings
DROP TABLE IF EXISTS AA;
DROP TABLE IF EXISTS BB;
--enable_warnings
CREATE TABLE `aa` ( text_not_ null_key` text NOT NULL, int_not_ null_key` int NOT NULL, bigint_ not_null_ key` bigint NOT NULL, 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, char_1024_ not_null_ key` varchar(1024) NOT NULL
`pk` int NOT NULL DEFAULT '0',
`col_
`col_
`col_
`col_
`col_int_key` int DEFAULT NULL,
`col_int` int DEFAULT NULL,
`col_
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `aa` VALUES (1,'',- 523436032, -63886375464017 59232,' s',2071265280, 9,'well' ),(2,'' ,1,5,'p' ,1,-1692139520, 'on'),( 3,'',621543424, 1,'n',NULL, 4,'ASUNK' ),(4,'' ,880148480, -91234484201224 92928,' o',1734213632, 9,'d'), (5,'',196398284 8,9,'b' ,1505558528, -1091567616, 'm'),(6, '',8,6, 'c',8,126156800 ,'to'), (7,'',144546201 6,5,'p' ,NULL,534904832 ,'t'),( 8,'',0, 590337468655258 8288,'i' ,-1685520384, 8,'m'), (9,'',- 747241472, 2,'f',NULL, NULL,'USQVA' ),(10,' ',6,-3207125884 641214464, 'p',-1431502848 ,NULL,' FUBQO') ;
CREATE TABLE `bb` ( text_not_ null_key` text NOT NULL, char_1024_ key` varchar(1024) DEFAULT NULL, char_10_ not_null` varchar(10) NOT NULL, char_1024_ not_null_ key` varchar(1024) NOT NULL,
`pk` int NOT NULL DEFAULT '0',
`col_text` text,
`col_
`col_
`col_
`col_
`col_bigint_key` bigint DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `bb` VALUES (1,NULL, '','ANVSO' ,'f','IHTVZ' ,NULL), (2,NULL, '','JBJPT' ,'GQPHI' ,'a',NULL) ,(3,NULL, '','KAHJT' ,'her', 's',-6476739214 11219456) ,(4,NULL, '','q', 'you',' d',-57024015531 81179904) ,(5,NULL, '','l', 'but',' TTNNK', NULL),( 6,NULL, '','ULWFL' ,'XDMGU' ,'GKTRR' ,4),(7, NULL,'' ,'YOIXU' ,'NGHIX' ,'ZZDWO' ,NULL), (8,NULL, '','that\ 's','u' ,'up',8) ,(9,NULL, '','ZPPIG' ,'l','would' ,NULL), (10,NULL, '','like' ,'MDJAH' ,'JNAFV' ,NULL);
SELECT table1 . `col_text_ not_null_ key` AS field1 , table2 . `col_int_ not_null_ key` AS field2 , table2 . `col_bigint_ not_null_ key` AS field3 , table1 . `col_enum_ not_null_ key` AS field4 FROM ( AA AS table1 STRAIGHT_JOIN AA AS table2 ON (table2 . `pk` = table1 . `col_int_key` ) ) WHERE ( table1 . `col_int_key` IN ( SELECT 1 UNION SELECT 5 ) ) AND ( table1 . `pk` != table1 . `col_int` OR table1 . `col_int` < table1 . `col_int` ) GROUP BY field1, field2, field3, field4 HAVING ( 'm', 'u' ) IN ( SELECT SUBQUERY2_t1 . `col_text` AS SUBQUERY2_field1 , SUBQUERY2_t1 . `col_text_ not_null_ key` AS SUBQUERY2_field2 FROM ( BB AS SUBQUERY2_t1 RIGHT JOIN BB AS SUBQUERY2_t2 ON (SUBQUERY2_t2 . `col_char_1024_key` = SUBQUERY2_t1 . `col_char_ 10_not_ null` ) ) WHERE ( SUBQUERY2_t1 . `col_text` > SUBQUERY2_t1 . `col_char_ 1024_not_ null_key` AND SUBQUERY2_t2 . `col_bigint_key` < SUBQUERY2_t2 . `col_bigint_key` ) ) ORDER BY table1 . `col_char_ 1024_not_ null_key` , field1 DESC , table1 . `col_text_ not_null_ key` ASC, field1, field2, field3, field4 LIMIT 2 ;
DROP TABLE AA;
DROP TABLE BB;