Details
Description
test, derived from MDEV-30766:
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
|
Attachments
Issue Links
- relates to
-
MDEV-22368 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)))
- Confirmed
-
MDEV-30766 Issue with NOT IN (subquery that violates "FULL GROUP BY")
- Closed