Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.18, 10.1(EOL), 10.2(EOL)
-
None
-
10.2.4-1
Description
How to repeat
Start server with @@optimizer_use_condition_selectivity=4 and execute the following commands:
--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);
|
Stacktrace
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
|
The following tests in the main suite also fail due to this issue (when started with -mysqld=-optimizer_use_condition_selectivity=4):
- main.strict
- main.gis
- main.ps_2myisam
- main.ps_3innodb
- main.ps_4heap
- main.trigger_null-8605
- main.view
Attachments
Issue Links
- relates to
-
MDEV-7635 update defaults and simplify mysqld config parameters
- Closed