Debian Codegraph @

mysql-test/suite/innodb_zip/r/4k.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 4096
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 37 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 2048 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: 1979, Compact: 1982.
64 # Compressed: 1982, Dynamic: 1982.
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(127)
71 ) charset latin1 ROW_FORMAT=redundant;
72 DROP TABLE t1;
73 CREATE TABLE t1 (
74 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
75 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(128)
76 ) charset latin1 ROW_FORMAT=redundant;
77 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.
78 CREATE TABLE t1 (
79 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
80 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(155)
81 ) charset latin1 ROW_FORMAT=compact;
82 DROP TABLE t1;
83 CREATE TABLE t1 (
84 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
85 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(156)
86 ) charset latin1 ROW_FORMAT=compact;
87 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.
88 CREATE TABLE t1 (
89 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
90 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(76)
91 ) ROW_FORMAT=compressed;
92 DROP TABLE t1;
93 CREATE TABLE t1 (
94 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
95 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(79)
96 ) charset latin1 ROW_FORMAT=compressed;
97 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.
98 CREATE TABLE t1 (
99 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
100 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(155)
101 ) ROW_FORMAT=dynamic;
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(156)
106 ) charset latin1 ROW_FORMAT=dynamic;
107 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.
108 CREATE TABLE t1 (a varchar(64) character set utf8,
109 b varchar(64) character set utf8,
110 c varchar(64) character set utf8,
111 d varchar(64) character set utf8,
112 PRIMARY KEY (a,b,c,d))
113 charset latin1
114 ENGINE=innodb;
115 Warnings:
116 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.
117 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.
118 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.
119 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.
120 DROP TABLE t1;
121 CREATE TABLE t1 (a varchar(64) character set utf8,
122 b varchar(64) character set utf8,
123 c varchar(64) character set utf8,
124 d varchar(65) character set utf8,
125 PRIMARY KEY (a,b,c,d))
126 charset latin1
127 ENGINE=innodb;
128 ERROR 42000: Specified key was too long; max key length is 768 bytes
129 CREATE TABLE t1 (a varchar(64) character set utf8,
130 b varchar(64) character set utf8,
131 c varchar(64) character set utf8,
132 d varchar(64) character set utf8,
133 e varchar(64) character set utf8,
134 PRIMARY KEY (a), KEY (b,c,d,e))
135 charset latin1
136 ENGINE=innodb;
137 Warnings:
138 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.
139 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.
140 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.
141 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.
142 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.
143 DROP TABLE t1;
144 CREATE TABLE t1 (a varchar(64) character set utf8,
145 b varchar(64) character set utf8,
146 c varchar(64) character set utf8,
147 d varchar(64) character set utf8,
148 e varchar(65) character set utf8,
149 PRIMARY KEY (a), KEY (b,c,d,e))
150 charset latin1
151 ENGINE=innodb;
152 ERROR 42000: Specified key was too long; max key length is 768 bytes
153 # Test 5) Make sure that KEY_BLOCK_SIZE=4, 2 & 1 are all
154 # accepted and that KEY_BLOCK_SIZE=16 & 8 are rejected
155 # in strict mode and converted to 4 in non-strict mode.
156 SET SESSION innodb_strict_mode = ON;
157 CREATE TABLE t1 (i int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
158 ERROR HY000: Table storage engine for 't1' doesn't have this option
159 SHOW WARNINGS;
160 Level Code Message
161 Warning 1478 InnoDB: KEY_BLOCK_SIZE=16 cannot be larger than 4.
162 Error 1031 Table storage engine for 't1' doesn't have this option
163 CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
164 ERROR HY000: Table storage engine for 't1' doesn't have this option
165 SHOW WARNINGS;
166 Level Code Message
167 Warning 1478 InnoDB: KEY_BLOCK_SIZE=8 cannot be larger than 4.
168 Error 1031 Table storage engine for 't1' doesn't have this option
169 CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
170 SHOW WARNINGS;
171 Level Code Message
172 SELECT table_name, row_format, create_options
173 FROM information_schema.tables WHERE table_name = 't1';
174 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
175 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=4
176 ALTER TABLE t1 KEY_BLOCK_SIZE=2;
177 SHOW WARNINGS;
178 Level Code Message
179 SELECT table_name, row_format, create_options
180 FROM information_schema.tables WHERE table_name = 't1';
181 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
182 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=2
183 ALTER TABLE t1 KEY_BLOCK_SIZE=1;
184 SHOW WARNINGS;
185 Level Code Message
186 SELECT table_name, row_format, create_options
187 FROM information_schema.tables WHERE table_name = 't1';
188 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
189 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=1
190 ALTER TABLE t1 KEY_BLOCK_SIZE=0;
191 SHOW WARNINGS;
192 Level Code Message
193 SELECT table_name, row_format, create_options
194 FROM information_schema.tables WHERE table_name = 't1';
195 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
196 t1 Compressed row_format=COMPRESSED
197 DROP TABLE t1;
198 SET SESSION innodb_strict_mode = OFF;
199 CREATE TABLE t1 (i int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
200 Warnings:
201 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16.
202 SHOW WARNINGS;
203 Level Code Message
204 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16.
205 SELECT table_name, row_format, create_options
206 FROM information_schema.tables WHERE table_name = 't1';
207 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
208 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=2
209 DROP TABLE t1;
210 CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
211 Warnings:
212 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=8.
213 SHOW WARNINGS;
214 Level Code Message
215 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=8.
216 SELECT table_name, row_format, create_options
217 FROM information_schema.tables WHERE table_name = 't1';
218 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
219 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=2
220 DROP TABLE t1;
221 CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
222 SHOW WARNINGS;
223 Level Code Message
224 SELECT table_name, row_format, create_options
225 FROM information_schema.tables WHERE table_name = 't1';
226 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
227 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=4
228 ALTER TABLE t1 KEY_BLOCK_SIZE=2;
229 SHOW WARNINGS;
230 Level Code Message
231 SELECT table_name, row_format, create_options
232 FROM information_schema.tables WHERE table_name = 't1';
233 TABLE_NAME ROW_FORMAT CREATE_OPTIONS
234 t1 Compressed row_format=COMPRESSED KEY_BLOCK_SIZE=2
235 ALTER TABLE t1 KEY_BLOCK_SIZE=1;
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=1
242 ALTER TABLE t1 KEY_BLOCK_SIZE=0;
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
249 DROP TABLE t1;
250 # Test 6) Make sure that KEY_BLOCK_SIZE = 8 and 16
251 # are both rejected when innodb_file_per_table=OFF
252 SET SESSION innodb_strict_mode = ON;
253 SET GLOBAL innodb_file_per_table = OFF;
254 SHOW VARIABLES LIKE 'innodb_file_per_table';
255 Variable_name Value
256 innodb_file_per_table OFF
257 CREATE TABLE t4 (id int PRIMARY KEY) ENGINE=innodb KEY_BLOCK_SIZE=8;
258 ERROR HY000: Table storage engine for 't4' doesn't have this option
259 SHOW WARNINGS;
260 Level Code Message
261 Warning 1478 InnoDB: KEY_BLOCK_SIZE=8 cannot be larger than 4.
262 Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table.
263 Error 1031 Table storage engine for 't4' doesn't have this option
264 CREATE TABLE t5 (id int PRIMARY KEY) ENGINE=innodb KEY_BLOCK_SIZE=16;
265 ERROR HY000: Table storage engine for 't5' doesn't have this option
266 SHOW WARNINGS;
267 Level Code Message
268 Warning 1478 InnoDB: KEY_BLOCK_SIZE=16 cannot be larger than 4.
269 Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table.
270 Error 1031 Table storage engine for 't5' doesn't have this option
271 SET GLOBAL innodb_file_per_table = ON;
272 CREATE TABLE t4 (id int PRIMARY KEY) ENGINE=innodb KEY_BLOCK_SIZE=8;
273 ERROR HY000: Table storage engine for 't4' doesn't have this option
274 SHOW WARNINGS;
275 Level Code Message
276 Warning 1478 InnoDB: KEY_BLOCK_SIZE=8 cannot be larger than 4.
277 Error 1031 Table storage engine for 't4' doesn't have this option
278 CREATE TABLE t5 (id int PRIMARY KEY) ENGINE=innodb KEY_BLOCK_SIZE=16;
279 ERROR HY000: Table storage engine for 't5' doesn't have this option
280 SHOW WARNINGS;
281 Level Code Message
282 Warning 1478 InnoDB: KEY_BLOCK_SIZE=16 cannot be larger than 4.
283 Error 1031 Table storage engine for 't5' doesn't have this option
284 # Test 7) Not included here; 16k only
285 # Test 8) Test creating a table that could lead to undo log overflow.
286 CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
287 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
288 o blob,p blob,q blob,r blob,s blob,t blob,u blob)
289 ENGINE=InnoDB ROW_FORMAT=dynamic;
290 SET @a = repeat('a', 767);
291 SET @b = repeat('b', 767);
292 SET @c = repeat('c', 767);
293 SET @d = repeat('d', 767);
294 SET @e = repeat('e', 767);
295 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);
296 UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
297 k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b;
298 CREATE INDEX t1a ON t1 (a(767));
299 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
300 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c;
301 CREATE INDEX t1b ON t1 (b(767));
302 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d,f=@d,g=@d,h=@d,i=@d,j=@d,
303 k=@d,l=@d,m=@d,n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
304 ERROR HY000: Undo log record is too big.
305 BEGIN;
306 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
307 UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d,k=@d,l=@d,m=@d,
308 n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
309 COMMIT;
310 CREATE INDEX t1c ON t1 (c(767));
311 UPDATE t1 SET c=@e;
312 CREATE INDEX t1d ON t1 (d(767));
313 CREATE INDEX t1e ON t1 (e(767));
314 SHOW CREATE TABLE t1;
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `a` blob,
318 `b` blob,
319 `c` blob,
320 `d` blob,
321 `e` blob,
322 `f` blob,
323 `g` blob,
324 `h` blob,
325 `i` blob,
326 `j` blob,
327 `k` blob,
328 `l` blob,
329 `m` blob,
330 `n` blob,
331 `o` blob,
332 `p` blob,
333 `q` blob,
334 `r` blob,
335 `s` blob,
336 `t` blob,
337 `u` blob,
338 KEY `t1a` (`a`(767)),
339 KEY `t1b` (`b`(767)),
340 KEY `t1c` (`c`(767)),
341 KEY `t1d` (`d`(767)),
342 KEY `t1e` (`e`(767))
343 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
344 DROP TABLE t1;
345 SET SESSION innodb_strict_mode = OFF;
346 CREATE TABLE t1(
347 pk01 varchar(48), pk02 varchar(48), pk03 varchar(48), pk04 varchar(48),
348 pk05 varchar(48), pk06 varchar(48), pk07 varchar(48), pk08 varchar(48),
349 pk09 varchar(48), pk10 varchar(48), pk11 varchar(48), pk12 varchar(48),
350 pk13 varchar(48), pk14 varchar(48), pk15 varchar(48), pk16 varchar(48),
351 sk01 varchar(48), sk02 varchar(48), sk03 varchar(48), sk04 varchar(48),
352 sk05 varchar(48), sk06 varchar(48), sk07 varchar(48), sk08 varchar(48),
353 sk09 varchar(48), sk10 varchar(48), sk11 varchar(48), sk12 varchar(48),
354 sk13 varchar(48), sk14 varchar(48), sk15 varchar(48), sk16 varchar(48),
355 PRIMARY KEY pk(pk01,pk02,pk03,pk04,pk05,pk06,pk07,pk08,
356 pk09,pk10,pk11,pk12,pk13,pk14,pk15,pk16),
357 KEY pk(sk01,sk02,sk03,sk04,sk05,sk06,sk07,sk08,
358 sk09,sk10,sk11,sk12,sk13,sk14,sk15,sk16))
359 charset latin1
360 ROW_FORMAT=Redundant ENGINE=InnoDB;
361 SET @r = repeat('a', 48);
362 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
363 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
364 SET @r = repeat('b', 48);
365 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
366 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
367 SET @r = repeat('c', 48);
368 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
369 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
370 SET @r = repeat('d', 48);
371 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
372 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
373 SET @r = repeat('e', 48);
374 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
375 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
376 DELETE from t1;
377 DROP TABLE t1;
378 CREATE TABLE t1(
379 pk01 varchar(48), pk02 varchar(48), pk03 varchar(48), pk04 varchar(48),
380 pk05 varchar(48), pk06 varchar(48), pk07 varchar(48), pk08 varchar(48),
381 pk09 varchar(48), pk10 varchar(48), pk11 varchar(48), pk12 varchar(48),
382 pk13 varchar(48), pk14 varchar(48), pk15 varchar(48), pk16 varchar(48),
383 sk01 varchar(48), sk02 varchar(48), sk03 varchar(48), sk04 varchar(48),
384 sk05 varchar(48), sk06 varchar(48), sk07 varchar(48), sk08 varchar(48),
385 sk09 varchar(48), sk10 varchar(48), sk11 varchar(48), sk12 varchar(48),
386 sk13 varchar(48), sk14 varchar(48), sk15 varchar(48), sk16 varchar(48),
387 PRIMARY KEY pk(pk01,pk02,pk03,pk04,pk05,pk06,pk07,pk08,
388 pk09,pk10,pk11,pk12,pk13,pk14,pk15,pk16),
389 KEY pk(sk01,sk02,sk03,sk04,sk05,sk06,sk07,sk08,
390 sk09,sk10,sk11,sk12,sk13,sk14,sk15,sk16))
391 charset latin1
392 ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 ENGINE=InnoDB;
393 SET @r = repeat('a', 48);
394 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
395 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
396 SET @r = repeat('b', 48);
397 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
398 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
399 SET @r = repeat('c', 48);
400 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
401 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
402 SET @r = repeat('d', 48);
403 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
404 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
405 SET @r = repeat('e', 48);
406 INSERT INTO t1 VALUES(@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,
407 @r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
408 DELETE from t1;
409 DROP TABLE t1;
410 SET SESSION innodb_strict_mode = off;
411 CREATE TABLE t1(
412 c text NOT NULL, d text NOT NULL,
413 PRIMARY KEY (c(767)))
414 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
415 Warnings:
416 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.
417 DROP TABLE t1;
418 CREATE TABLE t1(
419 c text NOT NULL, d text NOT NULL,
420 PRIMARY KEY (c(767)))
421 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 CHARSET=ASCII;
422 drop table t1;
423 CREATE TABLE t1(
424 c text NOT NULL, d text NOT NULL,
425 PRIMARY KEY (c(767)))
426 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 CHARSET=ASCII;
427 drop table t1;
428 CREATE TABLE t1(c text, PRIMARY KEY (c(440)))
429 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
430 Warnings:
431 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.
432 DROP TABLE t1;
433 CREATE TABLE t1(c text, PRIMARY KEY (c(438)))
434 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
435 INSERT INTO t1 VALUES(REPEAT('A',512)),(REPEAT('B',512));
436 DROP TABLE t1;
437 #
438 # Bug #29283055: CLASS.CC:2604: VOID THD::SEND_STATEMENT_STATUS(): ASSERTION `0' FAILED.
439 #
440 USE mysql;
441 RENAME TABLE mysql.slave_master_info to mysql.slave_master_info_28490361;
442 CREATE TABLE mysql.slave_master_info(Number_of_lines int(10)unsigned COMMENT 'Number of lines in the file.',Master_log_name text COLLATE utf8_bin COMMENT 'The name of the master binary log currently being read from the master.',Master_log_pos INT(20) unsigned COMMENT 'The master log position of the last read event.',Host char(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT''COMMENT 'The host name of the master.',User_name text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',User_password text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',Port int(10) unsigned COMMENT 'The network port used to connect to the master.',Connect_retry int(10) unsigned COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',Enabled_ssl INT(1) COMMENT 'Indicates whether the server supports SSL connections.',Ssl_ca text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',Ssl_capath text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',Ssl_cert text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',Ssl_cipher text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',Sslk text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',Ssl_verify_server_cert INT(1) COMMENT 'Whether to verify the server certificate.',Heartbeat float,Bind text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',Ignored_server_ids text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored,followed by the actual server IDs',Uuid text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',Retry_count INT(20) unsigned COMMENT 'Number of reconnect attempts,to the master,before giving up.',Ssl_crl text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',Ssl_crlpath text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',Enabled_auto_position INT(1) COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',PRIMARY KEY (Host,Port)) DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information' ENGINE=ARCHIVE;
443 ERROR HY000: Storage engine 'ARCHIVE' does not support system tables. [mysql.slave_master_info]
444 create temporary table mysql.slave_master_info (a varchar(334) character set utf32 primary key) ROW_FORMAT=COMPACT ENGINE=INNODB;
445 ERROR 42000: Specified key was too long; max key length is 767 bytes
446 create table mysql.slave_master_info (a varchar(334) character set utf32 primary key) ROW_FORMAT=COMPACT ENGINE=INNODB;
447 # Cleanup
448 DROP TABLE mysql.slave_master_info;
449 RENAME TABLE mysql.slave_master_info_28490361 to mysql.slave_master_info;