Server [mysqld.1 - pid: 17892, winpid: 17892, exit: 256] failed during test run
Server log from this test:
100324 23:57:53 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
100324 23:57:53 [Note] Plugin 'FEDERATED' is disabled.
100324 23:57:53 [Note] Plugin 'InnoDB' is disabled.
100324 23:57:53 [Note] Plugin 'ndbcluster' is disabled.
100324 23:57:53 [Note] Event Scheduler: Loaded 0 events
100324 23:57:53 [Note] /mysql-5.1/sql/mysqld: ready for connections.
Version: '5.1.46-gcov-debug-log'  socket: '/mysql-5.1/mysql-test/var/tmp/mysqld.1.sock'  port: 13000  Source distribution
100324 23:57:53 - mysqld got signal 11 ;
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
threads_connected=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 59976 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0xa0dc7d8
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 = 0xb6eea38c thread_stack 0x30000
/mysql-5.1/sql/mysqld(my_print_stacktrace+0x42)[0x8cbd71e]
/mysql-5.1/sql/mysqld(handle_segfault+0x4a8)[0x83cf5bd]
[0x500400]
/mysql-5.1/sql/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x23a)[0x85065a0]
/mysql-5.1/sql/mysqld[0x8505a33]
/mysql-5.1/sql/mysqld(_ZN4JOIN4execEv+0x4460)[0x84db4a6]
/mysql-5.1/sql/mysqld(_ZN30subselect_single_select_engine4execEv+0xa0a)[0x833453a]
/mysql-5.1/sql/mysqld(_ZN14Item_subselect4execEv+0x13f)[0x8328ad1]
/mysql-5.1/sql/mysqld(_ZN17Item_in_subselect8val_boolEv+0x88)[0x832cb80]
/mysql-5.1/sql/mysqld(_ZN4Item15val_bool_resultEv+0x34)[0x823e536]
/mysql-5.1/sql/mysqld(_ZN17Item_in_optimizer7val_intEv+0x472)[0x82a4086]
/mysql-5.1/sql/mysqld[0x84f32fd]
/mysql-5.1/sql/mysqld(_ZN4JOIN4execEv+0xbac)[0x84d7bf2]
/mysql-5.1/sql/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x658)[0x84dc3dd]
/mysql-5.1/sql/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x31e)[0x84cd9c5]
/mysql-5.1/sql/mysqld[0x8408425]
/mysql-5.1/sql/mysqld(_Z21mysql_execute_commandP3THD+0x1116)[0x83f5598]
/mysql-5.1/sql/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x58d)[0x840cb28]
/mysql-5.1/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x167f)[0x83f09d8]
/mysql-5.1/sql/mysqld(_Z10do_commandP3THD+0x4f6)[0x83eec2f]
/mysql-5.1/sql/mysqld(handle_one_connection+0x2fe)[0x83eb29b]
/lib/tls/i686/cmov/libpthread.so.0[0x51580e]
/lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0x35d8de]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xa12e058 = SELECT  SUM( `col_varchar_key`  )  
FROM C  
HAVING (  4  ,  3  )  IN (  
SELECT SUBQUERY3_t2 .`col_int_nokey`  , SUBQUERY3_t2 .`col_int_key`  
FROM C SUBQUERY3_t1  JOIN C SUBQUERY3_t2  ON SUBQUERY3_t1 .`col_varchar_key`  )
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-5.1/mysql-test/var/log/main.exp1/' to '/mysql-5.1/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-5.1/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 17893]
[New Thread 17895]

warning: Can't read pathname for load map: Input/output error.
Core was generated by `/mysql-5.1/sql/mysqld --defaults-group-suffix=.1'.
Program terminated with signal 11, Segmentation fault.
#0  0x00500422 in __kernel_vsyscall ()
#0  0x00500422 in __kernel_vsyscall ()
#1  0x0051ae93 in __pthread_kill (threadid=3069094768, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64
#2  0x08cbd8a6 in my_write_core (sig=11) at stacktrace.c:329
#3  0x083cfad2 in handle_segfault (sig=11) at mysqld.cc:2570
#4  <signal handler called>
#5  0x085096d9 in join_read_next_same (info=0xa13c078) at sql_select.cc:11980
#6  0x085065a0 in sub_select (join=0xa13ad48, join_tab=0xa13c038, end_of_records=false) at sql_select.cc:11316
#7  0x08505a33 in do_select (join=0xa13ad48, fields=0xa12e8ac, table=0x0, procedure=0x0) at sql_select.cc:11067
#8  0x084db4a6 in JOIN::exec (this=0xa13ad48) at sql_select.cc:2315
#9  0x0833453a in subselect_single_select_engine::exec (this=0xa12f5f8) at item_subselect.cc:1972
#10 0x08328ad1 in Item_subselect::exec (this=0xa12f548) at item_subselect.cc:265
#11 0x0832cb80 in Item_in_subselect::val_bool (this=0xa12f548) at item_subselect.cc:865
#12 0x0823e536 in Item::val_bool_result (this=0xa12f548) at item.h:745
#13 0x082a4086 in Item_in_optimizer::val_int (this=0xa12f818) at item_cmpfunc.cc:1833
#14 0x084f32fd in return_zero_rows (join=0xa138d60, result=0xa12f690, tables=0xa12e4d0, fields=..., send_row=true, 
    select_options=2147764736, info=0x8ea80c8 "Impossible HAVING noticed after reading const tables", having=0xa12f818) at sql_select.cc:7269
#15 0x084d7bf2 in JOIN::exec (this=0xa138d60) at sql_select.cc:1834
#16 0x084dc3dd in mysql_select (thd=0xa0dc7d8, rref_pointer_array=0xa0ddc78, tables=0xa12e4d0, wild_num=0, fields=..., conds=0x0, og_num=0, 
    order=0x0, group=0x0, having=0xa12f548, proc_param=0x0, select_options=2147764736, result=0xa12f690, unit=0xa0dd910, 
    select_lex=0xa0ddb80) at sql_select.cc:2510
#17 0x084cd9c5 in handle_select (thd=0xa0dc7d8, lex=0xa0dd8b4, result=0xa12f690, setup_tables_done_option=0) at sql_select.cc:269
#18 0x08408425 in execute_sqlcom_select (thd=0xa0dc7d8, all_tables=0xa12e4d0) at sql_parse.cc:5052
#19 0x083f5598 in mysql_execute_command (thd=0xa0dc7d8) at sql_parse.cc:2248
#20 0x0840cb28 in mysql_parse (thd=0xa0dc7d8, 
    inBuf=0xa12e058 "SELECT  SUM( `col_varchar_key`  )  \nFROM C  \nHAVING (  4  ,  3  )  IN (  \nSELECT SUBQUERY3_t2 .`col_int_nokey`  , SUBQUERY3_t2 .`col_int_key`  \nFROM C SUBQUERY3_t1  JOIN C SUBQUERY3_t2  ON SUBQUERY3_t"..., length=223, found_semicolon=0xb6eea058)
    at sql_parse.cc:5971
#21 0x083f09d8 in dispatch_command (command=COM_QUERY, thd=0xa0dc7d8, 
    packet=0xa122111 "SELECT  SUM( `col_varchar_key`  )  \nFROM C  \nHAVING (  4  ,  3  )  IN (  \nSELECT SUBQUERY3_t2 .`col_int_nokey`  , SUBQUERY3_t2 .`col_int_key`  \nFROM C SUBQUERY3_t1  JOIN C SUBQUERY3_t2  ON SUBQUERY3_t"..., packet_length=226) at sql_parse.cc:1233
#22 0x083eec2f in do_command (thd=0xa0dc7d8) at sql_parse.cc:874
#23 0x083eb29b in handle_one_connection (arg=0xa0dc7d8) at sql_connect.cc:1127
#24 0x0051580e in start_thread (arg=0xb6eeab70) at pthread_create.c:300
#25 0x0035d8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130

Thread 3 (Thread 17895):
#0  0x00500422 in __kernel_vsyscall ()
#1  0x0051dd5a in do_sigwait (set=0x525ff4, sig=<value optimized out>)
    at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63
#2  0x0051de00 in __sigwait (set=0xb6f1b2f0, sig=0xb6f1b388)
    at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100
#3  0x083d0e74 in signal_hand (arg=0x0) at mysqld.cc:2772
#4  0x0051580e in start_thread (arg=0xb6f1bb70) at pthread_create.c:300
#5  0x0035d8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130

Thread 2 (Thread 17893):
#0  0x00500422 in __kernel_vsyscall ()
#1  0x00356a71 in select () from /lib/tls/i686/cmov/libc.so.6
#2  0x083d90f5 in handle_connections_sockets (arg=0x0) at mysqld.cc:5054
#3  0x083d76bf in main (argc=8, argv=0xbf820264) at mysqld.cc:4538

Thread 1 (Thread 17903):
#0  0x00500422 in __kernel_vsyscall ()
#1  0x0051ae93 in __pthread_kill (threadid=3069094768, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64
#2  0x08cbd8a6 in my_write_core (sig=11) at stacktrace.c:329
#3  0x083cfad2 in handle_segfault (sig=11) at mysqld.cc:2570
#4  <signal handler called>
#5  0x085096d9 in join_read_next_same (info=0xa13c078) at sql_select.cc:11980
#6  0x085065a0 in sub_select (join=0xa13ad48, join_tab=0xa13c038, end_of_records=false) at sql_select.cc:11316
#7  0x08505a33 in do_select (join=0xa13ad48, fields=0xa12e8ac, table=0x0, procedure=0x0) at sql_select.cc:11067
#8  0x084db4a6 in JOIN::exec (this=0xa13ad48) at sql_select.cc:2315
#9  0x0833453a in subselect_single_select_engine::exec (this=0xa12f5f8) at item_subselect.cc:1972
#10 0x08328ad1 in Item_subselect::exec (this=0xa12f548) at item_subselect.cc:265
#11 0x0832cb80 in Item_in_subselect::val_bool (this=0xa12f548) at item_subselect.cc:865
#12 0x0823e536 in Item::val_bool_result (this=0xa12f548) at item.h:745
#13 0x082a4086 in Item_in_optimizer::val_int (this=0xa12f818) at item_cmpfunc.cc:1833
#14 0x084f32fd in return_zero_rows (join=0xa138d60, result=0xa12f690, tables=0xa12e4d0, fields=..., send_row=true, 
    select_options=2147764736, info=0x8ea80c8 "Impossible HAVING noticed after reading const tables", having=0xa12f818) at sql_select.cc:7269
#15 0x084d7bf2 in JOIN::exec (this=0xa138d60) at sql_select.cc:1834
#16 0x084dc3dd in mysql_select (thd=0xa0dc7d8, rref_pointer_array=0xa0ddc78, tables=0xa12e4d0, wild_num=0, fields=..., conds=0x0, og_num=0, 
    order=0x0, group=0x0, having=0xa12f548, proc_param=0x0, select_options=2147764736, result=0xa12f690, unit=0xa0dd910, 
    select_lex=0xa0ddb80) at sql_select.cc:2510
#17 0x084cd9c5 in handle_select (thd=0xa0dc7d8, lex=0xa0dd8b4, result=0xa12f690, setup_tables_done_option=0) at sql_select.cc:269
#18 0x08408425 in execute_sqlcom_select (thd=0xa0dc7d8, all_tables=0xa12e4d0) at sql_parse.cc:5052
#19 0x083f5598 in mysql_execute_command (thd=0xa0dc7d8) at sql_parse.cc:2248
#20 0x0840cb28 in mysql_parse (thd=0xa0dc7d8, 
    inBuf=0xa12e058 "SELECT  SUM( `col_varchar_key`  )  \nFROM C  \nHAVING (  4  ,  3  )  IN (  \nSELECT SUBQUERY3_t2 .`col_int_nokey`  , SUBQUERY3_t2 .`col_int_key`  \nFROM C SUBQUERY3_t1  JOIN C SUBQUERY3_t2  ON SUBQUERY3_t"..., length=223, found_semicolon=0xb6eea058)
    at sql_parse.cc:5971
#21 0x083f09d8 in dispatch_command (command=COM_QUERY, thd=0xa0dc7d8, 
    packet=0xa122111 "SELECT  SUM( `col_varchar_key`  )  \nFROM C  \nHAVING (  4  ,  3  )  IN (  \nSELECT SUBQUERY3_t2 .`col_int_nokey`  , SUBQUERY3_t2 .`col_int_key`  \nFROM C SUBQUERY3_t1  JOIN C SUBQUERY3_t2  ON SUBQUERY3_t"..., packet_length=226) at sql_parse.cc:1233
#22 0x083eec2f in do_command (thd=0xa0dc7d8) at sql_parse.cc:874
#23 0x083eb29b in handle_one_connection (arg=0xa0dc7d8) at sql_connect.cc:1127
#24 0x0051580e in start_thread (arg=0xb6eeab70) at pthread_create.c:300
#25 0x0035d8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130