Debian Codegraph @

mysql-test/suite/clone/include/create_schema.inc

raw
1 ## Create test schema
2 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
3
4 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
5 PARTITION BY KEY(col1) PARTITIONS 5;
6
7 DELIMITER |;
8
9 # Procedure to execute dml commands in loop
10 # p_dml_type [IN] DML type
11 # 0 -> INSERT
12 # 1 -> UPDATE
13 # 2 -> DELETE
14 # p_key_min [IN] Minimum key value
15 # p_key_range [IN] Maximum key range
16 # p_loop_count [IN] Number of times to execute
17 # p_frequency [IN] Frequency of commit/rollback
18 # p_is_rand [IN] chose key randomly and do rollback and commit
19
20 CREATE PROCEDURE execute_dml(
21 p_dml_type INT,
22 p_key_min INT,
23 p_key_range INT,
24 p_loop_count INT,
25 p_frequency INT,
26 p_is_rand INT)
27 BEGIN
28 DECLARE v_idx INT DEFAULT 0;
29 DECLARE v_commit INT DEFAULT 0;
30 DECLARE v_key INT DEFAULT 0;
31
32 /* Loop and INSERT data at random position */
33 WHILE(v_idx < p_loop_count) DO
34
35 /* Generate key between 1 to p_loop_count */
36 IF p_is_rand = 1 THEN
37 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
38 ELSE
39 SET v_key = p_key_min + (v_idx % p_key_range);
40 END IF;
41
42 CASE p_dml_type
43
44 WHEN 0 THEN
45 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
46 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
47 v_key, v_key * 10,
48 @clol3_text, REPEAT('Large Column Data ', 2048))
49 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
50
51 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
52 v_key, v_key * 10,
53 @clol3_text, REPEAT('Large Column Data ', 2048))
54 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
55
56 WHEN 1 THEN
57 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
58 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
59
60 WHEN 2 THEN
61 DELETE FROM t1 WHERE col1 = v_key;
62 DELETE FROM t2 WHERE col1 = v_key;
63
64 ELSE
65 DELETE FROM t1;
66 DELETE FROM t2;
67 END CASE;
68
69 SET v_idx = v_idx + 1;
70
71 /* Commit or rollback work at specified frequency. */
72 IF v_idx % p_frequency = 0 THEN
73
74 SET v_commit = FLOOR(RAND() * 2);
75 IF v_commit = 0 AND p_is_rand = 1 THEN
76 ROLLBACK;
77 START TRANSACTION;
78 ELSE
79 COMMIT;
80 START TRANSACTION;
81 END IF;
82 END IF;
83
84 END WHILE;
85 COMMIT;
86 END|
87
88 if ($clone_ddl) {
89
90 # Procedure to execute ddl rebuild in loop
91 # p_loop_count [IN] Number of times to execute
92
93 CREATE PROCEDURE execute_ddl(
94 p_loop_count INT)
95 BEGIN
96 DECLARE v_idx INT DEFAULT 0;
97
98 /* Loop and execute DDL. */
99 /* Concurrent DDL and DML creates MDL deadlock. Disabled till fixed. */
100 WHILE(v_idx < p_loop_count) DO
101
102 ALTER TABLE t1 ENGINE = InnoDB;
103
104 ALTER TABLE t2 ENGINE = InnoDB;
105
106 DO SLEEP(0.1);
107
108 SET v_idx = v_idx + 1;
109
110 END WHILE;
111 END|
112
113 }
114
115 DELIMITER ;|