Server [mysqld.1 - pid: 7655, winpid: 7655, exit: 256] failed during test run
Server log from this test:
100324 23:27:34 [Note] Buffered information: Performance schema enabled.

100324 23:27:34 [Note] Plugin 'FEDERATED' is disabled.
100324 23:27:34 [Note] Plugin 'InnoDB' is disabled.
100324 23:27:34 [Note] Plugin 'ndbcluster' is disabled.
100324 23:27:34 [Note] Event Scheduler: Loaded 0 events
100324 23:27:34 [Note] /mysql-6.0/sql/mysqld: ready for connections.
Version: '6.0.14-alpha-gcov-debug-log'  socket: '/mysql-6.0/mysql-test/var/tmp/mysqld.1.sock'  port: 10210  Source distribution
mysqld: item_subselect.cc:303: virtual bool Item_in_subselect::exec(): Assertion `exec_method != MATERIALIZATION || (exec_method == MATERIALIZATION && engine->engine_type() == subselect_engine::HASH_SJ_ENGINE)' failed.
100324 23:27:35 - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60134 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0xafea028
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0xb38a0f0c thread_stack 0x30c00
/mysql-6.0/sql/mysqld(my_print_stacktrace+0x42) [0x8d1edf6]
/mysql-6.0/sql/mysqld(handle_segfault+0x4e3) [0x8421d0d]
[0x2a0400]
/lib/tls/i686/cmov/libc.so.6(abort+0x182) [0x82f932]
/lib/tls/i686/cmov/libc.so.6(__assert_fail+0xf8) [0x825648]
/mysql-6.0/sql/mysqld(Item_in_subselect::exec()+0x118) [0x836fbb2]
/mysql-6.0/sql/mysqld(Item_in_subselect::val_bool()+0x88) [0x8373802]
/mysql-6.0/sql/mysqld(Item::val_bool_result()+0x34) [0x827ea8c]
/mysql-6.0/sql/mysqld(Item_in_optimizer::val_int()+0x482) [0x82e70ac]
/mysql-6.0/sql/mysqld(Item::val_bool()+0x83) [0x824d19d]
/mysql-6.0/sql/mysqld(Item_cond_and::val_int()+0xd9) [0x82f7edf]
/mysql-6.0/sql/mysqld [0x8585a1c]
/mysql-6.0/sql/mysqld [0x854e362]
/mysql-6.0/sql/mysqld(JOIN::optimize()+0x1271) [0x853f303]
/mysql-6.0/sql/mysqld(subselect_single_select_engine::exec()+0x149) [0x837abdb]
/mysql-6.0/sql/mysqld(Item_subselect::exec()+0xf5) [0x836fa0d]
/mysql-6.0/sql/mysqld(Item_in_subselect::exec()+0x2ff) [0x836fd99]
/mysql-6.0/sql/mysqld(Item_in_subselect::val_bool()+0x88) [0x8373802]
/mysql-6.0/sql/mysqld(Item::val_bool_result()+0x34) [0x827ea8c]
/mysql-6.0/sql/mysqld(Item_in_optimizer::val_int()+0x482) [0x82e70ac]
/mysql-6.0/sql/mysqld(Item::val_bool()+0x83) [0x824d19d]
/mysql-6.0/sql/mysqld(Item_cond_and::val_int()+0xd9) [0x82f7edf]
/mysql-6.0/sql/mysqld(SQL_SELECT::skip_record()+0x45) [0x84cc927]
/mysql-6.0/sql/mysqld(JOIN_CACHE::check_match(unsigned char*)+0x40) [0x84cdf40]
/mysql-6.0/sql/mysqld(JOIN_CACHE::generate_full_extensions(unsigned char*)+0x3b) [0x84c8c8b]
/mysql-6.0/sql/mysqld(JOIN_CACHE_BNL::join_matching_records(bool)+0x6a9) [0x84c8929]
/mysql-6.0/sql/mysqld(JOIN_CACHE::join_records(bool)+0xfa) [0x84c7d2c]
/mysql-6.0/sql/mysqld(sub_select_cache(JOIN*, st_join_table*, bool)+0x10a) [0x858303f]
/mysql-6.0/sql/mysqld(sub_select(JOIN*, st_join_table*, bool)+0xa3) [0x85834ad]
/mysql-6.0/sql/mysqld [0x8582127]
/mysql-6.0/sql/mysqld(JOIN::exec()+0x400d) [0x85483c7]
/mysql-6.0/sql/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x5aa) [0x85490d1]
/mysql-6.0/sql/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x2e2) [0x853944d]
/mysql-6.0/sql/mysqld [0x8459ca5]
/mysql-6.0/sql/mysqld(mysql_execute_command(THD*)+0x1427) [0x8448b0c]
/mysql-6.0/sql/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x4ed) [0x845dd5a]
/mysql-6.0/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x12f5) [0x84439ad]
/mysql-6.0/sql/mysqld(do_command(THD*)+0x492) [0x84421c7]
/mysql-6.0/sql/mysqld(do_handle_one_connection(THD*)+0x2f6) [0x843e551]
/mysql-6.0/sql/mysqld(handle_one_connection+0x60) [0x843e238]
/mysql-6.0/sql/mysqld(pfs_spawn_thread(void*)+0x176) [0x8e7a303]
/lib/tls/i686/cmov/libpthread.so.0 [0x6e480e]
/lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0x8ce8de]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xaf1da88 = SELECT table1 .`col_varchar_nokey`  
FROM C table1  STRAIGHT_JOIN C table2  ON table2 .`col_int_key`  
WHERE ( table1 .`col_varchar_nokey`  , table2 .`col_varchar_nokey`  )  IN (  
SELECT SUBQUERY2_t1 .`col_varchar_nokey`  , SUBQUERY2_t1 .`col_varchar_nokey`  
FROM B SUBQUERY2_t1  LEFT  JOIN BB  ON SUBQUERY2_t1 .`pk`  AND (  3  ,  7  )  IN (  
SELECT `col_int_nokey`  ,  MIN( `pk`  )  
FROM CC  )  )
thd->thread_id=2
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file


 - saving '/mysql-6.0/mysql-test/var/log/main.exp1/' to '/mysql-6.0/mysql-test/var/log/main.exp1/'
 - found 'core' (0/5)

Trying 'dbx' to get a backtrace

Trying 'gdb' to get a backtrace
Core generated by '/mysql-6.0/sql/mysqld'
Output from gdb follows. The first stack trace is from the failing thread.
The following stack traces are from all threads (so the failing one is
duplicated).
--------------------------
[New Thread 7661]
[New Thread 7656]

warning: Can't read pathname for load map: Input/output error.
Core was generated by `/mysql-6.0/sql/mysqld --defaults-group-suffix=.1'.
Program terminated with signal 6, Aborted.
#0  0x002a0422 in __kernel_vsyscall ()
#0  0x002a0422 in __kernel_vsyscall ()
#1  0x006e9e93 in __pthread_kill (threadid=3012171632, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64
#2  0x08d1f00f in my_write_core (sig=6) at stacktrace.c:328
#3  0x08422222 in handle_segfault (sig=6) at mysqld.cc:2843
#4  <signal handler called>
#5  0x002a0422 in __kernel_vsyscall ()
#6  0x0082c4d1 in *__GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#7  0x0082f932 in *__GI_abort () at abort.c:92
#8  0x00825648 in *__GI___assert_fail (
    assertion=0x8fd6afc "exec_method != MATERIALIZATION || (exec_method == MATERIALIZATION && engine->engine_type() == subselect_engine::HASH_SJ_ENGINE)", file=0x8fd69ee "item_subselect.cc", line=303, function=0x8fd7ca0 "virtual bool Item_in_subselect::exec()") at assert.c:81
#9  0x0836fbb2 in Item_in_subselect::exec (this=0xb0a0fb0) at item_subselect.cc:303
#10 0x08373802 in Item_in_subselect::val_bool (this=0xb0a0fb0) at item_subselect.cc:929
#11 0x0827ea8c in Item::val_bool_result (this=0xb0a0fb0) at item.h:846
#12 0x082e70ac in Item_in_optimizer::val_int (this=0xb0b2730) at item_cmpfunc.cc:1825
#13 0x0824d19d in Item::val_bool (this=0xb0b2730) at item.cc:184
#14 0x082f7edf in Item_cond_and::val_int (this=0xb0a10a0) at item_cmpfunc.cc:4491
#15 0x08585a1c in join_read_const_table (tab=0xb0b47cc, pos=0xb0aafd0) at sql_select.cc:17109
#16 0x0854e362 in make_join_statistics (join=0xb0a88f0, tables_arg=0xb09f9a0, conds=0xb0b31d8, keyuse_array=0xb0ad61c) at sql_select.cc:4374
#17 0x0853f303 in JOIN::optimize (this=0xb0a88f0) at sql_select.cc:1662
#18 0x0837abdb in subselect_single_select_engine::exec (this=0xb0a16b0) at item_subselect.cc:2241
#19 0x0836fa0d in Item_subselect::exec (this=0xb0a15e8) at item_subselect.cc:283
#20 0x0836fd99 in Item_in_subselect::exec (this=0xb0a15e8) at item_subselect.cc:333
#21 0x08373802 in Item_in_subselect::val_bool (this=0xb0a15e8) at item_subselect.cc:929
#22 0x0827ea8c in Item::val_bool_result (this=0xb0a15e8) at item.h:846
#23 0x082e70ac in Item_in_optimizer::val_int (this=0xb0b2af8) at item_cmpfunc.cc:1825
#24 0x0824d19d in Item::val_bool (this=0xb0b2af8) at item.cc:184
#25 0x082f7edf in Item_cond_and::val_int (this=0xb0b4008) at item_cmpfunc.cc:4491
#26 0x084cc927 in SQL_SELECT::skip_record (this=0xb0b40c0) at opt_range.h:763
#27 0x084cdf40 in JOIN_CACHE::check_match (this=0xb0b4490, 
    rec_ptr=0xb3850020 "\361\001w\360\001m\360\001m\360\001k\362\001r\360\001t\360\001j\360\001u\361\001h\360\001o\375\360\001k\360\001e\360\001n\360\001t\360\001c\360\001m\360\001y\361\001f\360\001d") at sql_join_cache.cc:1971
#28 0x084c8c8b in JOIN_CACHE::generate_full_extensions (this=0xb0b4490, 
    rec_ptr=0xb3850020 "\361\001w\360\001m\360\001m\360\001k\362\001r\360\001t\360\001j\360\001u\361\001h\360\001o\375\360\001k\360\001e\360\001n\360\001t\360\001c\360\001m\360\001y\361\001f\360\001d") at sql_join_cache.cc:1921
#29 0x084c8929 in JOIN_CACHE_BNL::join_matching_records (this=0xb0b4490, skip_last=false) at sql_join_cache.cc:1820
#30 0x084c7d2c in JOIN_CACHE::join_records (this=0xb0b4490, skip_last=false) at sql_join_cache.cc:1627
#31 0x0858303f in sub_select_cache (join=0xb0a3a90, join_tab=0xb0b3cfc, end_of_records=true) at sql_select.cc:16405
#32 0x085834ad in sub_select (join=0xb0a3a90, join_tab=0xb0b3b40, end_of_records=true) at sql_select.cc:16568
#33 0x08582127 in do_select (join=0xb0a3a90, fields=0xafeb5c8, table=0x0, procedure=0x0) at sql_select.cc:16159
#34 0x085483c7 in JOIN::exec (this=0xb0a3a90) at sql_select.cc:2987
#35 0x085490d1 in mysql_select (thd=0xafea028, rref_pointer_array=0xafeb638, tables=0xaf1df20, wild_num=0, fields=..., conds=0xb0a15e8, 
    og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0xb0a1750, unit=0xafeb074, 
    select_lex=0xafeb534) at sql_select.cc:3184
#36 0x0853944d in handle_select (thd=0xafea028, lex=0xafeb018, result=0xb0a1750, setup_tables_done_option=0) at sql_select.cc:304
#37 0x08459ca5 in execute_sqlcom_select (thd=0xafea028, all_tables=0xaf1df20) at sql_parse.cc:5032
#38 0x08448b0c in mysql_execute_command (thd=0xafea028) at sql_parse.cc:2295
#39 0x0845dd5a in mysql_parse (thd=0xafea028, 
    inBuf=0xaf1da88 "SELECT table1 .`col_varchar_nokey`  \nFROM C table1  STRAIGHT_JOIN C table2  ON table2 .`col_int_key`  \nWHERE ( table1 .`col_varchar_nokey`  , table2 .`col_varchar_nokey`  )  IN (  \nSELECT SUBQUERY2_t1"..., length=401, found_semicolon=0xb38a0910)
    at sql_parse.cc:6060
#40 0x084439ad in dispatch_command (command=COM_QUERY, thd=0xafea028, packet=0xafb8eb1 "", packet_length=404) at sql_parse.cc:1091
#41 0x084421c7 in do_command (thd=0xafea028) at sql_parse.cc:775
#42 0x0843e551 in do_handle_one_connection (thd_arg=0xafea028) at sql_connect.cc:1173
#43 0x0843e238 in handle_one_connection (arg=0xafea028) at sql_connect.cc:1113
#44 0x08e7a303 in pfs_spawn_thread (arg=0xb02b688) at pfs.cc:1011
#45 0x006e480e in start_thread (arg=0xb38a1770) at pthread_create.c:300
#46 0x008ce8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130

Thread 3 (Thread 7656):
#0  0x002a0422 in __kernel_vsyscall ()
#1  0x008c0c96 in *__GI___poll (fds=0x942ff4, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:87
#2  0x0842bd61 in handle_connections_sockets () at mysqld.cc:5562
#3  0x0842a71b in mysqld_main (argc=47, argv=0xac66890) at mysqld.cc:5035
#4  0x084189ff in main (argc=8, argv=0xbfd34af4) at main.cc:24

Thread 2 (Thread 7661):
#0  0x002a0422 in __kernel_vsyscall ()
#1  0x006ecd5a in do_sigwait (set=0x6f4ff4, sig=<value optimized out>)
    at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63
#2  0x006ece00 in __sigwait (set=0xb38d1e94, sig=0xb38d1f2c)
    at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100
#3  0x08423395 in signal_hand (arg=0x0) at mysqld.cc:3046
#4  0x08e7a303 in pfs_spawn_thread (arg=0xadfb210) at pfs.cc:1011
#5  0x006e480e in start_thread (arg=0xb38d2770) at pthread_create.c:300
#6  0x008ce8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130

Thread 1 (Thread 7678):
#0  0x002a0422 in __kernel_vsyscall ()
#1  0x006e9e93 in __pthread_kill (threadid=3012171632, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64
#2  0x08d1f00f in my_write_core (sig=6) at stacktrace.c:328
#3  0x08422222 in handle_segfault (sig=6) at mysqld.cc:2843
#4  <signal handler called>
#5  0x002a0422 in __kernel_vsyscall ()
#6  0x0082c4d1 in *__GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#7  0x0082f932 in *__GI_abort () at abort.c:92
#8  0x00825648 in *__GI___assert_fail (
    assertion=0x8fd6afc "exec_method != MATERIALIZATION || (exec_method == MATERIALIZATION && engine->engine_type() == subselect_engine::HASH_SJ_ENGINE)", file=0x8fd69ee "item_subselect.cc", line=303, function=0x8fd7ca0 "virtual bool Item_in_subselect::exec()") at assert.c:81
#9  0x0836fbb2 in Item_in_subselect::exec (this=0xb0a0fb0) at item_subselect.cc:303
#10 0x08373802 in Item_in_subselect::val_bool (this=0xb0a0fb0) at item_subselect.cc:929
#11 0x0827ea8c in Item::val_bool_result (this=0xb0a0fb0) at item.h:846
#12 0x082e70ac in Item_in_optimizer::val_int (this=0xb0b2730) at item_cmpfunc.cc:1825
#13 0x0824d19d in Item::val_bool (this=0xb0b2730) at item.cc:184
#14 0x082f7edf in Item_cond_and::val_int (this=0xb0a10a0) at item_cmpfunc.cc:4491
#15 0x08585a1c in join_read_const_table (tab=0xb0b47cc, pos=0xb0aafd0) at sql_select.cc:17109
#16 0x0854e362 in make_join_statistics (join=0xb0a88f0, tables_arg=0xb09f9a0, conds=0xb0b31d8, keyuse_array=0xb0ad61c) at sql_select.cc:4374
#17 0x0853f303 in JOIN::optimize (this=0xb0a88f0) at sql_select.cc:1662
#18 0x0837abdb in subselect_single_select_engine::exec (this=0xb0a16b0) at item_subselect.cc:2241
#19 0x0836fa0d in Item_subselect::exec (this=0xb0a15e8) at item_subselect.cc:283
#20 0x0836fd99 in Item_in_subselect::exec (this=0xb0a15e8) at item_subselect.cc:333
#21 0x08373802 in Item_in_subselect::val_bool (this=0xb0a15e8) at item_subselect.cc:929
#22 0x0827ea8c in Item::val_bool_result (this=0xb0a15e8) at item.h:846
#23 0x082e70ac in Item_in_optimizer::val_int (this=0xb0b2af8) at item_cmpfunc.cc:1825
#24 0x0824d19d in Item::val_bool (this=0xb0b2af8) at item.cc:184
#25 0x082f7edf in Item_cond_and::val_int (this=0xb0b4008) at item_cmpfunc.cc:4491
#26 0x084cc927 in SQL_SELECT::skip_record (this=0xb0b40c0) at opt_range.h:763
#27 0x084cdf40 in JOIN_CACHE::check_match (this=0xb0b4490, 
    rec_ptr=0xb3850020 "\361\001w\360\001m\360\001m\360\001k\362\001r\360\001t\360\001j\360\001u\361\001h\360\001o\375\360\001k\360\001e\360\001n\360\001t\360\001c\360\001m\360\001y\361\001f\360\001d") at sql_join_cache.cc:1971
#28 0x084c8c8b in JOIN_CACHE::generate_full_extensions (this=0xb0b4490, 
    rec_ptr=0xb3850020 "\361\001w\360\001m\360\001m\360\001k\362\001r\360\001t\360\001j\360\001u\361\001h\360\001o\375\360\001k\360\001e\360\001n\360\001t\360\001c\360\001m\360\001y\361\001f\360\001d") at sql_join_cache.cc:1921
#29 0x084c8929 in JOIN_CACHE_BNL::join_matching_records (this=0xb0b4490, skip_last=false) at sql_join_cache.cc:1820
#30 0x084c7d2c in JOIN_CACHE::join_records (this=0xb0b4490, skip_last=false) at sql_join_cache.cc:1627
#31 0x0858303f in sub_select_cache (join=0xb0a3a90, join_tab=0xb0b3cfc, end_of_records=true) at sql_select.cc:16405
#32 0x085834ad in sub_select (join=0xb0a3a90, join_tab=0xb0b3b40, end_of_records=true) at sql_select.cc:16568
#33 0x08582127 in do_select (join=0xb0a3a90, fields=0xafeb5c8, table=0x0, procedure=0x0) at sql_select.cc:16159
#34 0x085483c7 in JOIN::exec (this=0xb0a3a90) at sql_select.cc:2987
#35 0x085490d1 in mysql_select (thd=0xafea028, rref_pointer_array=0xafeb638, tables=0xaf1df20, wild_num=0, fields=..., conds=0xb0a15e8, 
    og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0xb0a1750, unit=0xafeb074, 
    select_lex=0xafeb534) at sql_select.cc:3184
#36 0x0853944d in handle_select (thd=0xafea028, lex=0xafeb018, result=0xb0a1750, setup_tables_done_option=0) at sql_select.cc:304
#37 0x08459ca5 in execute_sqlcom_select (thd=0xafea028, all_tables=0xaf1df20) at sql_parse.cc:5032
#38 0x08448b0c in mysql_execute_command (thd=0xafea028) at sql_parse.cc:2295
#39 0x0845dd5a in mysql_parse (thd=0xafea028, 
    inBuf=0xaf1da88 "SELECT table1 .`col_varchar_nokey`  \nFROM C table1  STRAIGHT_JOIN C table2  ON table2 .`col_int_key`  \nWHERE ( table1 .`col_varchar_nokey`  , table2 .`col_varchar_nokey`  )  IN (  \nSELECT SUBQUERY2_t1"..., length=401, found_semicolon=0xb38a0910)
    at sql_parse.cc:6060
#40 0x084439ad in dispatch_command (command=COM_QUERY, thd=0xafea028, packet=0xafb8eb1 "", packet_length=404) at sql_parse.cc:1091
#41 0x084421c7 in do_command (thd=0xafea028) at sql_parse.cc:775
#42 0x0843e551 in do_handle_one_connection (thd_arg=0xafea028) at sql_connect.cc:1173
#43 0x0843e238 in handle_one_connection (arg=0xafea028) at sql_connect.cc:1113
#44 0x08e7a303 in pfs_spawn_thread (arg=0xb02b688) at pfs.cc:1011
#45 0x006e480e in start_thread (arg=0xb38a1770) at pthread_create.c:300
#46 0x008ce8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130