Server crashes in Time_and_counter_tracker::incr_loops / subselect_single_select_engine::exec

#3  <signal handler called>

#4  0x00007f37ead64668 in Time_and_counter_tracker::incr_loops (this=0x80) at /data/src/10.2/sql/sql_analyze_stmt.h:97

#5  0x00007f37ead2a6f3 in JOIN::exec (this=0x7f37df9252a8) at /data/src/10.2/sql/sql_select.cc:3163

#6  0x00007f37eaff3931 in subselect_single_select_engine::exec (this=0x7f37df868400) at /data/src/10.2/sql/item_subselect.cc:3788

#7  0x00007f37eafe9d58 in Item_subselect::exec (this=0x7f37df868270) at /data/src/10.2/sql/item_subselect.cc:711

#8  0x00007f37eafec618 in Item_exists_subselect::val_int (this=0x7f37df868270) at /data/src/10.2/sql/item_subselect.cc:1581

#9  0x00007f37eaf6f417 in Arg_comparator::compare_int_signed (this=0x7f37df92aa08) at /data/src/10.2/sql/item_cmpfunc.cc:970

#10 0x00007f37eaf8133c in Arg_comparator::compare (this=0x7f37df92aa08) at /data/src/10.2/sql/item_cmpfunc.h:88

#11 0x00007f37eaf71605 in Item_func_eq::val_int (this=0x7f37df92a948) at /data/src/10.2/sql/item_cmpfunc.cc:1742

#12 0x00007f37eaf7ee96 in Item_equal::add_const (this=0x7f37df924e90, thd=0x7f37df816070, c=0x7f37df8667b0) at /data/src/10.2/sql/item_cmpfunc.cc:6125

#13 0x00007f37eaf7f3bd in Item_equal::update_const (this=0x7f37df924e90, thd=0x7f37df816070) at /data/src/10.2/sql/item_cmpfunc.cc:6383

#14 0x00007f37ead45614 in update_const_equal_items (thd=0x7f37df816070, cond=0x7f37df924e90, tab=0x7f37df929190, const_key=true) at /data/src/10.2/sql/sql_select.cc:13904

#15 0x00007f37ead51062 in join_read_const_table (thd=0x7f37df816070, tab=0x7f37df929190, pos=0x7f37df929760) at /data/src/10.2/sql/sql_select.cc:18819

#16 0x00007f37ead2c95c in make_join_statistics (join=0x7f37df868910, tables_list=..., keyuse_array=0x7f37df868bf0) at /data/src/10.2/sql/sql_select.cc:3875

#17 0x00007f37ead24678 in JOIN::optimize_inner (this=0x7f37df868910) at /data/src/10.2/sql/sql_select.cc:1437

#18 0x00007f37ead23344 in JOIN::optimize (this=0x7f37df868910) at /data/src/10.2/sql/sql_select.cc:1076

#19 0x00007f37ead2b798 in mysql_select (thd=0x7f37df816070, tables=0x7f37df865598, wild_num=1, fields=..., conds=0x7f37df8685b0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f37df8688f0, unit=0x7f37df819b18, select_lex=0x7f37df81a250) at /data/src/10.2/sql/sql_select.cc:3535

#20 0x00007f37ead20ea1 in handle_select (thd=0x7f37df816070, lex=0x7f37df819a50, result=0x7f37df8688f0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373

#21 0x00007f37eacf0938 in execute_sqlcom_select (thd=0x7f37df816070, all_tables=0x7f37df865598) at /data/src/10.2/sql/sql_parse.cc:6345

#22 0x00007f37eace676e in mysql_execute_command (thd=0x7f37df816070) at /data/src/10.2/sql/sql_parse.cc:3376

#23 0x00007f37eacf40d7 in mysql_parse (thd=0x7f37df816070, rawbuf=0x7f37df864088 "SELECT * FROM ( SELECT DISTINCT * FROM t1 ) AS sq\nWHERE i IN ( SELECT j FROM t2 WHERE i IN ( EXISTS ( SELECT j FROM t2 ) ) )", length=124, parser_state=0x7f37ebc42dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7774

#24 0x00007f37eace24c5 in dispatch_command (command=COM_QUERY, thd=0x7f37df816070, packet=0x7f37df858071 "SELECT * FROM ( SELECT DISTINCT * FROM t1 ) AS sq\nWHERE i IN ( SELECT j FROM t2 WHERE i IN ( EXISTS ( SELECT j FROM t2 ) ) )", packet_length=124, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1805

#25 0x00007f37eace0ef6 in do_command (thd=0x7f37df816070) at /data/src/10.2/sql/sql_parse.cc:1365

#26 0x00007f37eae1c7ba in do_handle_one_connection (connect=0x7f37e7c6d410) at /data/src/10.2/sql/sql_connect.cc:1354

#27 0x00007f37eae1c547 in handle_one_connection (arg=0x7f37e7c6d410) at /data/src/10.2/sql/sql_connect.cc:1260

#28 0x00007f37eb12ab26 in pfs_spawn_thread (arg=0x7f37e7c519f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#29 0x00007f37ea3650a4 in start_thread (arg=0x7f37ebc44300) at pthread_create.c:309

#30 0x00007f37e851d87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

CREATE TABLE t1 (i INT) engine=MyISAM;

INSERT INTO t1 VALUES (2),(5);

CREATE TABLE t2 (j INT) engine=MyISAM;

INSERT INTO t2 VALUES (8);

SELECT * FROM ( SELECT DISTINCT * FROM t1 ) AS sq

WHERE i IN ( SELECT j FROM t2 WHERE i IN ( EXISTS ( SELECT j FROM t2 ) ) );