Debian Codegraph @

mysql-test/suite/innodb/include/innodb_bulk_create_index_debug.inc

raw
1 #
2 # wl#7277: InnoDB: Bulk Load for Create Index
3 #
4
5 # Not supported in embedded
6 -- source include/not_embedded.inc
7 -- source include/have_debug.inc
8 -- source include/have_debug_sync.inc
9
10 # Create Insert Procedure
11 DELIMITER |;
12 CREATE PROCEDURE populate_t1()
13 BEGIN
14 DECLARE i int DEFAULT 1;
15
16 START TRANSACTION;
17 WHILE (i <= 10000) DO
18 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
19 SET i = i + 1;
20 END WHILE;
21 COMMIT;
22 END|
23 DELIMITER ;|
24
25 # Test scenarios:
26 # 1. Test restart;
27 # 2. Test crash recovery.
28
29 # Test Restart
30 if ($row_format != 'COMPRESSED')
31 {
32 eval CREATE TABLE t1(
33 class INT,
34 id INT,
35 title VARCHAR(100)
36 ) ENGINE=InnoDB ROW_FORMAT=$row_format;
37 }
38
39 if ($row_format == 'COMPRESSED')
40 {
41 eval CREATE TABLE t1(
42 class INT,
43 id INT,
44 title VARCHAR(100)
45 ) ENGINE=InnoDB ROW_FORMAT=$row_format KEY_BLOCK_SIZE=4;
46 }
47
48 -- disable_query_log
49 CALL populate_t1();
50 -- enable_query_log
51
52 SELECT COUNT(*) FROM t1;
53
54 --enable_info
55 CREATE INDEX idx_title ON t1(title);
56 --disable_info
57
58 RENAME TABLE t1 TO t0;
59
60 -- echo # Test Blob
61
62 if ($row_format != 'COMPRESSED') {
63 eval CREATE TABLE t1(
64 a INT PRIMARY KEY,
65 b TEXT,
66 c TEXT) ENGINE=InnoDB ROW_FORMAT=$row_format;
67 }
68
69 if ($row_format == 'COMPRESSED') {
70 eval CREATE TABLE t1(
71 a INT PRIMARY KEY,
72 b TEXT,
73 c TEXT) ENGINE=InnoDB ROW_FORMAT=$row_format KEY_BLOCK_SIZE=4;
74 }
75
76 INSERT INTO t1 VALUES
77 (1, REPEAT('a',10000), 'a'),
78 (2, REPEAT('b',20000), 'b'),
79 (3, REPEAT('c',40000), 'c'),
80 (4, REPEAT('d',60000), 'd');
81
82 SELECT CHAR_LENGTH(b) FROM t1;
83
84 --enable_info
85 ALTER TABLE t1 DROP COLUMN c, FORCE;
86 --disable_info
87
88 --source include/restart_mysqld.inc
89
90 CHECK TABLE t0,t1;
91
92 SELECT CHAR_LENGTH(b) FROM t1;
93
94 DROP TABLE t1;
95
96 RENAME TABLE t0 to t1;
97
98 CHECK TABLE t1;
99
100 SELECT * FROM t1 WHERE title = 'a10';
101
102 SELECT * FROM t1 WHERE title = 'a5000';
103
104 SELECT * FROM t1 WHERE title = 'a10000';
105
106 SELECT * FROM t1 WHERE title = 'a10010';
107
108 DROP TABLE t1;
109
110 # Test Crash Recovery
111
112 if ($row_format != 'COMPRESSED')
113 {
114 eval CREATE TABLE t1(
115 class INT,
116 id INT,
117 title VARCHAR(100)
118 ) ENGINE=InnoDB ROW_FORMAT=$row_format;
119 }
120
121 if ($row_format == 'COMPRESSED')
122 {
123 eval CREATE TABLE t1(
124 class INT,
125 id INT,
126 title VARCHAR(100)
127 ) ENGINE=InnoDB ROW_FORMAT=$row_format KEY_BLOCK_SIZE=4;
128 }
129
130 -- disable_query_log
131 CALL populate_t1();
132 -- enable_query_log
133
134 connect (hang,localhost,root);
135 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
136 send
137 CREATE INDEX idx_title ON t1(title);
138
139 connection default;
140 SET DEBUG_SYNC='now WAIT_FOR hung';
141 let $shutdown_timeout=0;
142 --source include/restart_mysqld.inc
143 disconnect hang;
144
145 SELECT COUNT(*) FROM t1;
146
147 CHECK TABLE t1;
148
149 EXPLAIN SELECT * FROM t1 WHERE title = 'a10';
150
151 SELECT * FROM t1 WHERE title = 'a10';
152
153 SELECT * FROM t1 WHERE title = 'a5000';
154
155 SELECT * FROM t1 WHERE title = 'a10000';
156
157 SELECT * FROM t1 WHERE title = 'a10010';
158
159 DROP TABLE t1;
160
161 -- echo # Test Blob
162
163 if ($row_format != 'COMPRESSED') {
164 eval CREATE TABLE t1(
165 a INT PRIMARY KEY,
166 b TEXT,
167 c TEXT) ENGINE=InnoDB ROW_FORMAT=$row_format;
168 }
169
170 if ($row_format == 'COMPRESSED') {
171 eval CREATE TABLE t1(
172 a INT PRIMARY KEY,
173 b TEXT,
174 c TEXT) ENGINE=InnoDB ROW_FORMAT=$row_format KEY_BLOCK_SIZE=4;
175 }
176
177 INSERT INTO t1 VALUES
178 (1, REPEAT('a',10000), 'a'),
179 (2, REPEAT('b',20000), 'b'),
180 (3, REPEAT('c',40000), 'c'),
181 (4, REPEAT('d',60000), 'd');
182
183 SELECT CHAR_LENGTH(b) FROM t1;
184
185 connect (hang,localhost,root);
186 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
187 send
188 ALTER TABLE t1 DROP COLUMN c, FORCE;
189
190 connection default;
191 SET DEBUG_SYNC='now WAIT_FOR hung';
192 --source include/restart_mysqld.inc
193 disconnect hang;
194 let $shutdown_timeout=60;
195
196 CHECK TABLE t1;
197
198 SELECT CHAR_LENGTH(b) FROM t1;
199
200 DROP TABLE t1;
201
202 DROP PROCEDURE populate_t1;