Server [mysqld.1 - pid: 20114, winpid: 20114, exit: 256] failed during test run
Server log from this test:
100324  1:44:32 [Note] Buffered information: Performance schema enabled.

100324  1:44:32 [Note] Plugin 'FEDERATED' is disabled.
100324  1:44:32 [Note] Plugin 'InnoDB' is disabled.
100324  1:44:32 [Note] Plugin 'ndbcluster' is disabled.
100324  1:44:32 [Note] Event Scheduler: Loaded 0 events
100324  1:44:32 [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: 13000  Source distribution
mysqld: field.cc:6833: virtual int Field_varstring::store(const char*, uint, CHARSET_INFO*): Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, field_index))' failed.
100324  1:44:32 - 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: 0xaadd008
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 = 0xb3814f0c thread_stack 0x30c00
/mysql-6.0/sql/mysqld(my_print_stacktrace+0x42) [0x8d1edf6]
/mysql-6.0/sql/mysqld(handle_segfault+0x4e3) [0x8421d0d]
[0xdd6400]
/lib/tls/i686/cmov/libc.so.6(abort+0x182) [0x13d932]
/lib/tls/i686/cmov/libc.so.6(__assert_fail+0xf8) [0x133648]
/mysql-6.0/sql/mysqld(Field_varstring::store(char const*, unsigned int, charset_info_st*)+0x102) [0x83bc380]
/mysql-6.0/sql/mysqld(Item::save_in_field(Field*, bool)+0x292) [0x8268e46]
/mysql-6.0/sql/mysqld(Item_cache_str::save_in_field(Field*, bool)+0xfb) [0x8276efd]
/mysql-6.0/sql/mysqld(Item_ref::save_in_field(Field*, bool)+0xa3) [0x826fb31]
/mysql-6.0/sql/mysqld(store_key_const_item::copy_inner()+0x81) [0x85a6daf]
/mysql-6.0/sql/mysqld(store_key::copy()+0x9d) [0x838266f]
/mysql-6.0/sql/mysqld(subselect_uniquesubquery_engine::copy_ref_key()+0x9e) [0x837b83c]
/mysql-6.0/sql/mysqld(subselect_indexsubquery_engine::exec()+0xe8) [0x837bfd4]
/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_subselect::exec()+0x13a) [0x836fa52]
/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_func_not::val_int()+0x8a) [0x82dee7a]
/mysql-6.0/sql/mysqld [0x8561147]
/mysql-6.0/sql/mysqld(JOIN::optimize()+0x216d) [0x85401ff]
/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*)+0x47b) [0x8548fa2]
/mysql-6.0/sql/mysqld(mysql_explain_union(THD*, st_select_lex_unit*, select_result*)+0x5d9) [0x85a20bb]
/mysql-6.0/sql/mysqld [0x8459858]
/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 [0xad780e]
/lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0x1dc8de]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xaa10a88 = EXPLAIN  
SELECT `col_datetime_key`  
FROM (  
SELECT * 
FROM C  ) table1  
WHERE ( 'd' , 'z' )  NOT  IN (  
SELECT `col_varchar_key`  , `col_varchar_nokey`  
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 20117]
[New Thread 20115]

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  0x00dd6422 in __kernel_vsyscall ()
#0  0x00dd6422 in __kernel_vsyscall ()
#1  0x00adce93 in __pthread_kill (threadid=3011598192, 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  0x00dd6422 in __kernel_vsyscall ()
#6  0x0013a4d1 in *__GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#7  0x0013d932 in *__GI_abort () at abort.c:92
#8  0x00133648 in *__GI___assert_fail (assertion=0x8fe3f14 "!table || (!table->write_set || bitmap_is_set(table->write_set, field_index))", 
    file=0x8fe3d6c "field.cc", line=6833, function=0x8fe5820 "virtual int Field_varstring::store(const char*, uint, CHARSET_INFO*)")
    at assert.c:81
#9  0x083bc380 in Field_varstring::store (this=0xabad7b0, from=0xabac64d "d", length=1, cs=0x91daa00) at field.cc:6833
#10 0x08268e46 in Item::save_in_field (this=0xabac5e0, field=0xabad7b0, no_conversions=true) at item.cc:5395
#11 0x08276efd in Item_cache_str::save_in_field (this=0xabac5e0, field=0xabad7b0, no_conversions=true) at item.cc:7693
#12 0x0826fb31 in Item_ref::save_in_field (this=0xab777e8, to=0xabad7b0, no_conversions=true) at item.cc:6555
#13 0x085a6daf in store_key_const_item::copy_inner (this=0xabad790) at sql_select.h:2007
#14 0x0838266f in store_key::copy (this=0xabad790) at sql_select.h:1902
#15 0x0837b83c in subselect_uniquesubquery_engine::copy_ref_key (this=0xabae280) at item_subselect.cc:2442
#16 0x0837bfd4 in subselect_indexsubquery_engine::exec (this=0xabae280) at item_subselect.cc:2644
#17 0x0836fa0d in Item_subselect::exec (this=0xab76320) at item_subselect.cc:283
#18 0x0836fd99 in Item_in_subselect::exec (this=0xab76320) at item_subselect.cc:333
#19 0x0836fa52 in Item_subselect::exec (this=0xab76320) at item_subselect.cc:288
#20 0x0836fd99 in Item_in_subselect::exec (this=0xab76320) at item_subselect.cc:333
#21 0x08373802 in Item_in_subselect::val_bool (this=0xab76320) at item_subselect.cc:929
#22 0x0827ea8c in Item::val_bool_result (this=0xab76320) at item.h:846
#23 0x082e70ac in Item_in_optimizer::val_int (this=0xab77518) at item_cmpfunc.cc:1825
#24 0x0824d19d in Item::val_bool (this=0xab77518) at item.cc:184
#25 0x082dee7a in Item_func_not::val_int (this=0xab763d8) at item_cmpfunc.cc:287
#26 0x08561147 in make_join_select (join=0xaba1f28, cond=0xab763d8) at sql_select.cc:8977
#27 0x085401ff in JOIN::optimize (this=0xaba1f28) at sql_select.cc:1757
#28 0x08548fa2 in mysql_select (thd=0xaadd008, rref_pointer_array=0xaade618, tables=0xaa121a0, wild_num=0, fields=..., conds=0xab763d8, 
    og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748612, result=0xab76fc0, unit=0xaade054, 
    select_lex=0xaade514) at sql_select.cc:3170
#29 0x085a20bb in mysql_explain_union (thd=0xaadd008, unit=0xaade054, result=0xab76fc0) at sql_select.cc:22378
#30 0x08459858 in execute_sqlcom_select (thd=0xaadd008, all_tables=0xaa121a0) at sql_parse.cc:5010
#31 0x08448b0c in mysql_execute_command (thd=0xaadd008) at sql_parse.cc:2295
#32 0x0845dd5a in mysql_parse (thd=0xaadd008, 
    inBuf=0xaa10a88 "EXPLAIN  \nSELECT `col_datetime_key`  \nFROM (  \nSELECT * \nFROM C  ) table1  \nWHERE ( 'd' , 'z' )  NOT  IN (  \nSELECT `col_varchar_key`  , `col_varchar_nokey`  \nFROM CC  )", length=169, found_semicolon=0xb3814910) at sql_parse.cc:6060
#33 0x084439ad in dispatch_command (command=COM_QUERY, thd=0xaadd008, packet=0xaaabeb1 "", packet_length=172) at sql_parse.cc:1091
#34 0x084421c7 in do_command (thd=0xaadd008) at sql_parse.cc:775
#35 0x0843e551 in do_handle_one_connection (thd_arg=0xaadd008) at sql_connect.cc:1173
#36 0x0843e238 in handle_one_connection (arg=0xaadd008) at sql_connect.cc:1113
#37 0x08e7a303 in pfs_spawn_thread (arg=0xab1e5c8) at pfs.cc:1011
#38 0x00ad780e in start_thread (arg=0xb3815770) at pthread_create.c:300
#39 0x001dc8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130

Thread 3 (Thread 20115):
#0  0x00dd6422 in __kernel_vsyscall ()
#1  0x001cec96 in *__GI___poll (fds=0x250ff4, 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=0xa759890) at mysqld.cc:5035
#4  0x084189ff in main (argc=8, argv=0xbfc5f374) at main.cc:24

Thread 2 (Thread 20117):
#0  0x00dd6422 in __kernel_vsyscall ()
#1  0x00adfd5a in do_sigwait (set=0xae7ff4, sig=<value optimized out>)
    at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63
#2  0x00adfe00 in __sigwait (set=0xb3845e94, sig=0xb3845f2c)
    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=0xa8ee210) at pfs.cc:1011
#5  0x00ad780e in start_thread (arg=0xb3846770) at pthread_create.c:300
#6  0x001dc8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130

Thread 1 (Thread 20125):
#0  0x00dd6422 in __kernel_vsyscall ()
#1  0x00adce93 in __pthread_kill (threadid=3011598192, 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  0x00dd6422 in __kernel_vsyscall ()
#6  0x0013a4d1 in *__GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#7  0x0013d932 in *__GI_abort () at abort.c:92
#8  0x00133648 in *__GI___assert_fail (assertion=0x8fe3f14 "!table || (!table->write_set || bitmap_is_set(table->write_set, field_index))", 
    file=0x8fe3d6c "field.cc", line=6833, function=0x8fe5820 "virtual int Field_varstring::store(const char*, uint, CHARSET_INFO*)")
    at assert.c:81
#9  0x083bc380 in Field_varstring::store (this=0xabad7b0, from=0xabac64d "d", length=1, cs=0x91daa00) at field.cc:6833
#10 0x08268e46 in Item::save_in_field (this=0xabac5e0, field=0xabad7b0, no_conversions=true) at item.cc:5395
#11 0x08276efd in Item_cache_str::save_in_field (this=0xabac5e0, field=0xabad7b0, no_conversions=true) at item.cc:7693
#12 0x0826fb31 in Item_ref::save_in_field (this=0xab777e8, to=0xabad7b0, no_conversions=true) at item.cc:6555
#13 0x085a6daf in store_key_const_item::copy_inner (this=0xabad790) at sql_select.h:2007
#14 0x0838266f in store_key::copy (this=0xabad790) at sql_select.h:1902
#15 0x0837b83c in subselect_uniquesubquery_engine::copy_ref_key (this=0xabae280) at item_subselect.cc:2442
#16 0x0837bfd4 in subselect_indexsubquery_engine::exec (this=0xabae280) at item_subselect.cc:2644
#17 0x0836fa0d in Item_subselect::exec (this=0xab76320) at item_subselect.cc:283
#18 0x0836fd99 in Item_in_subselect::exec (this=0xab76320) at item_subselect.cc:333
#19 0x0836fa52 in Item_subselect::exec (this=0xab76320) at item_subselect.cc:288
#20 0x0836fd99 in Item_in_subselect::exec (this=0xab76320) at item_subselect.cc:333
#21 0x08373802 in Item_in_subselect::val_bool (this=0xab76320) at item_subselect.cc:929
#22 0x0827ea8c in Item::val_bool_result (this=0xab76320) at item.h:846
#23 0x082e70ac in Item_in_optimizer::val_int (this=0xab77518) at item_cmpfunc.cc:1825
#24 0x0824d19d in Item::val_bool (this=0xab77518) at item.cc:184
#25 0x082dee7a in Item_func_not::val_int (this=0xab763d8) at item_cmpfunc.cc:287
#26 0x08561147 in make_join_select (join=0xaba1f28, cond=0xab763d8) at sql_select.cc:8977
#27 0x085401ff in JOIN::optimize (this=0xaba1f28) at sql_select.cc:1757
#28 0x08548fa2 in mysql_select (thd=0xaadd008, rref_pointer_array=0xaade618, tables=0xaa121a0, wild_num=0, fields=..., conds=0xab763d8, 
    og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748612, result=0xab76fc0, unit=0xaade054, 
    select_lex=0xaade514) at sql_select.cc:3170
#29 0x085a20bb in mysql_explain_union (thd=0xaadd008, unit=0xaade054, result=0xab76fc0) at sql_select.cc:22378
#30 0x08459858 in execute_sqlcom_select (thd=0xaadd008, all_tables=0xaa121a0) at sql_parse.cc:5010
#31 0x08448b0c in mysql_execute_command (thd=0xaadd008) at sql_parse.cc:2295
#32 0x0845dd5a in mysql_parse (thd=0xaadd008, 
    inBuf=0xaa10a88 "EXPLAIN  \nSELECT `col_datetime_key`  \nFROM (  \nSELECT * \nFROM C  ) table1  \nWHERE ( 'd' , 'z' )  NOT  IN (  \nSELECT `col_varchar_key`  , `col_varchar_nokey`  \nFROM CC  )", length=169, found_semicolon=0xb3814910) at sql_parse.cc:6060
#33 0x084439ad in dispatch_command (command=COM_QUERY, thd=0xaadd008, packet=0xaaabeb1 "", packet_length=172) at sql_parse.cc:1091
#34 0x084421c7 in do_command (thd=0xaadd008) at sql_parse.cc:775
#35 0x0843e551 in do_handle_one_connection (thd_arg=0xaadd008) at sql_connect.cc:1173
#36 0x0843e238 in handle_one_connection (arg=0xaadd008) at sql_connect.cc:1113
#37 0x08e7a303 in pfs_spawn_thread (arg=0xab1e5c8) at pfs.cc:1011
#38 0x00ad780e in start_thread (arg=0xb3815770) at pthread_create.c:300
#39 0x001dc8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130

------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 2 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.exp1

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases