Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-41412

Assertion `name' failed in THD::push_warning_truncated_value_for_field upon invalid value for a stored function RETURNS INET6

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      SET SQL_MODE='';
      CREATE FUNCTION f1() RETURNS INET6 RETURN 1;
      DO f1();
      

      Leads to:

      CS 11.4.13 b6398296aeeeb253bdb3d1dd1620d2bb03836bf7 (Debug, Clang 18.1.3-11) Build 06/10/2026

      mariadbd: /test/11.4_dbg/sql/sql_class.h:5321: void THD::push_warning_truncated_value_for_field(Sql_condition::enum_warning_level, const char *, const char *, const char *, const char *, const char *): Assertion `name' failed.
      

      CS 11.4.13 b6398296aeeeb253bdb3d1dd1620d2bb03836bf7 (Debug, Clang 18.1.3-11) Build 06/10/2026

      Core was generated by `/test/MD061026-mariadb-11.4.13-linux-x86_64-dbg/bin/mariadbd --no-defaults --lo'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 1025429)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x000070938a44527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000070938a4288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000070938a42881b in __assert_fail_base (fmt=0x70938a5d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x62cb90367009 "name", file=file@entry=0x62cb90279dfb "/test/11.4_dbg/sql/sql_class.h", line=line@entry=5321, function=function@entry=0x62cb902bd8ec "void THD::push_warning_truncated_value_for_field(Sql_condition::enum_warning_level, const char *, const char *, const char *, const char *, const char *)") at ./assert/assert.c:96
      #6  0x000070938a43b517 in __assert_fail (assertion=0x62cb90367009 "name", file=0x62cb90279dfb "/test/11.4_dbg/sql/sql_class.h", line=5321, function=0x62cb902bd8ec "void THD::push_warning_truncated_value_for_field(Sql_condition::enum_warning_level, const char *, const char *, const char *, const char *, const char *)") at ./assert/assert.c:105
      #7  0x000062cb8f40befb in THD::push_warning_truncated_value_for_field (this=0x6892cc000d58, level=Sql_state_errno_level::WARN_LEVEL_WARN, type_str=0x62cb9040c183 "inet6", val=0x70935c1a6148 "1", db_name=0x0, table_name=0x62cb90409879 "", name=0x0)at /test/11.4_dbg/sql/sql_class.h:5321
      #8  0x000062cb9020eecb in Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::store_warning (this=0x6892cc01acf0, str=@0x70935c1a6140: {<ErrBuff> = {err_buffer = "1", '\000' <repeats 510 times>}, _vptr$ErrConv = 0x62cb90aad528 <vtable for ErrConvInteger+16>}, level=Sql_state_errno_level::WARN_LEVEL_WARN)at /test/11.4_dbg/sql/sql_type_fixedbin.h:332
      #9  0x000062cb9020ed26 in Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::set_min_value_with_warn (this=0x6892cc01acf0, str=@0x70935c1a6140: {<ErrBuff> = {err_buffer = "1", '\000' <repeats 510 times>}, _vptr$ErrConv = 0x62cb90aad528 <vtable for ErrConvInteger+16>})at /test/11.4_dbg/sql/sql_type_fixedbin.h:344
      #10 0x000062cb9020d112 in Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::store (this=0x6892cc01acf0, nr=1, unsigned_flag=false)at /test/11.4_dbg/sql/sql_type_fixedbin.h:532
      #11 0x000062cb8f6b45e1 in save_int_value_in_field (field=0x6892cc01acf0, nr=1, null_value=false, unsigned_flag=false) at /test/11.4_dbg/sql/item.cc:7358
      #12 0x000062cb8f6b4571 in Item_int::save_in_field (this=0x6892cc024fa0, field=0x6892cc01acf0, no_conversions=false)at /test/11.4_dbg/sql/item.cc:7364
      #13 0x000062cb8f63809f in Field::sp_prepare_and_store_item (this=0x6892cc01acf0, thd=0x6892cc000d58, value=0x6892cc0250a8)at /test/11.4_dbg/sql/field.cc:1517
      #14 0x000062cb8f152d08 in THD::sp_eval_expr (this=0x6892cc000d58, result_field=0x6892cc01acf0, expr_item_ptr=0x6892cc0250a8)at /test/11.4_dbg/sql/sp_head.cc:448
      #15 0x000062cb8f16a3ce in sp_rcontext::set_return_value (this=0x6892cc048c60, thd=0x6892cc000d58, return_value_item=0x6892cc0250a8)at /test/11.4_dbg/sql/sp_rcontext.cc:442
      #16 0x000062cb8f51f06a in sp_instr_freturn::exec_core (this=0x6892cc025020, thd=0x6892cc000d58, nextp=0x70935c1a6968)at /test/11.4_dbg/sql/sp_instr.cc:1613
      #17 0x000062cb8f51b1c6 in sp_lex_keeper::reset_lex_and_exec_core (this=0x6892cc025058, thd=0x6892cc000d58, nextp=0x70935c1a6968, open_tables=true, instr=0x6892cc025020, rerun_the_same_instr=false)at /test/11.4_dbg/sql/sp_instr.cc:333
      #18 0x000062cb8f51b92d in sp_lex_keeper::validate_lex_and_exec_core (this=0x6892cc025058, thd=0x6892cc000d58, nextp=0x70935c1a6968, open_tables=true, instr=0x6892cc025020)at /test/11.4_dbg/sql/sp_instr.cc:512
      #19 0x000062cb8f51efd1 in sp_instr_freturn::execute (this=0x6892cc025020, thd=0x6892cc000d58, nextp=0x70935c1a6968)at /test/11.4_dbg/sql/sp_instr.cc:1570
      #20 0x000062cb8f155bc9 in sp_head::execute (this=0x6892cc024080, thd=0x6892cc000d58, merge_da_on_success=true)at /test/11.4_dbg/sql/sp_head.cc:1327
      #21 0x000062cb8f159141 in sp_head::execute_function (this=0x6892cc024080, thd=0x6892cc000d58, argp=0x0, argcount=0, return_value_fld=0x6892cc01acf0, func_ctx=0x6892cc019f98, call_arena=0x6892cc01aa68)at /test/11.4_dbg/sql/sp_head.cc:2091
      #22 0x000062cb8f6a61fe in Item_sp::execute_impl (this=0x6892cc019f30, thd=0x6892cc000d58, args=0x0, arg_count=0)at /test/11.4_dbg/sql/item.cc:3001
      #23 0x000062cb8f6a5c24 in Item_sp::execute (this=0x6892cc019f30, thd=0x6892cc000d58, null_value=0x6892cc019eec, args=0x0, arg_count=0)at /test/11.4_dbg/sql/item.cc:2915
      #24 0x000062cb8f7346c5 in Item_func_sp::execute (this=0x6892cc019e80)at /test/11.4_dbg/sql/item_func.cc:6746
      #25 0x000062cb8f73f8e5 in Item_func_sp::update_null_value (this=0x6892cc019e80)at /test/11.4_dbg/sql/item_func.h:4181
      #26 0x000062cb8f10a87d in Item_func::is_null (this=0x6892cc019e80)at /test/11.4_dbg/sql/item_func.h:253
      #27 0x000062cb8f888b47 in mysql_do (thd=0x6892cc000d58, values=@0x6892cc01aa88: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6892cc01aaa0, last = 0x6892cc01aaa0, elements = 1}, <No data fields>})at /test/11.4_dbg/sql/sql_do.cc:36
      #28 0x000062cb8f268bb4 in mysql_execute_command (thd=0x6892cc000d58, is_called_from_prepared_stmt=false) at /test/11.4_dbg/sql/sql_parse.cc:4031
      #29 0x000062cb8f260bc4 in mysql_parse (thd=0x6892cc000d58, rawbuf=0x6892cc019bf0 "DO f1()", length=7, parser_state=0x70935c1a8b30)at /test/11.4_dbg/sql/sql_parse.cc:7928
      #30 0x000062cb8f25e089 in dispatch_command (command=COM_QUERY, thd=0x6892cc000d58, packet=0x6892cc00afe9 "DO f1()", packet_length=7, blocking=true) at /test/11.4_dbg/sql/sql_parse.cc:1925
      #31 0x000062cb8f261773 in do_command (thd=0x6892cc000d58, blocking=true)at /test/11.4_dbg/sql/sql_parse.cc:1433
      #32 0x000062cb8f449e79 in do_handle_one_connection (connect=0x62cb9de860c8, put_in_cache=true) at /test/11.4_dbg/sql/sql_connect.cc:1508
      #33 0x000062cb8f449c12 in handle_one_connection (arg=0x62cb9de50c88)at /test/11.4_dbg/sql/sql_connect.cc:1420
      #34 0x000070938a49cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #35 0x000070938a529ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.11  dbg  061026  76ed5b7ea0c9cddfe9386aee4a5ff42a2adf1593  name|SIGABRT|THD::push_warning_truncated_value_for_field|Type_handler_fbt<Inet6, Type_collection_fbt<Inet6> >::Field_fbt::store_warning|Type_handler_fbt<Inet6, Type_collection_fbt<Inet6> >::Field_fbt::set_min_value_with_warn|Type_handler_fbt<Inet6, Type_collection_fbt<Inet6> >::Field_fbt::store
      CS  10.11  opt  061026  76ed5b7ea0c9cddfe9386aee4a5ff42a2adf1593  No bug found                  
      CS  11.4   dbg  061026  b6398296aeeeb253bdb3d1dd1620d2bb03836bf7  name|SIGABRT|THD::push_warning_truncated_value_for_field|Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::store_warning|Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::set_min_value_with_warn|Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::store
      CS  11.4   opt  061026  b6398296aeeeb253bdb3d1dd1620d2bb03836bf7  No bug found                  
      CS  11.8   dbg  061026  dddbd5ff427894941fee3d7528ca2058e026b82e  No bug found                  
      CS  11.8   opt  061026  dddbd5ff427894941fee3d7528ca2058e026b82e  No bug found                  
      CS  12.3   dbg  061026  07b869588831fb9ebc6364c77cba105d6cca3b77  No bug found                  
      CS  12.3   opt  061026  07b869588831fb9ebc6364c77cba105d6cca3b77  No bug found                  
      CS  13.0   dbg  061026  620a4b5624222048fece7fe1789978ae0675cae2  No bug found                  
      CS  13.0   opt  061026  620a4b5624222048fece7fe1789978ae0675cae2  No bug found                  
      CS  13.1   dbg  061026  87e62ca17270e163a6d41b3fc8d6f4d440f1bb88  No bug found                  
      CS  13.1   opt  061026  87e62ca17270e163a6d41b3fc8d6f4d440f1bb88  No bug found                  
      CS  13.2   dbg  061026  9d7ab2c0092df4bc73b64b915464aecf7e5fe6c4  No bug found                  
      CS  13.2   opt  061026  9d7ab2c0092df4bc73b64b915464aecf7e5fe6c4  No bug found                  
      ES  11.4   dbg  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  name|SIGABRT|THD::push_warning_truncated_value_for_field|Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::store_warning|Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::set_min_value_with_warn|Type_handler_fbt<Inet6, Type_collection_inet>::Field_fbt::store
      ES  11.4   opt  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  No bug found                  
      ES  11.8   dbg  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found                  
      ES  11.8   opt  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found                  
      ES  12.3   dbg  280926  082387a5f3cbb877157998bb4baa95928f4aa121  No bug found                  
      ES  12.3   opt  280926  082387a5f3cbb877157998bb4baa95928f4aa121  No bug found                  
      

      Attachments

        Activity

          People

            shulga Dmitry Shulga
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 0.5h
                0.5h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.