Debian Codegraph @

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

raw
1 # Test clone with concurrent UNDO DDL
2 --source include/have_debug_sync.inc
3
4 if ($undo_encryption) {
5 --let $ddl_encryption = 1
6 --source include/have_innodb_max_16k.inc
7 --source ../include/encrypt_begin.inc
8
9 SET GLOBAL innodb_undo_log_encrypt = ON;
10 SHOW VARIABLES LIKE 'innodb_undo_log_encrypt';
11 }
12
13 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
14 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
15
16 --source ../include/create_ddl_schema.inc
17
18 --let $dml_stmt_check = CALL execute_dml(1, 0, 100, 100, 10, 0)
19
20 --let $dml_stmt1 = CALL execute_dml(0, 0, 100, 100, 10, 0)
21 --let $dml_stmt11 = CALL execute_dml(0, 0, 100, 100, 10, 0)
22
23 --let $dml_stmt2 = CALL execute_dml(0, 0, 100, 100, 10, 0)
24 --let $dml_stmt21 = CALL execute_dml(0, 0, 100, 100, 10, 0)
25 --let $ddl_undo = 1
26
27 --echo # 1. CREATE UNDO TABLESPACE while clone in progress
28 --let $ddl_undo_create = 1
29 --let $ddl_op1 = CREATE UNDO TABLESPACE
30 --let $ddl_stmt1 = ADD DATAFILE
31
32 --source ../include/ddl_common.inc
33 --let $ddl_undo_create =
34
35 --echo # 2. TRUNCATE UNDO TABLESPACE while clone in progress
36 --let $ddl_undo_empty = 1
37 --let $ddl_op1 = ALTER UNDO TABLESPACE
38 --let $ddl_stmt1 = SET INACTIVE
39
40 --source ../include/ddl_common.inc
41 --let $ddl_undo_empty =
42
43 --echo # 3. DROP UNDO TABLESPACE while clone in progress
44 --let $ddl_op1 = DROP UNDO TABLESPACE
45 --let $ddl_stmt1 =
46
47 --source ../include/ddl_common.inc
48
49 --echo # Cleanup
50 --let $ddl_drop_schema_tables = 1
51 --let $ddl_drop_tables = 1
52 --source ../include/drop_ddl_schema.inc
53
54 --echo # Uninstall clone
55 UNINSTALL PLUGIN clone;
56
57 if ($undo_encryption) {
58 --source ../include/encrypt_end.inc
59 }