Details
-
Bug
-
Status: In Review (View Workflow)
-
Critical
-
Resolution: Unresolved
-
12.2
-
None
-
Q4/2025 Server Maintenance
Description
--DELIMITER //
|
CREATE PROCEDURE p0 (x INT DEFAULT func()) |
BEGIN |
SELECT x; |
END; |
//
|
--DELIMITER ;
|
SET SESSION max_session_mem_used=8192; |
--ERROR ER_OPTION_PREVENTS_STATEMENT
|
CALL p0();
|
SET @@max_session_mem_used=DEFAULT; |
--ERROR ER_SP_DOES_NOT_EXIST
|
CALL p0();
|
SELECT * FROM information_schema.PARAMETERS; |
Leads to
MDEV-37054 CS 12.2.0 5f880b3d4a8561defb2c7177773b37e1ebf7312e (Debug, Clang) Build 18/08/2025 |
Core was generated by `/test/mtest/MDEV-27305/MD180825-mariadb-12.2.0-linux-x86_64-dbg/bin/mariadbd --'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x000056ce58c9674a in get_param_default_value (item=0x789e900250c0, default_value=0x78bd78323650)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:1938
|
 |
[Current thread is 1 (LWP 2515402)]
|
(gdb) bt
|
#0 0x000056ce58c9674a in get_param_default_value (item=0x789e900250c0, default_value=0x78bd78323650)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:1938
|
#1 0x000056ce58c95dcf in store_schema_params (thd=0x789e90000d58, table=0x789e90057ac0, proc_table=0x789e900356d8, lookup=0x78bd783246d8, full_access=true, sp_user=0x78bd78325b50 "root@localhost")at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:7115
|
#2 0x000056ce58c97c13 in fill_schema_proc (thd=0x789e90000d58, tables=0x789e9001a5c8, cond=0x0)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:7371
|
#3 0x000056ce58c9ccfa in get_schema_tables_result (join=0x789e9001bf10, executed_place=PROCESSED_BY_JOIN_EXEC)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:9780
|
#4 0x000056ce58c360b8 in JOIN::exec_inner (this=0x789e9001bf10)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_select.cc:5047
|
#5 0x000056ce58c3556e in JOIN::exec (this=0x789e9001bf10)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_select.cc:4874
|
#6 0x000056ce58c100dd in mysql_select (thd=0x789e90000d58, tables=0x789e9001a5c8, fields=@0x789e9001a1f0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x789e9001a538, last = 0x789e9001df80, elements = 17}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2701396736, result=0x789e9001bee8, unit=0x789e90005158, select_lex=0x789e90019f38)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_select.cc:5402
|
#7 0x000056ce58c0fb65 in handle_select (thd=0x789e90000d58, lex=0x789e90005078, result=0x789e9001bee8, setup_tables_done_option=0)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_select.cc:634
|
#8 0x000056ce58bb76a1 in execute_sqlcom_select (thd=0x789e90000d58, all_tables=0x789e9001a5c8)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:6167
|
#9 0x000056ce58bac42e in mysql_execute_command (thd=0x789e90000d58, is_called_from_prepared_stmt=false)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:3950
|
#10 0x000056ce58ba46f4 in mysql_parse (thd=0x789e90000d58, rawbuf=0x789e90019e80 "SELECT * FROM information_schema.PARAMETERS", length=43, parser_state=0x78bd78328a10)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:7883
|
#11 0x000056ce58ba1ac8 in dispatch_command (command=COM_QUERY, thd=0x789e90000d58, packet=0x789e9000b1f9 "SELECT * FROM information_schema.PARAMETERS", packet_length=43, blocking=true)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:1878
|
#12 0x000056ce58ba52a3 in do_command (thd=0x789e90000d58, blocking=true)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:1417
|
#13 0x000056ce58d92869 in do_handle_one_connection (connect=0x56ce80a49498, put_in_cache=true)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_connect.cc:1414
|
#14 0x000056ce58d9260e in handle_one_connection (arg=0x56ce80a5a548)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_connect.cc:1326
|
#15 0x000078bd7b49caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#16 0x000078bd7b529c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Attachments
Issue Links
- is caused by
-
MDEV-37054 implement INFORMATION_SCHEMA.PARAMETERS.PARAMETER_DEFAULT column
-
- In Testing
-