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

Server crashes in Field::is_real_null

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (
        pk INT PRIMARY KEY,
        i INT,
        v1 INT AS (i) VIRTUAL,
        v2 INT AS (i) VIRTUAL
      );
       
      CREATE TRIGGER tr BEFORE UPDATE ON t1 FOR EACH ROW SET @a = 1;
      INSERT INTO t1 (pk, i) VALUES (0, NULL),(NULL, NULL);
      

      10.1 5d9ca52219e4a4c92fc4a80ffc09b5075b1e5616

      #1  0x00007fc4065914ca in my_write_core (sig=11) at /data/src/10.1/mysys/stacktrace.c:477
      #2  0x00007fc405f2df38 in handle_fatal_signal (sig=11) at /data/src/10.1/sql/signal_handler.cc:296
      #3  <signal handler called>
      #4  0x00007fc405c9e946 in Field::is_real_null (this=0x7fc3faa00541, row_offset=0) at /data/src/10.1/sql/field.h:1031
      #5  0x00007fc405c9c1de in not_null_fields_have_null_values (table=0x7fc3fa881c70) at /data/src/10.1/sql/sql_base.cc:8821
      #6  0x00007fc405c9c2de in fill_record_n_invoke_before_triggers (thd=0x7fc3fc7f9070, table=0x7fc3fa881c70, fields=..., values=..., ignore_errors=false, event=TRG_EVENT_INSERT) at /data/src/10.1/sql/sql_base.cc:8867
      #7  0x00007fc405cd4e3a in mysql_insert (thd=0x7fc3fc7f9070, table_list=0x7fc3fa8431a0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.1/sql/sql_insert.cc:903
      #8  0x00007fc405cf96c1 in mysql_execute_command (thd=0x7fc3fc7f9070) at /data/src/10.1/sql/sql_parse.cc:3898
      #9  0x00007fc405d0455a in mysql_parse (thd=0x7fc3fc7f9070, rawbuf=0x7fc3fa843088 "INSERT INTO t1 (pk, i) VALUES (0, NULL),(NULL, NULL)", length=52, parser_state=0x7fc406c125e0) at /data/src/10.1/sql/sql_parse.cc:7319
      #10 0x00007fc405cf2f2d in dispatch_command (command=COM_QUERY, thd=0x7fc3fc7f9070, packet=0x7fc3fe13e071 "INSERT INTO t1 (pk, i) VALUES (0, NULL),(NULL, NULL)", packet_length=52) at /data/src/10.1/sql/sql_parse.cc:1487
      #11 0x00007fc405cf1c64 in do_command (thd=0x7fc3fc7f9070) at /data/src/10.1/sql/sql_parse.cc:1108
      #12 0x00007fc405e281c1 in do_handle_one_connection (thd_arg=0x7fc3fc7f9070) at /data/src/10.1/sql/sql_connect.cc:1350
      #13 0x00007fc405e27f25 in handle_one_connection (arg=0x7fc3fc7f9070) at /data/src/10.1/sql/sql_connect.cc:1262
      #14 0x00007fc40610b416 in pfs_spawn_thread (arg=0x7fc402c27ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1860
      #15 0x00007fc4053ef0a4 in start_thread (arg=0x7fc406c13b00) at pthread_create.c:309
      #16 0x00007fc4035a787d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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