Aleksey Midenkov added a comment - 2018-02-27 14:54 Analysis

Ralf Gebhardt added a comment - 2018-02-27 19:54 - edited The same happens for update+delete: create or replace table t1 ( x int , sys_start bigint unsigned as row start invisible, sys_end bigint unsigned as row end invisible, period for system_time (sys_start, sys_end) ) engine innodb with system versioning;   insert into t1 (x) values (1); begin ; update t1 set x= 3; delete from t1 where x=3; commit ;   select *,sys_start,sys_end from t1 for system_time all ; +------+-----------+---------+ | x | sys_start | sys_end | +------+-----------+---------+ | 3 | 88 | 88 | | 1 | 85 | 88 | +------+-----------+---------+