--source include/have_innodb.inc

drop table if exists t1, t2;

drop view if exists v1;

create table t1 (a int not null, b int, c int) engine=InnoDB;

create trigger trgi before insert on t1 for each row set new.a=if(new.a is null,new.b,new.c);

create table t2 (d int, e int) engine=InnoDB;

update t1, t2 set a=NULL, b=2, c=NULL where b=d and e=200;

create view v1 as select * from t1, t2 where d=2;

insert v1 (a,c) values (NULL, 20);

mysqld: /home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc:532: void Protocol::end_statement(): Assertion `0' failed.

Thread 28 "mysqld" received signal SIGABRT, Aborted.

[Switching to Thread 0x7fffec473b00 (LWP 7029)]

0x00007ffff6498418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54

54	../sysdeps/unix/sysv/linux/raise.c: No such file or directory.

(gdb) bt

#0  0x00007ffff6498418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54

#1  0x00007ffff649a01a in __GI_abort () at abort.c:89

#2  0x00007ffff6490bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x555556362f2f "0", 

    file=file@entry=0x555556363020 "/home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc", 

    line=line@entry=532, 

    function=function@entry=0x555556363960 <Protocol::end_statement()::__PRETTY_FUNCTION__> "void Protocol::end_statement()") at assert.c:92

#3  0x00007ffff6490c82 in __GI___assert_fail (assertion=0x555556362f2f "0", 

    file=0x555556363020 "/home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc", line=532, 

    function=0x555556363960 <Protocol::end_statement()::__PRETTY_FUNCTION__> "void Protocol::end_statement()")

    at assert.c:101

#4  0x000055555596b24c in Protocol::end_statement (this=0x555557a17540)

    at /home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc:532

#5  0x0000555555a211d7 in dispatch_command (command=COM_QUERY, thd=0x555557a16fb0, 

    packet=0x555557a1d811 "insert v1 (a,c) values (NULL, 20)", packet_length=33)

    at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_parse.cc:1940

#6  0x0000555555a1e90d in do_command (thd=0x555557a16fb0)

    at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_parse.cc:1108

#7  0x0000555555b54ddb in do_handle_one_connection (thd_arg=0x555557a16fb0)

    at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_connect.cc:1350

#8  0x0000555555b54b2a in handle_one_connection (arg=0x555557a16fb0)

    at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_connect.cc:1262

#9  0x00007ffff6ebe6fa in start_thread (arg=0x7fffec473b00) at pthread_create.c:333

#10 0x00007ffff6569b5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109