1#
2# PXB-1936: --prepare cannot decrypt table but "completed ok"
3#
4
5require_server_version_higher_than 5.7.10
6
7. inc/keyring_file.sh
8
9start_server
10
11mysql -e "CREATE TABLE t (a INT) ENCRYPTION='y'" test
12
13mysql -e "INSERT INTO t VALUES (1), (2), (3), (4)" test
14
15( while true ; do
16    mysql -e "INSERT INTO t SELECT a + 10*$i FROM t ORDER BY a LIMIT 4" test
17    mysql -e "ALTER INSTANCE ROTATE INNODB MASTER KEY"
18    sleep 1
19done ) 2>/dev/null &
20
21xtrabackup --backup --target-dir=$topdir/backup
22
23stop_server
24
25run_cmd_expect_failure $XB_BIN $XB_ARGS --prepare --target-dir=$topdir/backup
26
27rm -rf $mysql_datadir
28rm -rf $topdir/backup
29
30start_server
31
32mysql -e "CREATE TABLE t (a INT) ENCRYPTION='y'" test
33
34mysql -e "INSERT INTO t VALUES (1), (2), (3), (4)" test
35
36shutdown_server
37start_server
38
39( while true ; do
40    mysql -e "INSERT INTO t SELECT a + 10*$i FROM t ORDER BY a LIMIT 4" test
41    sleep 1
42done ) 2>/dev/null &
43
44xtrabackup --backup --target-dir=$topdir/backup
45
46stop_server
47
48run_cmd_expect_failure $XB_BIN $XB_ARGS --prepare --target-dir=$topdir/backup
49