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

Assertion failure in Type_handler_composite::Item_val_bool on NEW AND 1 in trigger on single-column table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 13.2
    • 13.2
    • Triggers
    • None
    • Not for Release Notes

    Description

      CREATE TABLE t (a INT); 
      INSERT INTO t VALUES (1);
      CREATE TRIGGER tr BEFORE UPDATE ON t FOR EACH ROW SET @x = NEW AND 1;
      UPDATE t SET a = 2; 
      

      Leads to

      MDEV-34723 CS 13.2.0 0a83f874e3edbee2942f31792647b21101a555c6 (Optimized, Clang 18.1.3-11) Build 30/10/2026

      Core was generated by `/test/mtest/MDEV-34723/MD301026-mariadb-13.2.0-linux-x86_64-opt/bin/mariadbd --'.
      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 1342036)]
      (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  0x000070b78fc4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000070b78fc288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000062f13d82e4e9 in Type_handler_composite::Item_val_bool (this=0x147a40, item=0x147a54)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_type_composite.h:232
      #6  0x000062f13d8eff88 in Item_cond_and::val_bool (this=0x68b6540241d0)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/item_cmpfunc.cc:5781
      #7  0x000062f13d54571d in Item_bool_func::val_int (this=0x147a40)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/item_cmpfunc.h:245
      #8  0x000062f13d922640 in Item_func_set_user_var::check (this=0x68b654024300, use_result_field=12)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/item_func.cc:5225
      #9  0x000062f13d55ce85 in set_var_user::check (this=0x68b654024470, thd=<optimized out>)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/set_var.cc:952
      #10 0x000062f13d55c967 in sql_set_variables (thd=thd@entry=0x68b654000c70, var_list=var_list@entry=0x68b65405b198, free=true)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/set_var.cc:784
      #11 0x000062f13d627356 in mysql_execute_command (thd=0x68b654000c70, is_called_from_prepared_stmt=false)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_parse.cc:4965
      #12 0x000062f13d7d01d7 in sp_instr_stmt::exec_core (this=0x68b6540244b0, thd=0x147a40, nextp=0x6)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sp_instr.cc:1338
      #13 0x000062f13d7ce3da in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x68b6540244e8, thd=thd@entry=0x68b654000c70, nextp=nextp@entry=0x70b78c8d4394, open_tables=false, instr=instr@entry=0x68b6540244b0, rerun_the_same_instr=<optimized out>)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sp_instr.cc:420
      #14 0x000062f13d7cea06 in sp_lex_keeper::validate_lex_and_exec_core (this=this@entry=0x68b6540244e8, thd=thd@entry=0x68b654000c70, nextp=nextp@entry=0x70b78c8d4394, open_tables=<optimized out>, instr=instr@entry=0x68b6540244b0)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sp_instr.cc:624
      #15 0x000062f13d7cfc0a in sp_instr_stmt::execute (this=0x68b6540244b0, thd=0x68b654000c70, nextp=0x70b78c8d4394)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sp_instr.cc:1240
      #16 0x000062f13d5775ca in sp_head::execute (this=this@entry=0x68b654022e20, thd=thd@entry=0x68b654000c70, merge_da_on_success=false)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sp_head.cc:1347
      #17 0x000062f13d578662 in sp_head::execute_trigger (this=0x68b654022e20, thd=0x68b654000c70, db_name=<optimized out>, table_name=<optimized out>, grant_info=<optimized out>)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sp_head.cc:1863
      #18 0x000062f13d6f1dd6 in Table_triggers_list::process_triggers (this=0x68b654056590, thd=0x68b654000c70, event=TRG_EVENT_UPDATE, time_type=<optimized out>, old_row_is_record1=<optimized out>, skip_row_indicator=0x70b78c8d4c07, fields_in_update_stmt=0x68b654005d78)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_trigger.cc:2918
      #19 0x000062f13d5b8f35 in fill_record_n_invoke_before_triggers (thd=thd@entry=0x68b654000c70, table=table@entry=0x68b654054ed0, fields=@0x68b654005d78: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x68b6540186c0, last = 0x68b6540186c0, elements = 1}, <No data fields>}, values=@0x68b654006220: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x68b6540186d0, last = 0x68b6540186d0, elements = 1}, <No data fields>}, ignore_errors=<optimized out>, event=event@entry=TRG_EVENT_UPDATE, skip_row_indicator=0x70b78c8d4c07)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_base.cc:9774
      #20 0x000062f13d704551 in Sql_cmd_update::update_single_table (this=this@entry=0x68b6540186e0, thd=thd@entry=0x68b654000c70)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_update.cc:1010
      #21 0x000062f13d7094b2 in Sql_cmd_update::execute_inner (this=0x68b6540186e0, thd=0x68b654000c70)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_update.cc:3320
      #22 0x000062f13d69eafb in Sql_cmd_dml::execute (this=0x68b6540186e0, thd=0x68b654000c70)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_select.cc:35131
      #23 0x000062f13d6265e6 in mysql_execute_command (thd=thd@entry=0x68b654000c70, is_called_from_prepared_stmt=false)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_parse.cc:4493
      #24 0x000062f13d621942 in mysql_parse (thd=thd@entry=0x68b654000c70, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x70b78c8d5580)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_parse.cc:8005
      #25 0x000062f13d61fef8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x68b654000c70, packet=packet@entry=0x68b654008ea1 "UPDATE t SET a = 2", packet_length=packet_length@entry=18, blocking=true)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_parse.cc:1903
      #26 0x000062f13d621db1 in do_command (thd=thd@entry=0x68b654000c70, blocking=true)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_parse.cc:1437
      #27 0x000062f13d74ea0d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x62f169542da0, put_in_cache=true)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_connect.cc:1514
      #28 0x000062f13d74e842 in handle_one_connection (arg=arg@entry=0x62f169542da0)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/sql/sql_connect.cc:1426
      #29 0x000062f13dafd123 in pfs_spawn_thread (arg=0x62f169563790)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_opt/storage/perfschema/pfs.cc:2198
      #30 0x000070b78fc9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #31 0x000070b78fd29ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Issue Links

          Activity

            People

              rucha174 Rucha Deodhar
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

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

                  Git Integration

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