|
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 |
|
+------+-----------+---------+
|
|