Debian Codegraph @

mysql-test/suite/innodb/r/innodb-16k.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 SET @save_stats_persistent = @@GLOBAL.innodb_stats_persistent;
3 SET GLOBAL innodb_stats_persistent = 0;
4 call mtr.add_suppression("InnoDB: Cannot add field .* in table");
5 # Test 1) Show the page size from Information Schema
6 SELECT variable_value FROM information_schema.global_status
7 WHERE LOWER(variable_name) = 'innodb_page_size';
8 variable_value
9 16384
10 # Test 4) The maximum row size is dependent upon the page size.
11 # Redundant: 8123, Compact: 8126, Dynamic: 8126.
12 # Each row format has its own amount of overhead that
13 # varies depending on number of fields and other overhead.
14 SET SESSION innodb_strict_mode = ON;
15 SET @save_level=@@GLOBAL.innodb_compression_level;
16 SET GLOBAL innodb_compression_level=1;
17 CREATE TABLE t1 (
18 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
19 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
20 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
21 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
22 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
23 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
24 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
25 c36 char(200), c37 char(200), c38 char(196)
26 ) ROW_FORMAT=compressed;
27 DROP TABLE t1;
28 CREATE TABLE t1 (
29 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
30 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
31 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
32 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
33 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
34 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
35 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
36 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(160)
37 ) ROW_FORMAT=compressed;
38 ERROR 42000: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
39 CREATE TABLE t1 (a varchar(255) character set utf8,
40 b varchar(255) character set utf8,
41 c varchar(255) character set utf8,
42 d varchar(255) character set utf8,
43 e varchar(4) character set utf8,
44 PRIMARY KEY (a,b,c,d,e))
45 ENGINE=innodb;
46 DROP TABLE t1;
47 CREATE TABLE t1 (a varchar(255) character set utf8,
48 b varchar(255) character set utf8,
49 c varchar(255) character set utf8,
50 d varchar(255) character set utf8,
51 e varchar(5) character set utf8,
52 PRIMARY KEY (a,b,c,d,e))
53 ENGINE=innodb;
54 ERROR 42000: Specified key was too long; max key length is 3072 bytes
55 CREATE TABLE t1 (a varchar(255) character set utf8,
56 b varchar(255) character set utf8,
57 c varchar(255) character set utf8,
58 d varchar(255) character set utf8,
59 e varchar(255) character set utf8,
60 f varchar(4) character set utf8,
61 PRIMARY KEY (a), KEY (b,c,d,e,f))
62 ENGINE=innodb;
63 DROP TABLE t1;
64 CREATE TABLE t1 (a varchar(255) character set utf8,
65 b varchar(255) character set utf8,
66 c varchar(255) character set utf8,
67 d varchar(255) character set utf8,
68 e varchar(255) character set utf8,
69 f varchar(5) character set utf8,
70 PRIMARY KEY (a), KEY (b,c,d,e,f))
71 ENGINE=innodb;
72 ERROR 42000: Specified key was too long; max key length is 3072 bytes
73 # Test 5) Make sure that KEY_BLOCK_SIZE=16, 8, 4, 2 & 1
74 # are all accepted.
75 SET SESSION innodb_strict_mode = ON;
76 CREATE TABLE t1 (i int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
77 SHOW WARNINGS;
78 Level Code Message
79 SELECT table_name, row_format, create_options
80 FROM information_schema.tables WHERE table_name = 't1';
81 table_name row_format create_options
82 t1 Compressed row_format=COMPRESSED key_block_size=16
83 ALTER TABLE t1 KEY_BLOCK_SIZE=8;
84 SHOW WARNINGS;
85 Level Code Message
86 SELECT table_name, row_format, create_options
87 FROM information_schema.tables WHERE table_name = 't1';
88 table_name row_format create_options
89 t1 Compressed row_format=COMPRESSED key_block_size=8
90 ALTER TABLE t1 KEY_BLOCK_SIZE=4;
91 SHOW WARNINGS;
92 Level Code Message
93 SELECT table_name, row_format, create_options
94 FROM information_schema.tables WHERE table_name = 't1';
95 table_name row_format create_options
96 t1 Compressed row_format=COMPRESSED key_block_size=4
97 ALTER TABLE t1 KEY_BLOCK_SIZE=2;
98 SHOW WARNINGS;
99 Level Code Message
100 SELECT table_name, row_format, create_options
101 FROM information_schema.tables WHERE table_name = 't1';
102 table_name row_format create_options
103 t1 Compressed row_format=COMPRESSED key_block_size=2
104 ALTER TABLE t1 KEY_BLOCK_SIZE=1;
105 SHOW WARNINGS;
106 Level Code Message
107 SELECT table_name, row_format, create_options
108 FROM information_schema.tables WHERE table_name = 't1';
109 table_name row_format create_options
110 t1 Compressed row_format=COMPRESSED key_block_size=1
111 ALTER TABLE t1 KEY_BLOCK_SIZE=0;
112 SHOW WARNINGS;
113 Level Code Message
114 SELECT table_name, row_format, create_options
115 FROM information_schema.tables WHERE table_name = 't1';
116 table_name row_format create_options
117 t1 Compressed row_format=COMPRESSED
118 DROP TABLE t1;
119 SET SESSION innodb_strict_mode = OFF;
120 CREATE TABLE t1 (i int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
121 SHOW WARNINGS;
122 Level Code Message
123 SELECT table_name, row_format, create_options
124 FROM information_schema.tables WHERE table_name = 't1';
125 table_name row_format create_options
126 t1 Compressed row_format=COMPRESSED key_block_size=16
127 ALTER TABLE t1 KEY_BLOCK_SIZE=8;
128 SHOW WARNINGS;
129 Level Code Message
130 SELECT table_name, row_format, create_options
131 FROM information_schema.tables WHERE table_name = 't1';
132 table_name row_format create_options
133 t1 Compressed row_format=COMPRESSED key_block_size=8
134 ALTER TABLE t1 KEY_BLOCK_SIZE=4;
135 SHOW WARNINGS;
136 Level Code Message
137 SELECT table_name, row_format, create_options
138 FROM information_schema.tables WHERE table_name = 't1';
139 table_name row_format create_options
140 t1 Compressed row_format=COMPRESSED key_block_size=4
141 ALTER TABLE t1 KEY_BLOCK_SIZE=2;
142 SHOW WARNINGS;
143 Level Code Message
144 SELECT table_name, row_format, create_options
145 FROM information_schema.tables WHERE table_name = 't1';
146 table_name row_format create_options
147 t1 Compressed row_format=COMPRESSED key_block_size=2
148 ALTER TABLE t1 KEY_BLOCK_SIZE=1;
149 SHOW WARNINGS;
150 Level Code Message
151 SELECT table_name, row_format, create_options
152 FROM information_schema.tables WHERE table_name = 't1';
153 table_name row_format create_options
154 t1 Compressed row_format=COMPRESSED key_block_size=1
155 ALTER TABLE t1 KEY_BLOCK_SIZE=0;
156 SHOW WARNINGS;
157 Level Code Message
158 SELECT table_name, row_format, create_options
159 FROM information_schema.tables WHERE table_name = 't1';
160 table_name row_format create_options
161 t1 Compressed row_format=COMPRESSED
162 DROP TABLE t1;
163 CREATE TABLE t2(d varchar(17) PRIMARY KEY) ENGINE=innodb DEFAULT CHARSET=utf8;
164 CREATE TABLE t3(a int PRIMARY KEY) ENGINE=innodb;
165 INSERT INTO t3 VALUES (22),(44),(33),(55),(66);
166 INSERT INTO t2 VALUES ('jejdkrun87'),('adfd72nh9k'),
167 ('adfdpplkeock'),('adfdijnmnb78k'),('adfdijn0loKNHJik');
168 CREATE TABLE t1(a int, b blob, c text, d text NOT NULL)
169 ENGINE=innodb DEFAULT CHARSET=utf8;
170 INSERT INTO t1
171 SELECT a,LEFT(REPEAT(d,100*a),65535),REPEAT(d,20*a),d FROM t2,t3
172 ORDER BY a,d;
173 DROP TABLE t2, t3;
174 SELECT COUNT(*) FROM t1 WHERE a=44;
175 COUNT(*)
176 5
177 SELECT a,
178 LENGTH(b),b=LEFT(REPEAT(d,100*a),65535),LENGTH(c),c=REPEAT(d,20*a),d FROM t1
179 ORDER BY a,d;
180 a LENGTH(b) b=LEFT(REPEAT(d,100*a),65535) LENGTH(c) c=REPEAT(d,20*a) d
181 22 22000 1 4400 1 adfd72nh9k
182 22 35200 1 7040 1 adfdijn0loKNHJik
183 22 28600 1 5720 1 adfdijnmnb78k
184 22 26400 1 5280 1 adfdpplkeock
185 22 22000 1 4400 1 jejdkrun87
186 33 33000 1 6600 1 adfd72nh9k
187 33 52800 1 10560 1 adfdijn0loKNHJik
188 33 42900 1 8580 1 adfdijnmnb78k
189 33 39600 1 7920 1 adfdpplkeock
190 33 33000 1 6600 1 jejdkrun87
191 44 44000 1 8800 1 adfd72nh9k
192 44 65535 1 14080 1 adfdijn0loKNHJik
193 44 57200 1 11440 1 adfdijnmnb78k
194 44 52800 1 10560 1 adfdpplkeock
195 44 44000 1 8800 1 jejdkrun87
196 55 55000 1 11000 1 adfd72nh9k
197 55 65535 1 17600 1 adfdijn0loKNHJik
198 55 65535 1 14300 1 adfdijnmnb78k
199 55 65535 1 13200 1 adfdpplkeock
200 55 55000 1 11000 1 jejdkrun87
201 66 65535 1 13200 1 adfd72nh9k
202 66 65535 1 21120 1 adfdijn0loKNHJik
203 66 65535 1 17160 1 adfdijnmnb78k
204 66 65535 1 15840 1 adfdpplkeock
205 66 65535 1 13200 1 jejdkrun87
206 ALTER TABLE t1 ADD PRIMARY KEY (a), ADD KEY (b(20));
207 ERROR 23000: Duplicate entry '22' for key 'PRIMARY'
208 DELETE FROM t1 WHERE d='null';
209 ALTER TABLE t1 ADD PRIMARY KEY (a), ADD KEY (b(20));
210 ERROR 23000: Duplicate entry '22' for key 'PRIMARY'
211 DELETE FROM t1 WHERE a%2;
212 CHECK TABLE t1;
213 Table Op Msg_type Msg_text
214 test.t1 check status OK
215 ALTER TABLE t1 ADD PRIMARY KEY (a,b(255),c(255)), ADD KEY (b(767));
216 SELECT COUNT(*) FROM t1 WHERE a=44;
217 COUNT(*)
218 5
219 SELECT a,
220 LENGTH(b), b=LEFT(REPEAT(d,100*a), 65535),LENGTH(c), c=REPEAT(d,20*a), d FROM t1
221 ORDER BY a,d;
222 a LENGTH(b) b=LEFT(REPEAT(d,100*a), 65535) LENGTH(c) c=REPEAT(d,20*a) d
223 22 22000 1 4400 1 adfd72nh9k
224 22 35200 1 7040 1 adfdijn0loKNHJik
225 22 28600 1 5720 1 adfdijnmnb78k
226 22 26400 1 5280 1 adfdpplkeock
227 22 22000 1 4400 1 jejdkrun87
228 44 44000 1 8800 1 adfd72nh9k
229 44 65535 1 14080 1 adfdijn0loKNHJik
230 44 57200 1 11440 1 adfdijnmnb78k
231 44 52800 1 10560 1 adfdpplkeock
232 44 44000 1 8800 1 jejdkrun87
233 66 65535 1 13200 1 adfd72nh9k
234 66 65535 1 21120 1 adfdijn0loKNHJik
235 66 65535 1 17160 1 adfdijnmnb78k
236 66 65535 1 15840 1 adfdpplkeock
237 66 65535 1 13200 1 jejdkrun87
238 SHOW CREATE TABLE t1;
239 Table Create Table
240 t1 CREATE TABLE `t1` (
241 `a` int(11) NOT NULL,
242 `b` blob NOT NULL,
243 `c` text NOT NULL,
244 `d` text NOT NULL,
245 PRIMARY KEY (`a`,`b`(255),`c`(255)),
246 KEY `b` (`b`(767))
247 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
248 CHECK TABLE t1;
249 Table Op Msg_type Msg_text
250 test.t1 check status OK
251 DROP TABLE t1;
252 # Test 8) Test creating a table that could lead to undo log overflow.
253 CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
254 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
255 o blob,p blob,q blob,r blob,s blob,t blob,u blob)
256 ENGINE=InnoDB ROW_FORMAT=dynamic;
257 SET @a = repeat('a', 767);
258 SET @b = repeat('b', 767);
259 SET @c = repeat('c', 767);
260 SET @d = repeat('d', 767);
261 SET @e = repeat('e', 767);
262 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
263 UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
264 k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b;
265 CREATE INDEX t1a ON t1 (a(767));
266 CREATE INDEX t1b ON t1 (b(767));
267 CREATE INDEX t1c ON t1 (c(767));
268 CREATE INDEX t1d ON t1 (d(767));
269 CREATE INDEX t1e ON t1 (e(767));
270 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
271 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c;
272 CREATE INDEX t1f ON t1 (f(767));
273 BEGIN;
274 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d,f=@d,g=@d,h=@d,i=@d,j=@d,
275 k=@d,l=@d,m=@d,n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
276 ROLLBACK;
277 BEGIN;
278 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
279 UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d,k=@d,l=@d,m=@d,
280 n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
281 COMMIT;
282 CREATE INDEX t1g ON t1 (g(767));
283 UPDATE t1 SET g=@e;
284 CREATE INDEX t1h ON t1 (h(767));
285 UPDATE t1 SET h=@e;
286 CREATE INDEX t1i ON t1 (i(767));
287 UPDATE t1 SET i=@e;
288 CREATE INDEX t1j ON t1 (j(767));
289 UPDATE t1 SET j=@e;
290 CREATE INDEX t1k ON t1 (k(767));
291 UPDATE t1 SET k=@e;
292 CREATE INDEX t1l ON t1 (l(767));
293 UPDATE t1 SET l=@e;
294 CREATE INDEX t1m ON t1 (m(767));
295 UPDATE t1 SET m=@e;
296 CREATE INDEX t1n ON t1 (n(767));
297 UPDATE t1 SET n=@e;
298 CREATE INDEX t1o ON t1 (o(767));
299 UPDATE t1 SET o=@e;
300 CREATE INDEX t1p ON t1 (p(767));
301 UPDATE t1 SET p=@e;
302 CREATE INDEX t1q ON t1 (q(767));
303 UPDATE t1 SET q=@e;
304 CREATE INDEX t1r ON t1 (r(767));
305 UPDATE t1 SET r=@e;
306 CREATE INDEX t1s ON t1 (s(767));
307 UPDATE t1 SET s=@e;
308 CREATE INDEX t1t ON t1 (t(767));
309 BEGIN;
310 UPDATE t1 SET t=@e;
311 ROLLBACK;
312 SHOW CREATE TABLE t1;
313 Table Create Table
314 t1 CREATE TABLE `t1` (
315 `a` blob DEFAULT NULL,
316 `b` blob DEFAULT NULL,
317 `c` blob DEFAULT NULL,
318 `d` blob DEFAULT NULL,
319 `e` blob DEFAULT NULL,
320 `f` blob DEFAULT NULL,
321 `g` blob DEFAULT NULL,
322 `h` blob DEFAULT NULL,
323 `i` blob DEFAULT NULL,
324 `j` blob DEFAULT NULL,
325 `k` blob DEFAULT NULL,
326 `l` blob DEFAULT NULL,
327 `m` blob DEFAULT NULL,
328 `n` blob DEFAULT NULL,
329 `o` blob DEFAULT NULL,
330 `p` blob DEFAULT NULL,
331 `q` blob DEFAULT NULL,
332 `r` blob DEFAULT NULL,
333 `s` blob DEFAULT NULL,
334 `t` blob DEFAULT NULL,
335 `u` blob DEFAULT NULL,
336 KEY `t1a` (`a`(767)),
337 KEY `t1b` (`b`(767)),
338 KEY `t1c` (`c`(767)),
339 KEY `t1d` (`d`(767)),
340 KEY `t1e` (`e`(767)),
341 KEY `t1f` (`f`(767)),
342 KEY `t1g` (`g`(767)),
343 KEY `t1h` (`h`(767)),
344 KEY `t1i` (`i`(767)),
345 KEY `t1j` (`j`(767)),
346 KEY `t1k` (`k`(767)),
347 KEY `t1l` (`l`(767)),
348 KEY `t1m` (`m`(767)),
349 KEY `t1n` (`n`(767)),
350 KEY `t1o` (`o`(767)),
351 KEY `t1p` (`p`(767)),
352 KEY `t1q` (`q`(767)),
353 KEY `t1r` (`r`(767)),
354 KEY `t1s` (`s`(767)),
355 KEY `t1t` (`t`(767))
356 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
357 DROP TABLE t1;
358 Test an assertion failure on purge.
359 CREATE TABLE t1_purge (
360 A int,
361 B blob, C blob, D blob, E blob,
362 F blob, G blob, H blob,
363 PRIMARY KEY (B(767), C(767), D(767), E(767), A),
364 INDEX (A)
365 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
366 INSERT INTO t1_purge VALUES (1,
367 REPEAT('b', 766), REPEAT('c', 766), REPEAT('d', 766), REPEAT('e', 766),
368 REPEAT('f', 766), REPEAT('g', 766), REPEAT('h', 766));
369 CREATE TABLE t2_purge (
370 A int PRIMARY KEY,
371 B blob, C blob, D blob, E blob,
372 F blob, G blob, H blob, I blob,
373 J blob, K blob, L blob,
374 INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
375 INSERT INTO t2_purge VALUES (1,
376 REPEAT('b', 766), REPEAT('c', 766), REPEAT('d', 766), REPEAT('e', 766),
377 REPEAT('f', 766), REPEAT('g', 766), REPEAT('h', 766), REPEAT('i', 766),
378 REPEAT('j', 766), REPEAT('k', 766), REPEAT('l', 766));
379 CREATE TABLE t3_purge (
380 A int,
381 B varchar(800), C varchar(800), D varchar(800), E varchar(800),
382 F varchar(800), G varchar(800), H varchar(800),
383 PRIMARY KEY (B(767), C(767), D(767), E(767), A),
384 INDEX (A)
385 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
386 INSERT INTO t3_purge SELECT * FROM t1_purge;
387 CREATE TABLE t4_purge (
388 A int PRIMARY KEY,
389 B varchar(800), C varchar(800), D varchar(800), E varchar(800),
390 F varchar(800), G varchar(800), H varchar(800), I varchar(800),
391 J varchar(800), K varchar(800), L varchar(800),
392 INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
393 INSERT INTO t4_purge SELECT * FROM t2_purge;
394 DELETE FROM t1_purge;
395 DELETE FROM t2_purge;
396 DELETE FROM t3_purge;
397 DELETE FROM t4_purge;
398 SET @r=REPEAT('a',500);
399 CREATE TABLE tlong(a int,
400 v1 varchar(500), v2 varchar(500), v3 varchar(500),
401 v4 varchar(500), v5 varchar(500), v6 varchar(500),
402 v7 varchar(500), v8 varchar(500), v9 varchar(500),
403 v10 varchar(500), v11 varchar(500), v12 varchar(500),
404 v13 varchar(500), v14 varchar(500), v15 varchar(500),
405 v16 varchar(500), v17 varchar(500), v18 varchar(500)
406 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
407 CREATE INDEX idx1 ON tlong(a,v1);
408 INSERT INTO tlong VALUES(9,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
409 UPDATE tlong SET a=1000;
410 DELETE FROM tlong;
411 CREATE TABLE tlong2(a blob,b blob,c blob,d blob,e blob,f blob,g blob,h blob,
412 i blob,j blob,k blob,l blob,m blob,n blob,o blob,p blob)
413 ENGINE=innodb ROW_FORMAT=dynamic;
414 SET @r = REPEAT('a', 767);
415 INSERT INTO tlong2 VALUES (@r,@r,@r,@r, @r,@r,@r,@r, @r,@r,@r,@r, @r,@r,@r,@r);
416 CREATE INDEX ndx_a ON tlong2 (a(500));
417 CREATE INDEX ndx_b ON tlong2 (b(500));
418 CREATE INDEX ndx_c ON tlong2 (c(500));
419 CREATE INDEX ndx_d ON tlong2 (d(500));
420 CREATE INDEX ndx_e ON tlong2 (e(500));
421 CREATE INDEX ndx_f ON tlong2 (f(500));
422 CREATE INDEX ndx_k ON tlong2 (k(500));
423 CREATE INDEX ndx_l ON tlong2 (l(500));
424 SET @r = REPEAT('b', 500);
425 UPDATE tlong2 set a=@r,b=@r,c=@r,d=@r;
426 UPDATE tlong2 set e=@r,f=@r,g=@r,h=@r;
427 UPDATE tlong2 set i=@r,j=@r,k=@r,l=@r;
428 UPDATE tlong2 set m=@r,n=@r,o=@r,p=@r;
429 ALTER TABLE tlong2 DROP INDEX ndx_a;
430 ALTER TABLE tlong2 DROP INDEX ndx_b;
431 CREATE INDEX ndx_g ON tlong2 (g(500));
432 CREATE INDEX ndx_h ON tlong2 (h(500));
433 CREATE INDEX ndx_i ON tlong2 (i(500));
434 CREATE INDEX ndx_j ON tlong2 (j(500));
435 CREATE INDEX ndx_m ON tlong2 (m(500));
436 CREATE INDEX ndx_n ON tlong2 (n(500));
437 CREATE INDEX ndx_o ON tlong2 (o(500));
438 CREATE INDEX ndx_p ON tlong2 (p(500));
439 SHOW CREATE TABLE tlong2;
440 Table Create Table
441 tlong2 CREATE TABLE `tlong2` (
442 `a` blob DEFAULT NULL,
443 `b` blob DEFAULT NULL,
444 `c` blob DEFAULT NULL,
445 `d` blob DEFAULT NULL,
446 `e` blob DEFAULT NULL,
447 `f` blob DEFAULT NULL,
448 `g` blob DEFAULT NULL,
449 `h` blob DEFAULT NULL,
450 `i` blob DEFAULT NULL,
451 `j` blob DEFAULT NULL,
452 `k` blob DEFAULT NULL,
453 `l` blob DEFAULT NULL,
454 `m` blob DEFAULT NULL,
455 `n` blob DEFAULT NULL,
456 `o` blob DEFAULT NULL,
457 `p` blob DEFAULT NULL,
458 KEY `ndx_c` (`c`(500)),
459 KEY `ndx_d` (`d`(500)),
460 KEY `ndx_e` (`e`(500)),
461 KEY `ndx_f` (`f`(500)),
462 KEY `ndx_k` (`k`(500)),
463 KEY `ndx_l` (`l`(500)),
464 KEY `ndx_g` (`g`(500)),
465 KEY `ndx_h` (`h`(500)),
466 KEY `ndx_i` (`i`(500)),
467 KEY `ndx_j` (`j`(500)),
468 KEY `ndx_m` (`m`(500)),
469 KEY `ndx_n` (`n`(500)),
470 KEY `ndx_o` (`o`(500)),
471 KEY `ndx_p` (`p`(500))
472 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
473 SET SESSION innodb_strict_mode = ON;
474 CREATE TABLE bug12547647(
475 a int NOT NULL, b blob NOT NULL, c text,
476 PRIMARY KEY (b(10), a), INDEX (c(767)), INDEX(b(767))
477 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
478 INSERT INTO bug12547647 VALUES (5,REPEAT('khdfo5AlOq',1900),REPEAT('g',7751));
479 COMMIT;
480 BEGIN;
481 UPDATE bug12547647 SET c = REPEAT('b',16928);
482 SHOW WARNINGS;
483 Level Code Message
484 ROLLBACK;
485 DROP TABLE bug12547647;
486 SET SESSION innodb_strict_mode = on;
487 CREATE TABLE t1(
488 c text NOT NULL, d text NOT NULL,
489 PRIMARY KEY (c(767),d(767)))
490 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
491 ERROR 42000: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
492 CREATE TABLE t1(
493 c text NOT NULL, d text NOT NULL,
494 PRIMARY KEY (c(767),d(767)))
495 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 CHARSET=ASCII;
496 ERROR 42000: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
497 CREATE TABLE t1(
498 c text NOT NULL, d text NOT NULL,
499 PRIMARY KEY (c(767),d(767)))
500 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 CHARSET=ASCII;
501 drop table t1;
502 CREATE TABLE t1(c text, PRIMARY KEY (c(440)))
503 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
504 ERROR 42000: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
505 CREATE TABLE t1(c text, PRIMARY KEY (c(292)))
506 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
507 INSERT INTO t1 VALUES(REPEAT('A',512)),(REPEAT('B',512));
508 DROP TABLE t1;
509 InnoDB 0 transactions not purged
510 SET GLOBAL innodb_compression_level=@save_level;
511 SET GLOBAL innodb_stats_persistent = @save_stats_persistent;
512 DROP TABLE t1_purge, t2_purge, t3_purge, t4_purge;
513 DROP TABLE tlong;
514 DROP TABLE tlong2;
515 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;