Debian Codegraph @

mysql-test/suite/innodb_zip/r/8k.result

raw
1 SET default_storage_engine=InnoDB;
2 # Test 1) Show the page size from Information Schema
3 SELECT variable_value FROM performance_schema.global_status
4 WHERE LOWER(variable_name) = 'innodb_page_size';
5 variable_value
6 8192
7 # Test 2) The number of buffer pool pages is dependent upon the page size.
8 SELECT variable_value FROM performance_schema.global_status
9 WHERE LOWER(variable_name) = 'innodb_buffer_pool_pages_total';
10 variable_value
11 {checked_valid}
12 # Test 3) Query some information_shema tables that are dependent upon
13 # the page size.
14 SELECT t.name table_name, t.n_cols, t.flag table_flags,
15 i.name index_name, i.page_no root_page, i.type,
16 i.n_fields, i.merge_threshold
17 FROM INFORMATION_SCHEMA.INNODB_TABLES t,
18 INFORMATION_SCHEMA.INNODB_INDEXES i
19 WHERE t.table_id = i.table_id
20 AND t.name LIKE 'mysql%'
21 AND t.name NOT LIKE 'mysql/ndb_binlog_index'
22 ORDER BY t.name, i.index_id;
23 table_name n_cols table_flags index_name root_page type n_fields merge_threshold
24 CREATE TABLE t1 (a INT KEY, b TEXT) ROW_FORMAT=REDUNDANT ENGINE=innodb;
25 CREATE TABLE t2 (a INT KEY, b TEXT) ROW_FORMAT=COMPACT ENGINE=innodb;
26 CREATE TABLE t3 (a INT KEY, b TEXT) ROW_FORMAT=COMPRESSED ENGINE=innodb;
27 CREATE TABLE t4 (a INT KEY, b TEXT) ROW_FORMAT=DYNAMIC ENGINE=innodb;
28 SELECT t.name table_name, t.n_cols, t.flag table_flags,
29 i.name index_name, i.page_no root_page, i.type,
30 i.n_fields, i.merge_threshold
31 FROM INFORMATION_SCHEMA.INNODB_TABLES t,
32 INFORMATION_SCHEMA.INNODB_INDEXES i
33 WHERE t.table_id = i.table_id
34 AND t.name LIKE 'test%'
35 ORDER BY t.name, i.name;
36 table_name n_cols table_flags index_name root_page type n_fields merge_threshold
37 test/t1 5 0 PRIMARY 4 3 4 50
38 test/t2 5 1 PRIMARY 4 3 4 50
39 test/t3 5 39 PRIMARY 4 3 4 50
40 test/t4 5 33 PRIMARY 4 3 4 50
41 === information_schema.innodb_tablespaces and innodb_datafiles ===
42 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
43 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
44 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
45 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
46 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
47 test/t1 Single DEFAULT 0 1 1 Compact or Redundant MYSQLD_DATADIR/test/t1.ibd
48 test/t2 Single DEFAULT 0 1 1 Compact or Redundant MYSQLD_DATADIR/test/t2.ibd
49 test/t3 Single DEFAULT 4096 1 1 Compressed MYSQLD_DATADIR/test/t3.ibd
50 test/t4 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t4.ibd
51 === information_schema.files ===
52 Space_Name File_Type Engine Status Tablespace_Name Path
53 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
54 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
55 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
56 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
57 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
58 test/t2 TABLESPACE InnoDB NORMAL test/t2 MYSQLD_DATADIR/test/t2.ibd
59 test/t3 TABLESPACE InnoDB NORMAL test/t3 MYSQLD_DATADIR/test/t3.ibd
60 test/t4 TABLESPACE InnoDB NORMAL test/t4 MYSQLD_DATADIR/test/t4.ibd
61 DROP TABLE t1, t2, t3, t4;
62 # Test 4) The maximum row size is dependent upon the page size.
63 # Redundant: 4027, Compact: 4030.
64 # Compressed: 4030, Dynamic: 4030.
65 # Each row format has its own amount of overhead that
66 # varies depending on number of fields and other overhead.
67 SET SESSION innodb_strict_mode = ON;
68 CREATE TABLE t1 (
69 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
70 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
71 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
72 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(155)
73 ) charset latin1 ROW_FORMAT=redundant;
74 DROP TABLE t1;
75 CREATE TABLE t1 (
76 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
77 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
78 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
79 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(156)
80 ) charset latin1 ROW_FORMAT=redundant;
81 ERROR 42000: Row size too large (> max_row_size). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
82 CREATE TABLE t1 (
83 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
84 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
85 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
86 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(202)
87 ) charset latin1 ROW_FORMAT=compact;
88 DROP TABLE t1;
89 CREATE TABLE t1 (
90 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
91 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
92 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
93 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(203)
94 ) charset latin1 ROW_FORMAT=compact;
95 ERROR 42000: Row size too large (> max_row_size). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
96 CREATE TABLE t1 (
97 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
98 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
99 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
100 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(103)
101 ) ROW_FORMAT=compressed;
102 DROP TABLE t1;
103 CREATE TABLE t1 (
104 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
105 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
106 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
107 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(106)
108 ) charset latin1 ROW_FORMAT=compressed;
109 ERROR 42000: Row size too large (> max_row_size). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
110 CREATE TABLE t1 (
111 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
112 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
113 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
114 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(202)
115 ) ROW_FORMAT=dynamic;
116 DROP TABLE t1;
117 CREATE TABLE t1 (
118 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
119 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
120 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
121 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(203)
122 ) charset latin1 ROW_FORMAT=dynamic;
123 ERROR 42000: Row size too large (> max_row_size). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
124 CREATE TABLE t1 (a varchar(128) character set utf8,
125 b varchar(128) character set utf8,
126 c varchar(128) character set utf8,
127 d varchar(128) character set utf8,
128 PRIMARY KEY (a,b,c,d))
129 charset latin1
130 ENGINE=innodb;
131 Warnings:
132 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
133 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
134 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
135 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
136 DROP TABLE t1;
137 CREATE TABLE t1 (a varchar(128) character set utf8,
138 b varchar(128) character set utf8,
139 c varchar(128) character set utf8,
140 d varchar(129) character set utf8,
141 PRIMARY KEY (a,b,c,d))
142 charset latin1
143 ENGINE=innodb;
144 ERROR 42000: Specified key was too long; max key length is 1536 bytes
145 CREATE TABLE t1 (a varchar(128) character set utf8,
146 b varchar(128) character set utf8,
147 c varchar(128) character set utf8,
148 d varchar(128) character set utf8,
149 e varchar(128) character set utf8,
150 PRIMARY KEY (a), KEY (b,c,d,e))
151 charset latin1
152 ENGINE=innodb;
153 Warnings:
154 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
155 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
156 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
157 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
158 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
159 DROP TABLE t1;
160 CREATE TABLE t1 (a varchar(128) character set utf8,
161 b varchar(128) character set utf8,
162 c varchar(128) character set utf8,
163 d varchar(128) character set utf8,
164 e varchar(129) character set utf8,
165 PRIMARY KEY (a), KEY (b,c,d,e))
166 charset latin1
167 ENGINE=innodb;
168 ERROR 42000: Specified key was too long; max key length is 1536 bytes
169 # Test 5) Make sure that KEY_BLOCK_SIZE=8, 4, 2 & 1 are all
170 # accepted and that KEY_BLOCK_SIZE=16 is rejected in
171 # strict mode and converted to 8 in non-strict mode.
172 SET SESSION innodb_strict_mode = ON;
173 CREATE TABLE t1 (i int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
174 ERROR HY000: Table storage engine for 't1' doesn't have this option
175 SHOW WARNINGS;
176 Level Code Message
177 Warning 1478 InnoDB: KEY_BLOCK_SIZE=16 cannot be larger than 8.
178 Error 1031 Table storage engine for 't1' doesn't have this option
179 CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
180 SHOW WARNINGS;
181 Level Code Message
182 SELECT table_name, row_format, create_options
183 FROM information_schema.tables WHERE table_name = 't1';
184 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
185 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=8
186 ALTER TABLE t1 KEY_BLOCK_SIZE=4;
187 SHOW WARNINGS;
188 Level Code Message
189 SELECT table_name, row_format, create_options
190 FROM information_schema.tables WHERE table_name = 't1';
191 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
192 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=4
193 ALTER TABLE t1 KEY_BLOCK_SIZE=2;
194 SHOW WARNINGS;
195 Level Code Message
196 SELECT table_name, row_format, create_options
197 FROM information_schema.tables WHERE table_name = 't1';
198 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
199 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=2
200 ALTER TABLE t1 KEY_BLOCK_SIZE=1;
201 SHOW WARNINGS;
202 Level Code Message
203 SELECT table_name, row_format, create_options
204 FROM information_schema.tables WHERE table_name = 't1';
205 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
206 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=1
207 ALTER TABLE t1 KEY_BLOCK_SIZE=0;
208 SHOW WARNINGS;
209 Level Code Message
210 SELECT table_name, row_format, create_options
211 FROM information_schema.tables WHERE table_name = 't1';
212 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
213 t1 Compressed row_format=COMPRESSED
214 DROP TABLE t1;
215 SET SESSION innodb_strict_mode = OFF;
216 CREATE TABLE t1 (i int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
217 Warnings:
218 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16.
219 SHOW WARNINGS;
220 Level Code Message
221 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16.
222 SELECT table_name, row_format, create_options
223 FROM information_schema.tables WHERE table_name = 't1';
224 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
225 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=4
226 DROP TABLE t1;
227 CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
228 SHOW WARNINGS;
229 Level Code Message
230 SELECT table_name, row_format, create_options
231 FROM information_schema.tables WHERE table_name = 't1';
232 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
233 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=8
234 DROP TABLE t1;
235 CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
236 SHOW WARNINGS;
237 Level Code Message
238 SELECT table_name, row_format, create_options
239 FROM information_schema.tables WHERE table_name = 't1';
240 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
241 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=4
242 ALTER TABLE t1 KEY_BLOCK_SIZE=2;
243 SHOW WARNINGS;
244 Level Code Message
245 SELECT table_name, row_format, create_options
246 FROM information_schema.tables WHERE table_name = 't1';
247 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
248 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=2
249 ALTER TABLE t1 KEY_BLOCK_SIZE=1;
250 SHOW WARNINGS;
251 Level Code Message
252 SELECT table_name, row_format, create_options
253 FROM information_schema.tables WHERE table_name = 't1';
254 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
255 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=1
256 ALTER TABLE t1 KEY_BLOCK_SIZE=0;
257 SHOW WARNINGS;
258 Level Code Message
259 SELECT table_name, row_format, create_options
260 FROM information_schema.tables WHERE table_name = 't1';
261 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
262 t1 Compressed row_format=COMPRESSED
263 DROP TABLE t1;
264 # Test 6) Make sure that KEY_BLOCK_SIZE = 8 and 16
265 # are rejected when innodb_file_per_table=OFF
266 SET SESSION innodb_strict_mode = ON;
267 SET GLOBAL innodb_file_per_table = OFF;
268 SHOW VARIABLES LIKE 'innodb_file_per_table';
269 Variable_name Value
270 innodb_file_per_table OFF
271 CREATE TABLE t4 (id int PRIMARY KEY) ENGINE=innodb KEY_BLOCK_SIZE=8;
272 ERROR HY000: Table storage engine for 't4' doesn't have this option
273 SHOW WARNINGS;
274 Level Code Message
275 Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table.
276 Error 1031 Table storage engine for 't4' doesn't have this option
277 CREATE TABLE t5 (id int PRIMARY KEY) ENGINE=innodb KEY_BLOCK_SIZE=16;
278 ERROR HY000: Table storage engine for 't5' doesn't have this option
279 SHOW WARNINGS;
280 Level Code Message
281 Warning 1478 InnoDB: KEY_BLOCK_SIZE=16 cannot be larger than 8.
282 Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table.
283 Error 1031 Table storage engine for 't5' doesn't have this option
284 SET GLOBAL innodb_file_per_table = ON;
285 CREATE TABLE t4 (id int PRIMARY KEY) ENGINE=innodb KEY_BLOCK_SIZE=8;
286 SHOW WARNINGS;
287 Level Code Message
288 DROP TABLE t4;
289 CREATE TABLE t5 (id int PRIMARY KEY) ENGINE=innodb KEY_BLOCK_SIZE=16;
290 ERROR HY000: Table storage engine for 't5' doesn't have this option
291 SHOW WARNINGS;
292 Level Code Message
293 Warning 1478 InnoDB: KEY_BLOCK_SIZE=16 cannot be larger than 8.
294 Error 1031 Table storage engine for 't5' doesn't have this option
295 # Test 7) Not included here; 16k only
296 # Test 8) Test creating a table that could lead to undo log overflow.
297 CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
298 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
299 o blob,p blob,q blob,r blob,s blob,t blob,u blob)
300 ENGINE=InnoDB ROW_FORMAT=dynamic;
301 SET @a = repeat('a', 767);
302 SET @b = repeat('b', 767);
303 SET @c = repeat('c', 767);
304 SET @d = repeat('d', 767);
305 SET @e = repeat('e', 767);
306 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);
307 UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
308 k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b;
309 CREATE INDEX t1a ON t1 (a(767));
310 CREATE INDEX t1b ON t1 (b(767));
311 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
312 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c;
313 CREATE INDEX t1c ON t1 (c(767));
314 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d,f=@d,g=@d,h=@d,i=@d,j=@d,
315 k=@d,l=@d,m=@d,n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
316 ERROR HY000: Undo log record is too big.
317 BEGIN;
318 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
319 UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d,k=@d,l=@d,m=@d,
320 n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
321 COMMIT;
322 CREATE INDEX t1d ON t1 (d(767));
323 UPDATE t1 SET d=@e;
324 CREATE INDEX t1e ON t1 (e(767));
325 UPDATE t1 SET e=@e;
326 CREATE INDEX t1f ON t1 (f(767));
327 UPDATE t1 SET f=@e;
328 CREATE INDEX t1g ON t1 (g(767));
329 UPDATE t1 SET g=@e;
330 CREATE INDEX t1h ON t1 (h(767));
331 UPDATE t1 SET h=@e;
332 CREATE INDEX t1i ON t1 (i(767));
333 UPDATE t1 SET i=@e;
334 CREATE INDEX t1k ON t1 (j(767));
335 CREATE INDEX t1j ON t1 (j(500));
336 UPDATE t1 SET j=@e;
337 ERROR HY000: Undo log record is too big.
338 SHOW CREATE TABLE t1;
339 Table Create Table
340 t1 CREATE TABLE `t1` (
341 `a` blob,
342 `b` blob,
343 `c` blob,
344 `d` blob,
345 `e` blob,
346 `f` blob,
347 `g` blob,
348 `h` blob,
349 `i` blob,
350 `j` blob,
351 `k` blob,
352 `l` blob,
353 `m` blob,
354 `n` blob,
355 `o` blob,
356 `p` blob,
357 `q` blob,
358 `r` blob,
359 `s` blob,
360 `t` blob,
361 `u` blob,
362 KEY `t1a` (`a`(767)),
363 KEY `t1b` (`b`(767)),
364 KEY `t1c` (`c`(767)),
365 KEY `t1d` (`d`(767)),
366 KEY `t1e` (`e`(767)),
367 KEY `t1f` (`f`(767)),
368 KEY `t1g` (`g`(767)),
369 KEY `t1h` (`h`(767)),
370 KEY `t1i` (`i`(767)),
371 KEY `t1k` (`j`(767)),
372 KEY `t1j` (`j`(500))
373 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
374 DROP TABLE t1;
375 SET SESSION innodb_strict_mode = OFF;
376 CREATE TABLE t1(
377 pk01 varchar(96), pk02 varchar(96), pk03 varchar(96), pk04 varchar(96),
378 pk05 varchar(96), pk06 varchar(96), pk07 varchar(96), pk08 varchar(96),
379 pk09 varchar(96), pk10 varchar(96), pk11 varchar(96), pk12 varchar(96),
380 pk13 varchar(96), pk14 varchar(96), pk15 varchar(96), pk16 varchar(96),
381 sk01 varchar(96), sk02 varchar(96), sk03 varchar(96), sk04 varchar(96),
382 sk05 varchar(96), sk06 varchar(96), sk07 varchar(96), sk08 varchar(96),
383 sk09 varchar(96), sk10 varchar(96), sk11 varchar(96), sk12 varchar(96),
384 sk13 varchar(96), sk14 varchar(96), sk15 varchar(96), sk16 varchar(96),
385 PRIMARY KEY pk(pk01,pk02,pk03,pk04,pk05,pk06,pk07,pk08,
386 pk09,pk10,pk11,pk12,pk13,pk14,pk15,pk16),
387 KEY pk(sk01,sk02,sk03,sk04,sk05,sk06,sk07,sk08,
388 sk09,sk10,sk11,sk12,sk13,sk14,sk15,sk16))
389 charset latin1
390 ROW_FORMAT=Redundant ENGINE=InnoDB;
391 SET @r = repeat('a', 96);
392 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
393 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
394 SET @r = repeat('b', 96);
395 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
396 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
397 SET @r = repeat('c', 96);
398 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
399 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
400 SET @r = repeat('d', 96);
401 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
402 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
403 SET @r = repeat('e', 96);
404 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
405 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
406 DELETE from t1;
407 DROP TABLE t1;
408 CREATE TABLE t1(
409 pk01 varchar(96), pk02 varchar(96), pk03 varchar(96), pk04 varchar(96),
410 pk05 varchar(96), pk06 varchar(96), pk07 varchar(96), pk08 varchar(96),
411 pk09 varchar(96), pk10 varchar(96), pk11 varchar(96), pk12 varchar(96),
412 pk13 varchar(96), pk14 varchar(96), pk15 varchar(96), pk16 varchar(96),
413 sk01 varchar(96), sk02 varchar(96), sk03 varchar(96), sk04 varchar(96),
414 sk05 varchar(96), sk06 varchar(96), sk07 varchar(96), sk08 varchar(96),
415 sk09 varchar(96), sk10 varchar(96), sk11 varchar(96), sk12 varchar(96),
416 sk13 varchar(96), sk14 varchar(96), sk15 varchar(96), sk16 varchar(96),
417 PRIMARY KEY pk(pk01,pk02,pk03,pk04,pk05,pk06,pk07,pk08,
418 pk09,pk10,pk11,pk12,pk13,pk14,pk15,pk16),
419 KEY pk(sk01,sk02,sk03,sk04,sk05,sk06,sk07,sk08,
420 sk09,sk10,sk11,sk12,sk13,sk14,sk15,sk16))
421 charset latin1
422 ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 ENGINE=InnoDB;
423 SET @r = repeat('a', 96);
424 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
425 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
426 SET @r = repeat('b', 96);
427 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
428 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
429 SET @r = repeat('c', 96);
430 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
431 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
432 SET @r = repeat('d', 96);
433 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
434 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
435 SET @r = repeat('e', 96);
436 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
437 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
438 DELETE from t1;
439 DROP TABLE t1;
440 SET SESSION innodb_strict_mode = off;
441 CREATE TABLE t1(
442 c text NOT NULL, d text NOT NULL,
443 PRIMARY KEY (c(767),d(767)))
444 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
445 Warnings:
446 Warning 139 Row size too large (> max_row_size). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
447 DROP TABLE t1;
448 CREATE TABLE t1(
449 c text NOT NULL, d text NOT NULL,
450 PRIMARY KEY (c(767),d(767)))
451 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 CHARSET=ASCII;
452 Warnings:
453 Warning 139 Row size too large (> max_row_size). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
454 DROP TABLE t1;
455 CREATE TABLE t1(
456 c text NOT NULL, d text NOT NULL,
457 PRIMARY KEY (c(767),d(767)))
458 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 CHARSET=ASCII;
459 drop table t1;
460 CREATE TABLE t1(c text, PRIMARY KEY (c(440)))
461 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
462 Warnings:
463 Warning 139 Row size too large (> max_row_size). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
464 DROP TABLE t1;
465 CREATE TABLE t1(c text, PRIMARY KEY (c(438)))
466 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
467 INSERT INTO t1 VALUES(REPEAT('A',512)),(REPEAT('B',512));
468 DROP TABLE t1;