create table t1 (id int, dt date)engine=myisam;

insert into t1 values (19,'2008-05-21');

create table t2 (id int, dt date)engine=myisam;

insert into t2 values (45,'2006-01-12'),(45,'2034-12-19');

create algorithm=temptable view v2 as select * from t2;

update (t1 join (t1 as a1 join v2 on v2.id = a1.id) on (v2.dt <5 and v2.dt=a1.dt)) set t1.id =1;

drop view v2;

drop table t1,t2;

#3  <signal handler called>

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

#5  0x00007f5108dc902a in __GI_abort () at abort.c:89

#6  0x00007f5108dbfbd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x555722064810 "fixed == 1", file=file@entry=0x555722064bd8 "/10.2/sql/item_cmpfunc.cc", line=line@entry=5076, function=function@entry=0x555722066de0 <Item_cond_and::val_int()::__PRETTY_FUNCTION__> "virtual longlong Item_cond_and::val_int()") at assert.c:92

#7  0x00007f5108dbfc82 in __GI___assert_fail (assertion=0x555722064810 "fixed == 1", file=0x555722064bd8 "/10.2/sql/item_cmpfunc.cc", line=5076, function=0x555722066de0 <Item_cond_and::val_int()::__PRETTY_FUNCTION__> "virtual longlong Item_cond_and::val_int()") at assert.c:101

#8  0x00005557217c50ed in Item_cond_and::val_int (this=0x7f50b8042440) at /10.2/sql/item_cmpfunc.cc:5076

#9  0x00005557215529d2 in make_join_select (join=0x7f50b8038378, select=0x7f50b8041940, cond=0x7f50b8039520) at /10.2/sql/sql_select.cc:9948

#10 0x000055572153ae95 in JOIN::optimize_inner (this=0x7f50b8038378) at /10.2/sql/sql_select.cc:1779

#11 0x00005557215385f1 in JOIN::optimize (this=0x7f50b8038378) at /10.2/sql/sql_select.cc:1113

#12 0x0000555721541ab6 in mysql_select (thd=0x7f50b8000b00, tables=0x7f50b8012c68, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f50b80382b0, unit=0x7f50b8004700, select_lex=0x7f50b8004e40) at /10.2/sql/sql_select.cc:3804

#13 0x00005557215eb139 in mysql_multi_update (thd=0x7f50b8000b00, table_list=0x7f50b8012c68, fields=0x7f50b8004f68, values=0x7f50b8005440, conds=0x0, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x7f50b8004700, select_lex=0x7f50b8004e40, result=0x7f51004397a0) at /10.2/sql/sql_update.cc:1635

#14 0x00005557214f908c in mysql_execute_command (thd=0x7f50b8000b00) at /10.2/sql/sql_parse.cc:4082

#15 0x0000555721504bc9 in mysql_parse (thd=0x7f50b8000b00, rawbuf=0x7f50b8012468 "update (t1 join (t1 as a1 join v2 on v2.id = a1.id) on (v2.dt <5 and v2.dt=a1.dt)) set t1.id =1", length=95, parser_state=0x7f510043a080, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:7759

#16 0x00005557214f2e8c in dispatch_command (command=COM_QUERY, thd=0x7f50b8000b00, packet=0x7f50b8096131 "update (t1 join (t1 as a1 join v2 on v2.id = a1.id) on (v2.dt <5 and v2.dt=a1.dt)) set t1.id =1", packet_length=95, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:1831

#17 0x00005557214f17a0 in do_command (thd=0x7f50b8000b00) at /10.2/sql/sql_parse.cc:1385

#18 0x00005557216479ad in do_handle_one_connection (connect=0x5557259f6fd0) at /10.2/sql/sql_connect.cc:1336

#19 0x0000555721647718 in handle_one_connection (arg=0x5557259f6fd0) at /10.2/sql/sql_connect.cc:1241

#20 0x0000555721e74036 in pfs_spawn_thread (arg=0x555725a01dc0) at /10.2/storage/perfschema/pfs.cc:1862

#21 0x00007f5109a046ba in start_thread (arg=0x7f510043b700) at pthread_create.c:333

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