Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bulk_create_index_debug.result

raw
1 CREATE PROCEDURE populate_t1()
2 BEGIN
3 DECLARE i int DEFAULT 1;
4 START TRANSACTION;
5 WHILE (i <= 10000) DO
6 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
7 SET i = i + 1;
8 END WHILE;
9 COMMIT;
10 END|
11 CREATE TABLE t1(
12 class INT,
13 id INT,
14 title VARCHAR(100)
15 ) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
16 SELECT COUNT(*) FROM t1;
17 COUNT(*)
18 10000
19 CREATE INDEX idx_title ON t1(title);
20 # restart
21 CHECK TABLE t1;
22 Table Op Msg_type Msg_text
23 test.t1 check status OK
24 SELECT * FROM t1 WHERE title = 'a10';
25 class id title
26 10 10 a10
27 SELECT * FROM t1 WHERE title = 'a5000';
28 class id title
29 5000 5000 a5000
30 SELECT * FROM t1 WHERE title = 'a10000';
31 class id title
32 10000 10000 a10000
33 SELECT * FROM t1 WHERE title = 'a10010';
34 class id title
35 DROP TABLE t1;
36 # Test Blob
37 CREATE TABLE t1(
38 a INT PRIMARY KEY,
39 b TEXT,
40 c TEXT) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
41 INSERT INTO t1 VALUES
42 (1, REPEAT('a',10000), 'a'),
43 (2, REPEAT('b',20000), 'b'),
44 (3, REPEAT('c',40000), 'c'),
45 (4, REPEAT('d',60000), 'd');
46 SELECT CHAR_LENGTH(b) FROM t1;
47 CHAR_LENGTH(b)
48 10000
49 20000
50 40000
51 60000
52 ALTER TABLE t1 DROP COLUMN c;
53 # restart
54 CHECK TABLE t1;
55 Table Op Msg_type Msg_text
56 test.t1 check status OK
57 SELECT CHAR_LENGTH(b) FROM t1;
58 CHAR_LENGTH(b)
59 10000
60 20000
61 40000
62 60000
63 DROP TABLE t1;
64 DROP PROCEDURE populate_t1;
65 CREATE PROCEDURE populate_t1()
66 BEGIN
67 DECLARE i int DEFAULT 1;
68 START TRANSACTION;
69 WHILE (i <= 10000) DO
70 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
71 SET i = i + 1;
72 END WHILE;
73 COMMIT;
74 END|
75 CREATE TABLE t1(
76 class INT,
77 id INT,
78 title VARCHAR(100)
79 ) ENGINE=InnoDB ROW_FORMAT=COMPACT;
80 SELECT COUNT(*) FROM t1;
81 COUNT(*)
82 10000
83 CREATE INDEX idx_title ON t1(title);
84 # restart
85 CHECK TABLE t1;
86 Table Op Msg_type Msg_text
87 test.t1 check status OK
88 SELECT * FROM t1 WHERE title = 'a10';
89 class id title
90 10 10 a10
91 SELECT * FROM t1 WHERE title = 'a5000';
92 class id title
93 5000 5000 a5000
94 SELECT * FROM t1 WHERE title = 'a10000';
95 class id title
96 10000 10000 a10000
97 SELECT * FROM t1 WHERE title = 'a10010';
98 class id title
99 DROP TABLE t1;
100 # Test Blob
101 CREATE TABLE t1(
102 a INT PRIMARY KEY,
103 b TEXT,
104 c TEXT) ENGINE=InnoDB ROW_FORMAT=COMPACT;
105 INSERT INTO t1 VALUES
106 (1, REPEAT('a',10000), 'a'),
107 (2, REPEAT('b',20000), 'b'),
108 (3, REPEAT('c',40000), 'c'),
109 (4, REPEAT('d',60000), 'd');
110 SELECT CHAR_LENGTH(b) FROM t1;
111 CHAR_LENGTH(b)
112 10000
113 20000
114 40000
115 60000
116 ALTER TABLE t1 DROP COLUMN c;
117 # restart
118 CHECK TABLE t1;
119 Table Op Msg_type Msg_text
120 test.t1 check status OK
121 SELECT CHAR_LENGTH(b) FROM t1;
122 CHAR_LENGTH(b)
123 10000
124 20000
125 40000
126 60000
127 DROP TABLE t1;
128 DROP PROCEDURE populate_t1;
129 CREATE PROCEDURE populate_t1()
130 BEGIN
131 DECLARE i int DEFAULT 1;
132 START TRANSACTION;
133 WHILE (i <= 10000) DO
134 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
135 SET i = i + 1;
136 END WHILE;
137 COMMIT;
138 END|
139 CREATE TABLE t1(
140 class INT,
141 id INT,
142 title VARCHAR(100)
143 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
144 SELECT COUNT(*) FROM t1;
145 COUNT(*)
146 10000
147 CREATE INDEX idx_title ON t1(title);
148 # restart
149 CHECK TABLE t1;
150 Table Op Msg_type Msg_text
151 test.t1 check status OK
152 SELECT * FROM t1 WHERE title = 'a10';
153 class id title
154 10 10 a10
155 SELECT * FROM t1 WHERE title = 'a5000';
156 class id title
157 5000 5000 a5000
158 SELECT * FROM t1 WHERE title = 'a10000';
159 class id title
160 10000 10000 a10000
161 SELECT * FROM t1 WHERE title = 'a10010';
162 class id title
163 DROP TABLE t1;
164 # Test Blob
165 CREATE TABLE t1(
166 a INT PRIMARY KEY,
167 b TEXT,
168 c TEXT) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
169 INSERT INTO t1 VALUES
170 (1, REPEAT('a',10000), 'a'),
171 (2, REPEAT('b',20000), 'b'),
172 (3, REPEAT('c',40000), 'c'),
173 (4, REPEAT('d',60000), 'd');
174 SELECT CHAR_LENGTH(b) FROM t1;
175 CHAR_LENGTH(b)
176 10000
177 20000
178 40000
179 60000
180 ALTER TABLE t1 DROP COLUMN c;
181 # restart
182 CHECK TABLE t1;
183 Table Op Msg_type Msg_text
184 test.t1 check status OK
185 SELECT CHAR_LENGTH(b) FROM t1;
186 CHAR_LENGTH(b)
187 10000
188 20000
189 40000
190 60000
191 DROP TABLE t1;
192 DROP PROCEDURE populate_t1;
193 CREATE PROCEDURE populate_t1()
194 BEGIN
195 DECLARE i int DEFAULT 1;
196 START TRANSACTION;
197 WHILE (i <= 10000) DO
198 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
199 SET i = i + 1;
200 END WHILE;
201 COMMIT;
202 END|
203 SET GLOBAL innodb_file_per_table=1;
204 CREATE TABLE t1(
205 class INT,
206 id INT,
207 title VARCHAR(100)
208 ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
209 SELECT COUNT(*) FROM t1;
210 COUNT(*)
211 10000
212 CREATE INDEX idx_title ON t1(title);
213 # restart
214 CHECK TABLE t1;
215 Table Op Msg_type Msg_text
216 test.t1 check status OK
217 SELECT * FROM t1 WHERE title = 'a10';
218 class id title
219 10 10 a10
220 SELECT * FROM t1 WHERE title = 'a5000';
221 class id title
222 5000 5000 a5000
223 SELECT * FROM t1 WHERE title = 'a10000';
224 class id title
225 10000 10000 a10000
226 SELECT * FROM t1 WHERE title = 'a10010';
227 class id title
228 DROP TABLE t1;
229 # Test Blob
230 SET GLOBAL innodb_file_per_table=1;
231 CREATE TABLE t1(
232 a INT PRIMARY KEY,
233 b TEXT,
234 c TEXT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
235 INSERT INTO t1 VALUES
236 (1, REPEAT('a',10000), 'a'),
237 (2, REPEAT('b',20000), 'b'),
238 (3, REPEAT('c',40000), 'c'),
239 (4, REPEAT('d',60000), 'd');
240 SELECT CHAR_LENGTH(b) FROM t1;
241 CHAR_LENGTH(b)
242 10000
243 20000
244 40000
245 60000
246 ALTER TABLE t1 DROP COLUMN c;
247 # restart
248 CHECK TABLE t1;
249 Table Op Msg_type Msg_text
250 test.t1 check status OK
251 SELECT CHAR_LENGTH(b) FROM t1;
252 CHAR_LENGTH(b)
253 10000
254 20000
255 40000
256 60000
257 DROP TABLE t1;
258 SET GLOBAL innodb_file_per_table=default;
259 DROP PROCEDURE populate_t1;