Assertion `field_max_length <= m_return_field_def.length || m_return_field_def.type_handler()->cmp_type() == INT_RESULT || (_current_thd()->stmt_arena->is_stmt_execute() && m_return_field_def.length == 8 && (m_return_field_def.pack_flag & (1024U|2048U)))'

CREATE TABLE playback ( session_id int PRIMARY KEY, customer_id int, start_time int, end_time int);

insert into playback values (-1, 0, 1, 1),(0, 0, 1, 1);

CREATE TABLE ads ( ad_id int PRIMARY KEY, customer_id int, TIMESTAMP int);

insert into ads values (0, 0, 1),(1, 0, 1);

delimiter //;

create aggregate function any_value (x longblob) returns longblob

begin

 loop

  fetch group next row;

  return x;

 end loop; 

end //

delimiter ;//

select any_value(session_id) from playback join ads on playback.customer_id=ads.customer_id group by playback.customer_id;

Version: '10.3.38-MariaDB-debug-log'

mysqld: /10.3/src/sql/sp_head.cc:934: Field* sp_head::create_result_field(uint, const LEX_CSTRING*, TABLE*) const: Assertion `field_max_length <= m_return_field_def.length || m_return_field_def.type_handler()->cmp_type() == INT_RESULT || (_current_thd()->stmt_arena->is_stmt_execute() && m_return_field_def.length == 8 && (m_return_field_def.pack_flag & (1024U|2048U)))' failed.

230302 12:12:42 [ERROR] mysqld got signal 6 ;

Server version: 10.3.38-MariaDB-debug-log source revision: 2743a510a156456fe57429032bf41c0da0f11198

mysys/stacktrace.c:174(my_print_stacktrace)[0x55cff7fb0d5b]

sql/signal_handler.cc:233(handle_fatal_signal)[0x55cff6c06c37]

sigaction.c:0(__restore_rt)[0x7f803d9c5420]

sql/sp_head.cc:941(sp_head::create_result_field(unsigned int, st_mysql_const_lex_string const*, TABLE*) const)[0x55cff6258710]

sql/item.cc:3133(Item_sp::init_result_field(THD*, unsigned int, unsigned int, bool*, st_mysql_const_lex_string*))[0x55cff6c6872c]

sql/item_sum.cc:1469(Item_sum_sp::copy_or_same(THD*))[0x55cff6e6bf32]

sql/item_sum.cc:527(Item_sum::get_tmp_table_item(THD*))[0x55cff6e62805]

sql/sql_select.cc:24920(change_refs_to_tmp_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, List<Item>&, unsigned int, List<Item>&))[0x55cff65e88ec]

sql/sql_select.cc:3108(JOIN::make_aggr_tables_info())[0x55cff6547bad]

sql/sql_select.cc:2720(JOIN::optimize_stage2())[0x55cff6543000]

sql/sql_select.cc:2026(JOIN::optimize_inner())[0x55cff653be54]

sql/sql_select.cc:1542(JOIN::optimize())[0x55cff6537086]

sql/sql_select.cc:4379(mysql_select(THD*, 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*))[0x55cff655483b]

sql/sql_select.cc:372(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55cff652aa1f]

sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55cff649b708]

sql/sql_parse.cc:3871(mysql_execute_command(THD*))[0x55cff648972e]

sql/sql_parse.cc:7855(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55cff64a53ea]

sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55cff647c3a7]

sql/sql_parse.cc:1398(do_command(THD*))[0x55cff6478ec6]

sql/sql_connect.cc:1404(do_handle_one_connection(CONNECT*))[0x55cff684f62d]

sql/sql_connect.cc:1310(handle_one_connection)[0x55cff684eee7]

perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55cff7e86201]

nptl/pthread_create.c:478(start_thread)[0x7f803d9b9609]

addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530ea0)

/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f803d8de133]

Query (0x62b000000290): select any_value(session_id) from playback join ads on playback.customer_id=ads.customer_id group by playback.customer_id