Debian Codegraph @

mysql-test/suite/clone/t/ddl_sys_encrypt_page_copy.test

raw
1 # Test clone with concurrent enable/disable of REDO and UNDO encryption
2 --source include/have_debug_sync.inc
3
4 --source include/have_innodb_max_16k.inc
5 --source ../include/encrypt_begin.inc
6 --source include/count_sessions.inc
7
8 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
9 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
10
11 --connect (con1,localhost,root,,)
12 --echo # In connection CON1
13
14 CREATE TABLESPACE tbs;
15
16 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
17 TABLESPACE = tbs;
18
19 --connection default
20 --echo # In connection DEFAULT
21
22 --echo # 1. Enable REDO encryption during PAGE COPY
23 --let $ddl_error = 1
24 --let $ddl_alter_abort= SET GLOBAL innodb_redo_log_encrypt = ON
25 --source ../include/ddl_clone_abort.inc
26
27 --echo # 2. Enable UNDO encryption during PAGE COPY
28 --let $ddl_error = 1
29 --let $ddl_alter_abort= SET GLOBAL innodb_undo_log_encrypt = ON
30 --source ../include/ddl_clone_abort.inc
31
32 --echo # 3. Enable general tablespace encryption during PAGE COPY
33 --let $ddl_error =
34 --let $ddl_alter_abort=ALTER TABLESPACE tbs ENCRYPTION = 'Y'
35 --source ../include/ddl_clone_abort.inc
36
37 --echo # 4.Disable general tablespace encryption during PAGE COPY
38 --let $ddl_error =
39 --let $ddl_alter_abort=ALTER TABLESPACE tbs ENCRYPTION = 'N'
40 --source ../include/ddl_clone_abort.inc
41
42 --disconnect con1
43
44 --echo # Cleanup
45 DROP TABLE t1;
46 DROP TABLESPACE tbs;
47
48 --echo # Uninstall clone
49 UNINSTALL PLUGIN clone;
50
51 --source include/wait_until_count_sessions.inc
52 --source ../include/encrypt_end.inc