[MDEV-11551] Server crashes in Field::is_real_null Created: 2016-12-12  Updated: 2017-01-15  Resolved: 2017-01-15

Status: Closed
Project: MariaDB Server
Component/s: Triggers, Virtual Columns
Affects Version/s: 10.1, 10.2
Fix Version/s: 10.1.21, 10.2.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 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


Generated at Thu Feb 08 07:50:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.