Description:
Found when running RQG tests using the WL5004 grammar on mysql-trunk.
Similar to Bug#58219 and Bug#59344.
Stack trace:
#5 0x00007fb27d3a96b0 in abort () at abort.c:92
#6 0x0000000000b202bb in que_thr_stop_for_mysql_no_error (thr=0x7fb2540ad2f8, trx=0x2d99c38)
at /export/home/x/mysql-trunk-rqg2/storage/innobase/que/que0que.c:903
#7 0x00000000009b12f5 in row_search_for_mysql (buf=0x7fb254304150 "\b", mode=3,
prebuilt=0x7fb2540694f8, match_mode=0, direction=0)
at /export/home/x/mysql-trunk-rqg2/storage/innobase/row/row0sel.c:4879
#8 0x000000000096bf3e in ha_innobase::index_read (this=0x7fb254303e90, buf=0x7fb254304150 "\b",
key_ptr=0x0, key_len=0, find_flag=HA_READ_BEFORE_KEY)
at /export/home/x/mysql-trunk-rqg2/storage/innobase/handler/ha_innodb.cc:6112
#9 0x000000000096c9b4 in ha_innobase::index_last (this=0x7fb254303e90, buf=0x7fb254304150 "\b")
at /export/home/x/mysql-trunk-rqg2/storage/innobase/handler/ha_innodb.cc:6440
#10 0x00000000007617d0 in handler::ha_index_last (this=0x7fb254303e90, buf=0x7fb254304150 "\b")
at /export/home/x/mysql-trunk-rqg2/sql/handler.cc:2313
#11 0x000000000084112c in QUICK_GROUP_MIN_MAX_SELECT::reset (this=0x7fb25401bc40)
at /export/home/x/mysql-trunk-rqg2/sql/opt_range.cc:10983
#12 0x0000000000636167 in join_init_read_record (tab=0x7fb25402c3e8)
at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:18262
#13 0x00000000006342d2 in sub_select (join=0x7fb25402b420, join_tab=0x7fb25402c3e8,
end_of_records=false) at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:17363
#14 0x000000000063381b in do_select (join=0x7fb25402b420, fields=0x7fb25402b738, table=0x0,
procedure=0x0) at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:16912
#15 0x0000000000613869 in JOIN::exec (this=0x7fb25402b420)
at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:3331
#16 0x00000000007f76ab in subselect_single_select_engine::exec (this=0x7fb258194db0)
at /export/home/x/mysql-trunk-rqg2/sql/item_subselect.cc:2382
#17 0x00000000007f0eac in Item_subselect::exec (this=0x7fb258194cc0)
at /export/home/x/mysql-trunk-rqg2/sql/item_subselect.cc:298
#18 0x00000000007f233c in Item_singlerow_subselect::val_int (this=0x7fb258194cc0)
at /export/home/x/mysql-trunk-rqg2/sql/item_subselect.cc:723
#19 0x000000000077bd4f in Item::save_in_field (this=0x7fb258194cc0, field=0x7fb254201698,
no_conversions=false) at /export/home/x/mysql-trunk-rqg2/sql/item.cc:5514
#20 0x00000000008515a2 in sp_eval_expr (thd=0x2ddd9b0, result_field=0x7fb254201698,
expr_item_ptr=0x7fb258194e20) at /export/home/x/mysql-trunk-rqg2/sql/sp_head.cc:405
#21 0x000000000085e5b7 in sp_rcontext::set_return_value (this=0x7fb2540394a0, thd=0x2ddd9b0,
return_value_item=0x7fb258194e20) at /export/home/x/mysql-trunk-rqg2/sql/sp_rcontext.cc:166
#22 0x00000000008593be in sp_instr_freturn::exec_core (this=0x7fb258194df0, thd=0x2ddd9b0,
nextp=0x7fb26f1ec138) at /export/home/x/mysql-trunk-rqg2/sql/sp_head.cc:3456
#23 0x0000000000858149 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fb258194e30,
thd=0x2ddd9b0, nextp=0x7fb26f1ec138, open_tables=true, instr=0x7fb258194df0)
at /export/home/x/mysql-trunk-rqg2/sql/sp_head.cc:2959
#24 0x0000000000859376 in sp_instr_freturn::execute (this=0x7fb258194df0, thd=0x2ddd9b0,
nextp=0x7fb26f1ec138) at /export/home/x/mysql-trunk-rqg2/sql/sp_head.cc:3434
#25 0x00000000008542a9 in sp_head::execute (this=0x7fb2580a8c00, thd=0x2ddd9b0,
merge_da_on_success=true) at /export/home/x/mysql-trunk-rqg2/sql/sp_head.cc:1420
#26 0x0000000000855604 in sp_head::execute_function (this=0x7fb2580a8c00, thd=0x2ddd9b0, argp=0x0,
argcount=0, return_value_fld=0x7fb254201698)
at /export/home/x/mysql-trunk-rqg2/sql/sp_head.cc:1941
#27 0x00000000007cd7a0 in Item_func_sp::execute_impl (this=0x2dd5d28, thd=0x2ddd9b0)
at /export/home/x/mysql-trunk-rqg2/sql/item_func.cc:6409
#28 0x00000000007cd53e in Item_func_sp::execute (this=0x2dd5d28)
at /export/home/x/mysql-trunk-rqg2/sql/item_func.cc:6338
#29 0x00000000007d00a6 in Item_func_sp::val_int (this=0x2dd5d28)
at /export/home/x/mysql-trunk-rqg2/sql/item_func.h:1776
#30 0x000000000079049f in Arg_comparator::compare_int_signed (this=0x2dd5f88)
at /export/home/x/mysql-trunk-rqg2/sql/item_cmpfunc.cc:1471
#31 0x000000000079f456 in Arg_comparator::compare (this=0x2dd5f88)
at /export/home/x/mysql-trunk-rqg2/sql/item_cmpfunc.h:88
#32 0x0000000000791cd7 in Item_func_eq::val_int (this=0x2dd5ed8)
at /export/home/x/mysql-trunk-rqg2/sql/item_cmpfunc.cc:2044
#33 0x0000000000976366 in innobase_index_cond (file=0x7fb26838b220)
at /export/home/x/mysql-trunk-rqg2/storage/innobase/handler/ha_innodb.cc:12584
#34 0x00000000009ae84d in row_search_idx_cond_check (mysql_rec=0x7fb26838b4e0 "",
prebuilt=0x7fb2683cdf78, rec=0x7fb2751bc096 "\200", offsets=0x7fb26f1ec7f0)
at /export/home/x/mysql-trunk-rqg2/storage/innobase/row/row0sel.c:3456
#35 0x00000000009b07f5 in row_search_for_mysql (buf=0x7fb26838b4e0 "", mode=2,
prebuilt=0x7fb2683cdf78, match_mode=1, direction=0)
at /export/home/x/mysql-trunk-rqg2/storage/innobase/row/row0sel.c:4501
#36 0x000000000096bf3e in ha_innobase::index_read (this=0x7fb26838b220, buf=0x7fb26838b4e0 "",
key_ptr=0x7fb254202d58 "", key_len=5, find_flag=HA_READ_KEY_EXACT)
at /export/home/x/mysql-trunk-rqg2/storage/innobase/handler/ha_innodb.cc:6112
#37 0x00000000007692f4 in handler::index_read_map (this=0x7fb26838b220, buf=0x7fb26838b4e0 "",
key=0x7fb254202d58 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT)
at /export/home/x/mysql-trunk-rqg2/sql/handler.h:1808
#38 0x0000000000761451 in handler::ha_index_read_map (this=0x7fb26838b220, buf=0x7fb26838b4e0 "",
key=0x7fb254202d58 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT)
at /export/home/x/mysql-trunk-rqg2/sql/handler.cc:2251
#39 0x0000000000635ce3 in join_read_always_key (tab=0x7fb25408d4a8)
at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:18138
#40 0x00000000006342d2 in sub_select (join=0x7fb25c1f3458, join_tab=0x7fb25408d4a8,
end_of_records=false) at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:17363
#41 0x000000000063381b in do_select (join=0x7fb25c1f3458, fields=0x2ddfe00, table=0x0,
procedure=0x0) at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:16912
#42 0x0000000000613869 in JOIN::exec (this=0x7fb25c1f3458)
at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:3331
#43 0x00000000006140e0 in mysql_select (thd=0x2ddd9b0, rref_pointer_array=0x2ddfee0,
tables=0x2dd4970, wild_num=0, fields=..., conds=0x7fb25c1f2ac8, og_num=0, order=0x0,
group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb25c1f3438, unit=
0x2ddf6c0, select_lex=0x2ddfcf8) at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:3554
#44 0x000000000060aa5d in handle_select (thd=0x2ddd9b0, lex=0x2ddf610, result=0x7fb25c1f3438,
setup_tables_done_option=0) at /export/home/x/mysql-trunk-rqg2/sql/sql_select.cc:323
#45 0x00000000005eadad in execute_sqlcom_select (thd=0x2ddd9b0, all_tables=0x2dd4970)
at /export/home/x/mysql-trunk-rqg2/sql/sql_parse.cc:4513
#46 0x00000000005e3911 in mysql_execute_command (thd=0x2ddd9b0)
at /export/home/x/mysql-trunk-rqg2/sql/sql_parse.cc:2096
#47 0x00000000005ecfa8 in mysql_parse (thd=0x2ddd9b0,
rawbuf=0x2dd4410 "SELECT `col_int` , `col_int_key` , `pk` FROM testdb_S . t1_base2_S AS A NATURAL JOIN testdb_N . t1_base2_N B WHERE testdb_S . f1_1_S () = 0 AND `pk` = 8", length=158,
parser_state=0x7fb26f1ef080) at /export/home/x/mysql-trunk-rqg2/sql/sql_parse.cc:5550
How to repeat:
See similarly found bugs Bug#58219 and Bug#59344
Only seen this once so far, so likelihood is probably very low.
I have a core file.
