Debian Codegraph @

mysql-test/suite/mariabackup/xb_compressed_encrypted.test

raw
1 --source include/innodb_page_size_small.inc
2 --source include/have_file_key_management.inc
3
4 CREATE TABLE t1(c1 INT, b VARCHAR(2400), index(b(100),c1))
5 ENGINE=INNODB ROW_FORMAT=compressed ENCRYPTED=YES;
6
7 BEGIN;
8 let $n= 5000;
9 let $i= $n;
10 let $u= `SELECT uuid()`;
11 --disable_query_log
12 while ($i) {
13 eval INSERT INTO t1
14 VALUES($n-$i, concat('$u', $n-$i, repeat('ab', floor(rand()*100)), '$u'));
15 dec $i;
16 }
17 --enable_query_log
18 COMMIT;
19
20 echo # xtrabackup backup;
21 --disable_result_log
22 let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
23 exec $INNOBACKUPEX --defaults-file=$MYSQLTEST_VARDIR/my.cnf --no-timestamp $targetdir;
24 drop table t1;
25 exec $INNOBACKUPEX --apply-log $targetdir;
26
27 -- source include/restart_and_restore.inc
28 --enable_result_log
29 select sum(c1) from t1;
30 DROP TABLE t1;
31 rmdir $targetdir;