Debian Codegraph @

mysql-test/suite/clone/t/ddl_basic.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 --let $ddl_no_table = 1
8 --source ../include/create_ddl_schema.inc
9
10 --let $dml_stmt_check = CALL execute_dml(1, 0, 100, 100, 10, 0)
11
12 --echo # 1. CREATE TABLE while clone in progress
13 --let $ddl_op1 = CREATE TABLE
14 --let $ddl_stmt1 = (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
15 --let $ddl_post1 = PARTITION BY KEY(col1) PARTITIONS 5
16
17 --let $dml_stmt1 = INSERT INTO t1 SELECT * FROM t
18 --let $dml_stmt11 = INSERT INTO t11 SELECT * FROM t
19
20 --let $dml_stmt2 = CALL execute_dml(0, 0, 100, 100, 10, 0)
21 --let $dml_stmt21 = INSERT INTO t21 SELECT * FROM t
22
23 --source ../include/ddl_common.inc
24
25 --echo # 2. DROP TABLE while clone in progress
26 --let $ddl_op1 = DROP TABLE
27 --let $ddl_stmt1 =
28 --let $ddl_post1 =
29
30 --let $dml_stmt1 = SHOW TABLES
31 --let $dml_stmt11 = SHOW TABLES
32
33 --let $dml_stmt2 = SHOW TABLES
34 --let $dml_stmt21 = SHOW TABLES
35
36 --let $ddl_skip_check = 1
37
38 --source ../include/ddl_common.inc
39
40 --echo # Cleanup
41 --let $ddl_drop_schema_tables = 1
42 --let $ddl_recreate_schema_tables = 1
43 --source ../include/drop_ddl_schema.inc
44
45 --echo # Uninstall clone
46 UNINSTALL PLUGIN clone;