Crash / assertion failed - "void drizzled::Select_Lex::print(drizzled::Session*, drizzled::String*, drizzled::enum_query_type)") at assert.c:81 #3 0x00000000006282fb in drizzled::Select_Lex::print (this=0x3911418, session=0x0, str=0x7f26b77fd7c0, query_type=drizzled::QT_ORDINARY) at drizzled/sql_select.cc:6592
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Undecided
|
PrafullaT | ||
Dexter |
Fix Released
|
Undecided
|
PrafullaT |
Bug Description
Crashing bug detected in randgen test optimizer_subquery:
"void drizzled:
#3 0x00000000006282fb in drizzled:
at drizzled/
Working on a test case for the test suite.
Randgen command line:
./gentest.pl --dsn=dbi:
Backtrace:
#0 0x00007f26d23f3a75 in *__GI_raise (sig=<value optimized out>) at ../nptl/
#1 0x00007f26d23f75c0 in *__GI_abort () at abort.c:92
#2 0x00007f26d23ec941 in *__GI___assert_fail (assertion=0x88775b "session", file=<value optimized out>, line=6592,
function=
#3 0x00000000006282fb in drizzled:
at drizzled/
#4 0x0000000000587b03 in drizzled:
#5 0x000000000052be6c in drizzled:
at drizzled/
#6 0x000000000062803d in drizzled:
at drizzled/
#7 0x000000000061420f in drizzled:
at drizzled/
#8 0x000000000061d7b1 in drizzled:
#9 0x000000000061d29e in mysql_execute_
#10 drizzled:
#11 0x000000000061f4d2 in drizzled:
packet_
#12 0x00000000005ef9bf in drizzled:
#13 0x00000000005f1f22 in drizzled:
#14 0x00007f26ce96f024 in MultiThreadSche
#15 session_thread (arg=<value optimized out>) at plugin/
#16 0x00007f26d27499ca in start_thread (arg=<value optimized out>) at pthread_
#17 0x00007f26d24a66fd in clone () at ../sysdeps/
#18 0x0000000000000000 in ?? ()
Related branches
Changed in drizzle: | |
status: | Confirmed → Fix Committed |
Failing query: 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
EXPLAIN EXTENDED SELECT table2 . `col_enum_