Debian Codegraph @

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

raw
1 # Test clone with concurrent DDL
2 --source include/have_debug_sync.inc
3
4 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
5 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
6
7 --source ../include/create_ddl_schema.inc
8
9 --echo # 1. RENAME and CREATE a TABLE with same name while clone in progress
10 --let $dml_stmt_check = CALL execute_dml(1, 0, 100, 100, 10, 0)
11 --let $ddl_count = 2
12 --let $ddl_table_extn_show = _new
13
14 --let $ddl_table_rename1 = 1
15 --let $ddl_table_extn1 = _new
16 --let $ddl_op1 = ALTER TABLE
17 --let $ddl_stmt1 = RENAME
18
19 --let $ddl_op2 = CREATE TABLE
20 --let $ddl_stmt2 = (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
21 --let $ddl_post1 = PARTITION BY KEY(col1) PARTITIONS 5
22
23 --let $dml_stmt1 = CALL execute_dml(0, 0, 100, 100, 10, 0)
24 --let $dml_stmt11 = INSERT INTO t11 SELECT * FROM t
25
26 --let $dml_stmt2 = CALL execute_dml(0, 0, 100, 100, 10, 0)
27 --let $dml_stmt21 = INSERT INTO t21 SELECT * FROM t
28
29 --source ../include/ddl_common.inc
30
31 --let $ddl_count =
32 --let $ddl_table_rename1 =
33 --let $ddl_table_extn1 =
34
35 --echo # Cleanup
36 --let $ddl_drop_tables = 1
37 --let $ddl_drop_renamed_tables = 1
38 --source ../include/drop_ddl_schema.inc
39
40 --echo # 2. CREATE & DROP TABLE while clone in progress
41 --let $dml_stmt_check = CALL execute_dml(1, 0, 100, 100, 10, 0)
42 --let $ddl_op1 = CREATE TABLE
43 --let $ddl_stmt1 = (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
44 --let $ddl_post1 = PARTITION BY KEY(col1) PARTITIONS 5
45
46 --let $dml_stmt1 = INSERT INTO t1 SELECT * FROM t
47 --let $dml_stmt11 = INSERT INTO t11 SELECT * FROM t
48
49 --let $dml_stmt2 = INSERT INTO t2 SELECT * FROM t
50 --let $dml_stmt21 = INSERT INTO t21 SELECT * FROM t
51
52 --let $post_dml = 1
53 --let $ddl_op1_after_dml = DROP TABLE
54
55 --let $ddl_skip_check = 1
56 --source ../include/ddl_common.inc
57
58 --echo # Cleanup
59 --let $ddl_drop_schema_tables = 1
60 --let $ddl_recreate_schema_tables = 1
61 --let $ddl_drop_tables =
62 --let $ddl_drop_renamed_tables =
63 --source ../include/drop_ddl_schema.inc
64
65 --echo # Uninstall clone
66 UNINSTALL PLUGIN clone;