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

Assertion `fixed()' failed in Item_func_connection_id::val_int on INSERT w/ TRIGGER

    XMLWordPrintable

Details

    • Q3/2026 Server Maintenance

    Description

      SET sql_mode='';
      CREATE TABLE t (c INT);
      LOCK TABLE t WRITE;
      CREATE OR REPLACE TABLE t (a INT AS (CONNECTION_ID()));
      CREATE TRIGGER a BEFORE INSERT ON t FOR EACH ROW SET @a:=1;
      INSERT INTO t VALUES ('');

      Testcase is CLI/MTR compatible.

      Leads to:

      CS 13.1.0 02e1853c894906737fe0ea5f836adb087b1a72ad (Debug, Clang 22.1.6-20260529) Build 05/06/2026

      mariadbd: /test/13.0_dbg/sql/item_func.h:1497: virtual longlong Item_func_connection_id::val_int(): Assertion `fixed()' failed.

      CS 13.1.0 02e1853c894906737fe0ea5f836adb087b1a72ad (Debug, Clang 22.1.6-20260529) Build 05/06/2026

      Core was generated by `/test/MD050626-mariadb-13.1.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.
      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 1023836)]
      (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  0x00007835f3e4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007835f3e288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007835f3e2881b in __assert_fail_base (fmt=0x7835f3fd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5993fd532df4 "fixed()", file=file@entry=0x5993fd532017 "/test/13.0_dbg/sql/item_func.h", line=line@entry=1497, function=function@entry=0x5993fd5edc4b "virtual longlong Item_func_connection_id::val_int()") at ./assert/assert.c:94
      #6  0x00007835f3e3b507 in __assert_fail (assertion=0x5993fd532df4 "fixed()", file=0x5993fd532017 "/test/13.0_dbg/sql/item_func.h", line=1497, function=0x5993fd5edc4b "virtual longlong Item_func_connection_id::val_int()") at ./assert/assert.c:103
      #7  0x00005993fca2e9d5 in Item_func_connection_id::val_int (this=0x7034f0087630) at /test/13.0_dbg/sql/item_func.h:1497
      #8  0x00005993fc9b1888 in Item::save_int_in_field (this=0x7034f0087630, field=0x7034f0086cc0, no_conversions=false)at /test/13.0_dbg/sql/item.cc:7328
      #9  0x00005993fc829fd0 in Type_handler_int_result::Item_save_in_field (this=0x5993fe2616a0 <type_handler_ulong>, item=0x7034f0087630, field=0x7034f0086cc0, no_conversions=false)at /test/13.0_dbg/sql/sql_type.cc:4512
      #10 0x00005993fc9b19c5 in Item::save_in_field (this=0x7034f0087630, field=0x7034f0086cc0, no_conversions=false)at /test/13.0_dbg/sql/item.cc:7348
      #11 0x00005993fc6f621a in TABLE::update_virtual_fields (this=0x7034f0085fc0, h=0x7034f0086410, update_mode=VCOL_UPDATE_FOR_WRITE)at /test/13.0_dbg/sql/table.cc:9409
      #12 0x00005993fc4c578c in fill_record_n_invoke_before_triggers (thd=0x7034f0000d60, table=0x7034f0085fc0, ptr=0x7034f0087f40, values=@0x7034f001b110: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7034f001b1d0, last = 0x7034f001b1d0, elements = 1}, <No data fields>}, ignore_errors=false, event=TRG_EVENT_INSERT, skip_row_indicator=0x7835ebffbe6f) at /test/13.0_dbg/sql/sql_base.cc:9712
      #13 0x00005993fc515345 in mysql_insert (thd=0x7034f0000d60, table_list=0x7034f001a4c0, fields=@0x7034f0006248: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5993fe231480 <end_of_list>, last = 0x7034f0006248, elements = 0}, <No data fields>}, values_list=@0x7034f0006290: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7034f001b1e0, last = 0x7034f001b1e0, elements = 1}, <No data fields>}, update_fields=@0x7034f0006278: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5993fe231480 <end_of_list>, last = 0x7034f0006278, elements = 0}, <No data fields>}, update_values=@0x7034f0006260: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5993fe231480 <end_of_list>, last = 0x7034f0006260, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0)at /test/13.0_dbg/sql/sql_insert.cc:1193
      #14 0x00005993fc57c453 in mysql_execute_command (thd=0x7034f0000d60, is_called_from_prepared_stmt=false) at /test/13.0_dbg/sql/sql_parse.cc:4502
      #15 0x00005993fc573208 in mysql_parse (thd=0x7034f0000d60, rawbuf=0x7034f001a3c0 "INSERT INTO t VALUES ('')", length=25, parser_state=0x7835ebffd9f0) at /test/13.0_dbg/sql/sql_parse.cc:7945
      #16 0x00005993fc57095e in dispatch_command (command=COM_QUERY, thd=0x7034f0000d60, packet=0x7034f000b5f1 "INSERT INTO t VALUES ('')", packet_length=25, blocking=true) at /test/13.0_dbg/sql/sql_parse.cc:1903
      #17 0x00005993fc573c8a in do_command (thd=0x7034f0000d60, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1437
      #18 0x00005993fc744fae in do_handle_one_connection (connect=0x5993ff601830, put_in_cache=true) at /test/13.0_dbg/sql/sql_connect.cc:1503
      #19 0x00005993fc744d91 in handle_one_connection (arg=0x5993ff6040d0)at /test/13.0_dbg/sql/sql_connect.cc:1415
      #20 0x00007835f3e9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #21 0x00007835f3f29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.6   dbg  100426  f39b634db715cd9dc1835653d1ce544df2aa1613  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      CS  10.6   opt  100426  f39b634db715cd9dc1835653d1ce544df2aa1613  No bug found                  
      CS  10.11  dbg  100426  ba774a0a90fac0163babe9d7a964aa36503e1711  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      CS  10.11  opt  100426  ba774a0a90fac0163babe9d7a964aa36503e1711  No bug found                  
      CS  11.4   dbg  100426  dc89915ad9bf3dcb67e66d2844c77ec0403373de  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      CS  11.4   opt  100426  dc89915ad9bf3dcb67e66d2844c77ec0403373de  No bug found                  
      CS  11.8   dbg  100426  e47db94aea7f0d6e0177e948486fc8860331f05f  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      CS  11.8   opt  100426  e47db94aea7f0d6e0177e948486fc8860331f05f  No bug found                  
      CS  12.3   dbg  100426  f5bb9922107672e88f7b5cbdb3d25151cc5744bb  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      CS  12.3   opt  100426  f5bb9922107672e88f7b5cbdb3d25151cc5744bb  No bug found                  
      CS  13.0   dbg  210526  c8e8d33309606e682c98675d594dbd23ebc2ddf6  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      CS  13.0   opt  210526  c8e8d33309606e682c98675d594dbd23ebc2ddf6  No bug found                  
      CS  13.1   dbg  050626  02e1853c894906737fe0ea5f836adb087b1a72ad  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      CS  13.1   opt  050626  02e1853c894906737fe0ea5f836adb087b1a72ad  No bug found                  
      ES  10.6   dbg  100426  84a80c8b38208d362225496da08d86d8d454e453  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      ES  10.6   opt  100426  84a80c8b38208d362225496da08d86d8d454e453  No bug found                  
      ES  11.4   dbg  100426  8b2bf17b733262409422ce7d039a0c021fc47077  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      ES  11.4   opt  100426  8b2bf17b733262409422ce7d039a0c021fc47077  No bug found                  
      ES  11.8   dbg  100426  854cae81f52e477c7777a51db26ba640d8755b81  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      ES  11.8   opt  100426  854cae81f52e477c7777a51db26ba640d8755b81  No bug found                  
      ES  12.3   dbg  220426  613a6253fe9efc12e166f83a97663ba263db8317  fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
      ES  12.3   opt  220426  613a6253fe9efc12e166f83a97663ba263db8317  No bug found                  
      MS  5.5    dbg  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  No bug found                  
      MS  5.5    opt  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  No bug found                  
      MS  5.6    dbg  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  No bug found                  
      MS  5.6    opt  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  No bug found                  
      MS  5.7    dbg  070525  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  
      MS  5.7    opt  070525  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  
      MS  8.0    dbg  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  
      MS  8.0    opt  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  
      MS  9.1    dbg  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  
      MS  9.1    opt  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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