#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 );