Crash in TABLE_LIST::print on EXPLAIN EXTENDED

Bug #901506 reported by Elena Stepanova
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Critical
Sergey Petrunia

Bug Description

#3 <signal handler called>
#4 0x00000000007a5c25 in TABLE_LIST::print (this=0x2ee1808, thd=0x2e1c028,
    eliminated_tables=0, str=0x7f39504bbc80, query_type=QT_ORDINARY)
    at sql_select.cc:21458
#5 0x00000000007a55d6 in print_table_array (thd=0x2e1c028,
    eliminated_tables=0, str=0x7f39504bbc80, table=0x2eec080, end=0x2eec090,
    query_type=QT_ORDINARY) at sql_select.cc:21304
#6 0x00000000007a599d in print_join (thd=0x2e1c028, eliminated_tables=0,
    str=0x7f39504bbc80, tables=0x2e1eb18, query_type=QT_ORDINARY)
    at sql_select.cc:21398
#7 0x00000000007a6359 in st_select_lex::print (this=0x2e1e9b0, thd=0x2e1c028,
    str=0x7f39504bbc80, query_type=QT_ORDINARY) at sql_select.cc:21608
#8 0x00000000005d1868 in st_select_lex_unit::print (this=0x2e1e4c8,
    str=0x7f39504bbc80, query_type=QT_ORDINARY) at sql_lex.cc:2090
#9 0x00000000006fc622 in execute_sqlcom_select (thd=0x2e1c028,
    all_tables=0x2ea7518) at sql_parse.cc:5097
#10 0x00000000006f381a in mysql_execute_command (thd=0x2e1c028)
    at sql_parse.cc:2250
#11 0x00000000006ff124 in mysql_parse (thd=0x2e1c028,
    rawbuf=0x2ea72d0 "EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN ( SELECT MIN(a) FROM t1 )", length=70, found_semicolon=0x7f39504bcc98) at sql_parse.cc:6113
#12 0x00000000006f1032 in dispatch_command (command=COM_QUERY, thd=0x2e1c028,
    packet=0x2efcca9 "", packet_length=70) at sql_parse.cc:1221
#13 0x00000000006f0366 in do_command (thd=0x2e1c028) at sql_parse.cc:916
#14 0x00000000006ed2bc in handle_one_connection (arg=0x2e1c028)
    at sql_connect.cc:1191
#15 0x00007f396abe2a4f in start_thread () from /lib64/libpthread.so.0
#16 0x00007f3969fcc82d in clone () from /lib64/libc.so.6

bzr revision-info
3337 <email address hidden>
elenst@perro:~/maria-5.3/mysql-test> bzr version-info
revision-id: <email address hidden>
date: 2011-12-08 04:22:38 +0400
build-date: 2011-12-08 04:17:31 +0200
revno: 3337
branch-nick: maria-5.3

Minimal optimizer_switch: not required.

Full optimizer_switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on

Test case:

CREATE TABLE t1 ( a INT, KEY(a) );
INSERT INTO t1 VALUES (8);

EXPLAIN EXTENDED
  SELECT * FROM t1
   WHERE a IN ( SELECT MIN(a) FROM t1 );

Elena Stepanova (elenst)
Changed in maria:
milestone: none → 5.3
Elena Stepanova (elenst)
Changed in maria:
assignee: nobody → Sergey Petrunia (sergefp)
Changed in maria:
importance: Undecided → Critical
Changed in maria:
status: New → Fix Committed
Revision history for this message
Elena Stepanova (elenst) wrote :

Released with 5.3.3-rc.

Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.