create or replace table t1 (
  x int,
  sys_trx_start bigint unsigned as row start,
  sys_trx_end bigint unsigned as row end,
  period for system_time (sys_trx_start, sys_trx_end)
) with system versioning engine innodb;
insert into t1 (x) values (1);
insert into t1 (x) values (2);
commit;
delete from t1 where x=1;
commit;
select * from t1;
select * from t1 for system_time as of TIMESTAMP'2018-01-01 00:00:00';



MariaDB [test]> select * from t1;
+------+---------------+----------------------+
| x    | sys_trx_start | sys_trx_end          |
+------+---------------+----------------------+
|    2 |         26323 | 18446744073709551615 |
+------+---------------+----------------------+
1 row in set (0.00 sec)

MariaDB [test]>
MariaDB [test]> select * from t1 for system_time as of TIMESTAMP'2018-01-01 00:00:00';
+------+---------------+----------------------+
| x    | sys_trx_start | sys_trx_end          |
+------+---------------+----------------------+
|    1 |         26320 |                26326 |
|    2 |         26323 | 18446744073709551615 |
+------+---------------+----------------------+
2 rows in set (0.01 sec)