1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
create table t (a int) with system versioning;
insert into t values (1);
update t set a=2;
insert into t values (3);
# shutdown server
# remove datadir
# xtrabackup move back
# restart
show create table t;
Table Create Table
t CREATE TABLE `t` (
`a` int(11) DEFAULT NULL
) ENGINE=INNODB_OR_MYISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
select * from t;
a
2
select a from t for system_time all;
a
2
1
create or replace table t (
a int,
s bigint unsigned as row start invisible,
e bigint unsigned as row end invisible,
period for system_time(s, e)
) with system versioning engine=innodb;
insert into t values (1);
update t set a=2;
insert into t values (3);
# shutdown server
# remove datadir
# xtrabackup move back
# restart
show create table t;
Table Create Table
t CREATE TABLE `t` (
`a` int(11) DEFAULT NULL,
`s` bigint(20) unsigned GENERATED ALWAYS AS ROW START INVISIBLE,
`e` bigint(20) unsigned GENERATED ALWAYS AS ROW END INVISIBLE,
PERIOD FOR SYSTEM_TIME (`s`, `e`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
select * from t;
a
2
select a from t for system_time all;
a
2
1
drop table t;
|
