Debian Codegraph @

mysql-test/suite/mariabackup/system_versioning.test

raw
1 create table t (a int) with system versioning;
2 insert into t values (1);
3 update t set a=2;
4
5 let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
6
7 --disable_result_log
8 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$targetdir;
9 --enable_result_log
10
11 insert into t values (3);
12
13 --disable_result_log
14 exec $XTRABACKUP --prepare --target-dir=$targetdir;
15 -- source include/restart_and_restore.inc
16 --enable_result_log
17
18 --replace_result InnoDB INNODB_OR_MYISAM MyISAM INNODB_OR_MYISAM
19 show create table t;
20 select * from t;
21 select a from t for system_time all;
22
23 rmdir $targetdir;
24
25 create or replace table t (
26 a int,
27 s bigint unsigned as row start invisible,
28 e bigint unsigned as row end invisible,
29 period for system_time(s, e)
30 ) with system versioning engine=innodb;
31 insert into t values (1);
32 update t set a=2;
33
34 --disable_result_log
35 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$targetdir;
36 --enable_result_log
37
38 insert into t values (3);
39
40 --disable_result_log
41 exec $XTRABACKUP --prepare --target-dir=$targetdir;
42 -- source include/restart_and_restore.inc
43 --enable_result_log
44
45 show create table t;
46 select * from t;
47 select a from t for system_time all;
48
49 drop table t;
50 rmdir $targetdir;