Assertion `!has_value' failed in Item_sum_any_value::update_field

--source include/have_innodb.inc

--source include/have_sequence.inc

create table t (id int primary key, a int, b int, key(b)) engine=innodb;

insert into t values (1,5,1),(2,50,1),(3,20,1),(4,40,2),(5,30,2),(6,35,2);

analyze table t;

explain select b, any_value(a) from t group by b;

prepare s from 'select b, any_value(a) from t group by b';

execute s;

execute s;

insert into t select seq+10, seq%97, seq%3 from seq_1_to_3000;

analyze table t;

explain select b, any_value(a) from t group by b;

execute s;

execute s;

#4  0x00005cb3f108af02 in handle_fatal_signal (sig=6) at /13.2/sql/signal_handler.cc:300

#5  <signal handler called>

#6  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44

#7  __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78

#8  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89

#9  0x00007c449e84527e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26

#10 0x00007c449e8288ff in __GI_abort () at ./stdlib/abort.c:79

#11 0x00007c449e82881b in __assert_fail_base (fmt=0x7c449e9d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5cb3f038b400 "!has_value", file=file@entry=0x5cb3f0385e20 "/13.2/sql/item_sum.cc", line=line@entry=2758, function=function@entry=0x5cb3f038b440 "virtual void Item_sum_any_value::update_field()") at ./assert/assert.c:96

#12 0x00007c449e83b517 in __assert_fail (assertion=0x5cb3f038b400 "!has_value", file=0x5cb3f0385e20 "/13.2/sql/item_sum.cc", line=2758, function=0x5cb3f038b440 "virtual void Item_sum_any_value::update_field()") at ./assert/assert.c:105

#13 0x00005cb3f13923e6 in Item_sum_any_value::update_field (this=0x52d0003eac70) at /13.2/sql/item_sum.cc:2758

#14 0x00005cb3f1a0094a in update_tmptable_sum_func (func_ptr=0x52d000173168, tmp_table=tmp_table@entry=0x52d000406448) at /13.2/sql/sql_select.cc:31336

#15 0x00005cb3f1ac98d9 in end_update (join=0x52d000172650, join_tab=0x52d0001746c8, end_of_records=<optimized out>) at /13.2/sql/sql_select.cc:27461

#16 0x00005cb3f1a5d3f1 in AGGR_OP::put_record (this=this@entry=0x52d000175710, end_of_records=end_of_records@entry=false) at /13.2/sql/sql_select.cc:34918

#17 0x00005cb3f1a5de94 in AGGR_OP::put_record (this=0x52d000175710) at /13.2/sql/sql_select.h:1456

#18 sub_select_postjoin_aggr (join=0x52d000172650, join_tab=0x52d0001746c8, end_of_records=<optimized out>) at /13.2/sql/sql_select.cc:25316

#19 0x00005cb3f1a13815 in evaluate_join_record (join=join@entry=0x52d000172650, join_tab=join_tab@entry=0x52d000174250, error=error@entry=0) at /13.2/sql/sql_select.cc:25865

#20 0x00005cb3f1a2cb83 in sub_select (join=0x52d000172650, join_tab=0x52d000174250, end_of_records=<optimized out>) at /13.2/sql/sql_select.cc:25669

#21 0x00005cb3f1a7153b in do_select (join=join@entry=0x52d000172650, procedure=<optimized out>) at /13.2/sql/sql_select.cc:25143

#22 0x00005cb3f1ade3ab in JOIN::exec_inner (this=this@entry=0x52d000172650) at /13.2/sql/sql_select.cc:5172

#23 0x00005cb3f1ade70a in JOIN::exec (this=this@entry=0x52d000172650) at /13.2/sql/sql_select.cc:4960

#24 0x00005cb3f1ada01c in mysql_select (thd=thd@entry=0x52c0001a0220, tables=<optimized out>, fields=..., conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=<optimized out>, having=<optimized out>, proc_param=<optimized out>, select_options=<optimized out>, result=<optimized out>, unit=<optimized out>, select_lex=<optimized out>) at /13.2/sql/sql_select.cc:5486

#25 0x00005cb3f1ada828 in handle_select (thd=thd@entry=0x52c0001a0220, lex=lex@entry=0x52d0003e8460, result=result@entry=0x52d0003ec0c8, setup_tables_done_option=setup_tables_done_option@entry=0) at /13.2/sql/sql_select.cc:652

#26 0x00005cb3f1912e28 in execute_sqlcom_select (thd=thd@entry=0x52c0001a0220, all_tables=<optimized out>) at /13.2/sql/sql_parse.cc:6273

#27 0x00005cb3f1932ff7 in mysql_execute_command (thd=0x52c0001a0220, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=true) at /13.2/sql/sql_parse.cc:4044

#28 0x00005cb3f19bf4b8 in Prepared_statement::execute (this=this@entry=0x51a000033ca0, expanded_query=expanded_query@entry=(String *) 0x744488ca8ee0 _binary ..., open_cursor=open_cursor@entry=false, result_arg=result_arg@entry=0x51a000033df0, cursor_arg=cursor_arg@entry=0x51a000033e60) at /13.2/sql/sql_prepare.cc:5597

#29 0x00005cb3f19c5c14 in Prepared_statement::execute_loop (this=this@entry=0x51a000033ca0, expanded_query=expanded_query@entry=(String *) 0x744488ca8ee0 _binary ..., open_cursor=open_cursor@entry=false, result_arg=result_arg@entry=0x51a000033df0, cursor_arg=cursor_arg@entry=0x51a000033e60, instrs_set_placeholder=..., packet=<optimized out>, packet_end=<optimized out>) at /13.2/sql/sql_prepare.cc:4902

#30 0x00005cb3f19c6be6 in mysql_sql_stmt_execute (thd=thd@entry=0x52c0001a0220, name=..., cmd=cmd@entry=0x5cb3f0514180 "EXECUTE", open_dynamic_cursor=open_dynamic_cursor@entry=false, result_arg=result_arg@entry=0x0, cursor_arg=cursor_arg@entry=0x0) at /13.2/sql/sql_prepare.cc:3795

#31 0x00005cb3f19c73bb in mysql_sql_stmt_execute (thd=thd@entry=0x52c0001a0220) at /13.2/sql/sql_prepare.cc:3818

#32 0x00005cb3f1933084 in mysql_execute_command (thd=thd@entry=0x52c0001a0220, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /13.2/sql/sql_parse.cc:4060

#33 0x00005cb3f193f8e7 in mysql_parse (thd=thd@entry=0x52c0001a0220, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7444890841b0) at /13.2/sql/sql_parse.cc:8020

#34 0x00005cb3f19434c6 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x52c0001a0220, packet=packet@entry=0x529000271221 "", packet_length=packet_length@entry=9, blocking=blocking@entry=true) at /13.2/sql/sql_parse.cc:1903

#35 0x00005cb3f1947c9a in do_command (thd=thd@entry=0x52c0001a0220, blocking=blocking@entry=true) at /13.2/sql/sql_parse.cc:1437

#36 0x00005cb3f1dc5ff5 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x50b000006150, put_in_cache=put_in_cache@entry=true) at /13.2/sql/sql_connect.cc:1529

#37 0x00005cb3f1dc63fb in handle_one_connection (arg=arg@entry=0x50b000006150) at /13.2/sql/sql_connect.cc:1441

#38 0x00007c449f85ea42 in asan_thread_start (arg=0x744496c1a000) at ../../../../src/libsanitizer/asan/asan_interceptors.cpp:234

#39 0x00007c449e89cb84 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447

#40 0x00007c449e929ecc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

--source include/have_innodb.inc

--source include/have_sequence.inc

create table t (id int primary key, a int, b int, key(b)) engine=innodb;

insert into t values (1,5,1),(2,50,1),(3,20,1),(4,40,2),(5,30,2),(6,35,2);

analyze table t;

delimiter |;

create procedure p()

  select b, any_value(a) from t group by b|

delimiter ;|

call p();

insert into t select seq+10, seq%97, seq%3 from seq_1_to_3000;

analyze table t;

call p();

call p();

drop procedure p;

drop table t;