not repeatable in maria-5.3

mysqld: field.cc:7085: virtual String* Field_varstring::val_str(String*, String*): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.

backtrace:

#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
#9 0x0825de64 in Field_varstring::val_str (this=0xae758c90, val_buffer=0xae8fd9d4, val_ptr=0xae8fd9d4) at field.cc:7085
#10 0x081d5cc8 in Field::val_str (this=0xae758c90, str=0xae8fd9d4) at field.h:207
#11 0x0840502a in field_conv (to=0xae767da8, from=0xae758c90) at field_conv.cc:829
#12 0x081cc396 in save_field_in_field (from=0xae758c90, null_value=0xae7564a8, to=0xae767da8, no_conversions=true) at item.cc:5228
#13 0x081cc404 in Item_field::save_org_in_field (this=0xae756468, to=0xae767da8) at item.cc:5240
#14 0x081d6dd5 in Item::save_val (this=0xae756468, to=0xae767da8) at item.h:758
#15 0x083356b3 in store_key_item::copy_inner (this=0xae767d88) at sql_select.h:1213
#16 0x08243b64 in store_key::copy (this=0xae767d88) at sql_select.h:1119
#17 0x0832c4a6 in cp_buffer_from_ref (thd=0xb152c58, table=0xae79d4e8, ref=0xae767c28) at sql_select.cc:16764
#18 0x0832c3f9 in cmp_buffer_with_ref (thd=0xb152c58, table=0xae79d4e8, tab_ref=0xae767c28) at sql_select.cc:16746
#19 0x083256d7 in join_read_key2 (thd=0xb152c58, tab=0x0, table=0xae79d4e8, table_ref=0xae767c28) at sql_select.cc:14064
#20 0x08498b69 in Expression_cache_tmptable::check_value (this=0xae767ba0, value=0xae8fdbf4) at sql_expression_cache.cc:193
#21 0x081d0046 in Item_cache_wrapper::check_cache (this=0xae767ab8) at item.cc:6768
#22 0x081d088e in Item_cache_wrapper::val_bool (this=0xae767ab8) at item.cc:6941
#23 0x0820a903 in Item_cond_and::val_int (this=0xae766338) at item_cmpfunc.cc:4671
#24 0x082e1e9e in SQL_SELECT::skip_record (this=0xae7663e8, thd=0xb152c58) at opt_range.h:916
#25 0x083c8a02 in find_all_keys (param=0xae8fdf94, select=0xae7663e8, sort_keys=0xae759c78, buffpek_pointers=0xae8fddcc, tempfile=0xae8fdeb0, indexfile=0x0)
at filesort.cc:632
#26 0x083c76fc in filesort (thd=0xb152c58, table=0xae757fb0, sortorder=0xae767c88, s_length=1, select=0xae7663e8, max_rows=18446744073709551615,
sort_positions=false, examined_rows=0xae8fe100) at filesort.cc:240
#27 0x0832b318 in create_sort_index (thd=0xb152c58, join=0xae783368, order=0xae756740, filesort_limit=18446744073709551615,
select_limit=18446744073709551615, is_order_by=false) at sql_select.cc:16287
#28 0x0830b066 in JOIN::exec (this=0xae783368) at sql_select.cc:2393
#29 0x0830bad1 in mysql_select (thd=0xb152c58, rref_pointer_array=0xb1546f4, tables=0xae72dcc8, wild_num=0, fields=..., conds=0xae7565b8, og_num=1,
order=0xae756740, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xae757350, unit=0xb154354, select_lex=0xb1545f0)
at sql_select.cc:2667
#30 0x0830452d in handle_select (thd=0xb152c58, lex=0xb1542f8, result=0xae757350, setup_tables_done_option=0) at sql_select.cc:283
#31 0x082a1fec in execute_sqlcom_select (thd=0xb152c58, all_tables=0xae72dcc8) at sql_parse.cc:5070
#32 0x08298ffb in mysql_execute_command (thd=0xb152c58) at sql_parse.cc:2234
#33 0x082a4584 in mysql_parse (thd=0xb152c58,
rawbuf=0xae72d9f8 "SELECT alias2.f2 AS field1\nFROM t1 AS alias1 JOIN ( SELECT * FROM t2 ) AS alias2 ON alias2.f3 = alias1.f1\nWHERE (\nSELECT t2.f2\nFROM t2 JOIN t1 ON t1.f1\nWHERE t1.f1 AND alias2.f10\n)\nORDER BY field1", length=196, found_semicolon=0xae8ff228) at sql_parse.cc:6077
#34 0x08296c93 in dispatch_command (command=COM_QUERY, thd=0xb152c58,
packet=0xb16ad49 "SELECT alias2.f2 AS field1\nFROM t1 AS alias1 JOIN ( SELECT * FROM t2 ) AS alias2 ON alias2.f3 = alias1.f1\nWHERE (\nSELECT t2.f2\nFROM t2 JOIN t1 ON t1.f1\nWHERE t1.f1 AND alias2.f10\n)\nORDER BY field1 ", packet_length=197) at sql_parse.cc:1210
#35 0x08296140 in do_command (thd=0xb152c58) at sql_parse.cc:903
#36 0x0829321e in handle_one_connection (arg=0xb152c58) at sql_connect.cc:1154
#37 0x00821919 in start_thread () from /lib/libpthread.so.0
#38 0x0076acce in clone () from /lib/libc.so.6

bzr version-info
revision-id: <email address hidden>
date: 2011-02-03 17:00:28 +0200
build-date: 2011-02-08 08:55:47 +0200
revno: 2883
branch-nick: maria-5.3-mwl89

test case:

CREATE TABLE t1 ( f1 int(11), PRIMARY KEY (f1)) ;
INSERT INTO t1 VALUES (28),(29);

CREATE TABLE t2 ( f2 int(11), f3 int(11), f10 varchar(1)) ;
INSERT INTO t2 VALUES (NULL,6,'f'),(4,2,'d');

SELECT alias2.f2 AS field1
FROM t1 AS alias1 JOIN ( SELECT * FROM t2 ) AS alias2 ON alias2.f3 = alias1.f1
WHERE (
SELECT t2.f2
FROM t2 JOIN t1 ON t1.f1
WHERE t1.f1 AND alias2.f10
)
ORDER BY field1 ;

explain:

id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 Using where; Using filesort
1 PRIMARY alias1 eq_ref PRIMARY PRIMARY 4 alias2.f3 1 Using index
3 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2
3 DEPENDENT SUBQUERY t1 index NULL PRIMARY 4 NULL 2 Using where; Using index; Using join buffer (flat, BNL join)
2 DERIVED t2 ALL NULL NULL NULL NULL 2

also reproducible with join_cache_level=0 and with subquery_cache=off