Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL)
-
None
Description
CREATE TABLE t1 (id char(10) ) DEFAULT CHARSET=utf8; |
insert into t1 values (1),(2); |
|
prepare stmt from "SELECT group_concat(@a := NULL, 1) FROM t1 WHERE @a := id GROUP BY (@a := 0) ;"; |
|
execute stmt; |
execute stmt; |
mariadbd: /11.6/src/sql/item_sum.cc:4310: virtual bool Item_func_group_concat::fix_fields(THD*, Item**): Assertion `thd->active_stmt_arena_to_use()-> is_stmt_prepare_or_first_stmt_execute() || thd->active_stmt_arena_to_use()-> is_conventional() || thd->active_stmt_arena_to_use()->state == Query_arena::STMT_SP_QUERY_ARGUMENTS' failed.
|
240913 18:09:43 [ERROR] mysqld got signal 6 ;
|
|
Server version: 11.6.2-MariaDB-debug-log source revision: 19cea738342737503f47cfe6ff67d5248b0a0961
|
|
sql/item_sum.cc:4316(Item_func_group_concat::fix_fields(THD*, Item**))[0x556ea8f021a7]
|
sql/item.h:1167(Item::fix_fields_if_needed(THD*, Item**))[0x556ea7f72621]
|
sql/item.h:1176(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x556ea7f7265b]
|
sql/sql_base.cc:8096(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool))[0x556ea809f99c]
|
sql/sql_select.cc:1567(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x556ea8341aaa]
|
sql/sql_select.cc:5320(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x556ea836987c]
|
sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x556ea833814c]
|
sql/sql_parse.cc:6154(execute_sqlcom_select(THD*, TABLE_LIST*))[0x556ea8256ada]
|
sql/sql_parse.cc:3954(mysql_execute_command(THD*, bool))[0x556ea82468e3]
|
sql/sql_prepare.cc:5050(Prepared_statement::execute(String*, bool))[0x556ea82f8247]
|
sql/sql_prepare.cc:4427(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x556ea82f2fec]
|
sql/sql_prepare.cc:3447(mysql_sql_stmt_execute(THD*))[0x556ea82ec120]
|
sql/sql_parse.cc:3971(mysql_execute_command(THD*, bool))[0x556ea8246928]
|
sql/sql_parse.cc:7876(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556ea8261ee0]
|
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556ea8238839]
|
sql/sql_parse.cc:1405(do_command(THD*, bool))[0x556ea823555a]
|
sql/sql_connect.cc:1448(do_handle_one_connection(CONNECT*, bool))[0x556ea8731816]
|
sql/sql_connect.cc:1352(handle_one_connection)[0x556ea8731173]
|
perfschema/pfs.cc:2200(pfs_spawn_thread)[0x556ea93e9e4c]
|
nptl/pthread_create.c:478(start_thread)[0x7f7cf3baf609]
|
|
Query (0x629000109340): SELECT group_concat(@a := NULL, 1) FROM t1 WHERE @a := id GROUP BY (@a := 0)
|