Debian Codegraph @

mysql-test/suite/innodb_zip/r/page_size,8k.rdiff

raw
1 @@ -3,7 +3,7 @@
2 SELECT variable_value FROM information_schema.global_status
3 WHERE LOWER(variable_name) = 'innodb_page_size';
4 variable_value
5 -16384
6 +8192
7 # Test 3) Query some information_shema tables that are dependent upon
8 # the page size.
9 SELECT t.name table_name, t.n_cols, t.flag table_flags,
10 @@ -36,7 +36,7 @@
11 table_name n_cols table_flags index_name root_page type n_fields merge_threshold
12 test/t1 5 0 PRIMARY 3 3 1 50
13 test/t2 5 1 PRIMARY 3 3 1 50
14 -test/t3 5 41 PRIMARY 3 3 1 50
15 +test/t3 5 39 PRIMARY 3 3 1 50
16 test/t4 5 33 PRIMARY 3 3 1 50
17 === information_schema.innodb_sys_tablespaces and innodb_sys_datafiles ===
18 Space_Name Page_Size Zip_Size Path
19 @@ -45,7 +45,7 @@
20 innodb_undo003 DEFAULT DEFAULT MYSQLD_DATADIR//undo003
21 test/t1 DEFAULT DEFAULT MYSQLD_DATADIR/test/t1.ibd
22 test/t2 DEFAULT DEFAULT MYSQLD_DATADIR/test/t2.ibd
23 -test/t3 DEFAULT 8192 MYSQLD_DATADIR/test/t3.ibd
24 +test/t3 DEFAULT 4096 MYSQLD_DATADIR/test/t3.ibd
25 test/t4 DEFAULT DEFAULT MYSQLD_DATADIR/test/t4.ibd
26 innodb_temporary DEFAULT DEFAULT MYSQLD_DATADIR/ibtmp1
27 DROP TABLE t1, t2, t3, t4;
28 @@ -57,133 +57,97 @@
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(211)
37 +c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(155)
38 ) ROW_FORMAT=redundant;
39 DROP TABLE t1;
40 CREATE TABLE t1 (
41 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
42 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
43 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
44 -c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
45 -c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
46 -c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
47 -c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
48 -c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(212)
49 +c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(156)
50 ) ROW_FORMAT=redundant;
51 -ERROR 42000: Row size too large (> 8123). 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.
52 +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.
53 CREATE TABLE t1 (
54 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
55 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
56 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
57 -c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
58 -c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
59 -c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
60 -c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
61 -c36 char(200), c37 char(200), c38 char(200), c39 char(250), c40 char(246)
62 +c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(202)
63 ) ROW_FORMAT=compact;
64 DROP TABLE t1;
65 CREATE TABLE t1 (
66 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
67 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
68 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
69 -c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
70 -c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
71 -c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
72 -c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
73 -c36 char(200), c37 char(200), c38 char(200), c39 char(250), c40 char(247)
74 +c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(203)
75 ) ROW_FORMAT=compact;
76 -ERROR 42000: Row size too large (> 8126). 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.
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(200),
81 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
82 -c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
83 -c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
84 -c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
85 -c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
86 -c36 char(200), c37 char(200), c38 char(196)
87 +c16 char(200), c17 char(200), c18 char(182)
88 ) ROW_FORMAT=compressed;
89 DROP TABLE t1;
90 CREATE TABLE t1 (
91 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
92 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
93 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
94 -c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
95 -c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
96 -c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
97 -c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
98 -c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(160)
99 +c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(106)
100 ) ROW_FORMAT=compressed;
101 -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.
102 +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.
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(200),
108 -c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
109 -c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
110 -c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
111 -c36 char(200), c37 char(200), c38 char(200), c39 char(250), c40 char(246)
112 +c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(202)
113 ) ROW_FORMAT=dynamic;
114 DROP TABLE t1;
115 CREATE TABLE t1 (
116 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
117 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
118 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
119 -c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
120 -c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
121 -c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
122 -c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
123 -c36 char(200), c37 char(200), c38 char(200), c39 char(250), c40 char(247)
124 +c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(203)
125 ) ROW_FORMAT=dynamic;
126 -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.
127 -CREATE TABLE t1 (a varchar(255) character set utf8,
128 -b varchar(255) character set utf8,
129 -c varchar(255) character set utf8,
130 -d varchar(255) character set utf8,
131 -e varchar(4) character set utf8,
132 -PRIMARY KEY (a,b,c,d,e))
133 +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.
134 +CREATE TABLE t1 (a varchar(128) character set utf8,
135 +b varchar(128) character set utf8,
136 +c varchar(128) character set utf8,
137 +d varchar(128) character set utf8,
138 +PRIMARY KEY (a,b,c,d))
139 ENGINE=innodb;
140 DROP TABLE t1;
141 -CREATE TABLE t1 (a varchar(255) character set utf8,
142 -b varchar(255) character set utf8,
143 -c varchar(255) character set utf8,
144 -d varchar(255) character set utf8,
145 -e varchar(5) character set utf8,
146 -PRIMARY KEY (a,b,c,d,e))
147 +CREATE TABLE t1 (a varchar(128) character set utf8,
148 +b varchar(128) character set utf8,
149 +c varchar(128) character set utf8,
150 +d varchar(129) character set utf8,
151 +PRIMARY KEY (a,b,c,d))
152 ENGINE=innodb;
153 -ERROR 42000: Specified key was too long; max key length is 3072 bytes
154 -CREATE TABLE t1 (a varchar(255) character set utf8,
155 -b varchar(255) character set utf8,
156 -c varchar(255) character set utf8,
157 -d varchar(255) character set utf8,
158 -e varchar(255) character set utf8,
159 -f varchar(4) character set utf8,
160 -PRIMARY KEY (a), KEY (b,c,d,e,f))
161 +ERROR 42000: Specified key was too long; max key length is 1536 bytes
162 +CREATE TABLE t1 (a varchar(128) character set utf8,
163 +b varchar(128) character set utf8,
164 +c varchar(128) character set utf8,
165 +d varchar(128) character set utf8,
166 +e varchar(128) character set utf8,
167 +PRIMARY KEY (a), KEY (b,c,d,e))
168 ENGINE=innodb;
169 DROP TABLE t1;
170 -CREATE TABLE t1 (a varchar(255) character set utf8,
171 -b varchar(255) character set utf8,
172 -c varchar(255) character set utf8,
173 -d varchar(255) character set utf8,
174 -e varchar(255) character set utf8,
175 -f varchar(5) character set utf8,
176 -PRIMARY KEY (a), KEY (b,c,d,e,f))
177 +CREATE TABLE t1 (a varchar(128) character set utf8,
178 +b varchar(128) character set utf8,
179 +c varchar(128) character set utf8,
180 +d varchar(128) character set utf8,
181 +e varchar(129) character set utf8,
182 +PRIMARY KEY (a), KEY (b,c,d,e))
183 ENGINE=innodb;
184 -ERROR 42000: Specified key was too long; max key length is 3072 bytes
185 +ERROR 42000: Specified key was too long; max key length is 1536 bytes
186 # Test 5) KEY_BLOCK_SIZE validation
187 -CREATE TABLE t1 (i int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
188 +CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
189 +ERROR HY000: Can't create table `test`.`t1` (errno: 140 "Wrong create options")
190 SHOW WARNINGS;
191 Level Code Message
192 -SELECT table_name, row_format, create_options
193 -FROM information_schema.tables WHERE table_name = 't1';
194 -table_name row_format create_options
195 -t1 Compressed row_format=COMPRESSED key_block_size=16
196 -ALTER TABLE t1 KEY_BLOCK_SIZE=8;
197 +Warning 1478 InnoDB: KEY_BLOCK_SIZE=16 cannot be larger than 8.
198 +Error 1005 Can't create table `test`.`t1` (errno: 140 "Wrong create options")
199 +Warning 1030 Got error 140 "Wrong create options" from storage engine InnoDB
200 +CREATE TABLE t1 ( i INT ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
201 SHOW WARNINGS;
202 Level Code Message
203 SELECT table_name, row_format, create_options
204 @@ -221,8 +185,11 @@
205 DROP TABLE t1;
206 SET SESSION innodb_strict_mode = OFF;
207 CREATE TABLE t1 (i int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16;
208 +Warnings:
209 +Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16.
210 SHOW WARNINGS;
211 Level Code Message
212 +Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16.
213 SELECT table_name, row_format, create_options
214 FROM information_schema.tables WHERE table_name = 't1';
215 table_name row_format create_options
216 @@ -282,107 +249,13 @@
217 ERROR HY000: Can't create table `test`.`t5` (errno: 140 "Wrong create options")
218 SHOW WARNINGS;
219 Level Code Message
220 +Warning 1478 InnoDB: KEY_BLOCK_SIZE=16 cannot be larger than 8.
221 Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table.
222 Error 1005 Can't create table `test`.`t5` (errno: 140 "Wrong create options")
223 Warning 1030 Got error 140 "Wrong create options" from storage engine InnoDB
224 SET GLOBAL innodb_file_per_table = ON;
225 Warnings:
226 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
227 -# Test 7) This series of tests were moved from innodb-index to here
228 -# because the second alter table t1 assumes a 16k page size.
229 -# Moving the test allows the rest of innodb-index to be run on all
230 -# page sizes. The previously disabled portions of this test were
231 -# moved as well.
232 -CREATE TABLE t2(d varchar(17) PRIMARY KEY) ENGINE=innodb DEFAULT CHARSET=utf8;
233 -CREATE TABLE t3(a int PRIMARY KEY) ENGINE=innodb;
234 -INSERT INTO t3 VALUES (22),(44),(33),(55),(66);
235 -INSERT INTO t2 VALUES ('jejdkrun87'),('adfd72nh9k'),
236 -('adfdpplkeock'),('adfdijnmnb78k'),('adfdijn0loKNHJik');
237 -CREATE TABLE t1(a int, b blob, c text, d text NOT NULL)
238 -ENGINE=innodb DEFAULT CHARSET=utf8 STATS_PERSISTENT=0;
239 -INSERT INTO t1
240 -SELECT a,LEFT(REPEAT(d,100*a),65535),REPEAT(d,20*a),d FROM t2,t3 order by a, d;
241 -DROP TABLE t2, t3;
242 -SELECT COUNT(*) FROM t1 WHERE a=44;
243 -COUNT(*)
244 -5
245 -SELECT a,
246 -LENGTH(b),b=LEFT(REPEAT(d,100*a),65535),LENGTH(c),c=REPEAT(d,20*a),d FROM t1
247 -ORDER BY 1, 2, 3, 4, 5, 6;
248 -a LENGTH(b) b=LEFT(REPEAT(d,100*a),65535) LENGTH(c) c=REPEAT(d,20*a) d
249 -22 22000 1 4400 1 adfd72nh9k
250 -22 22000 1 4400 1 jejdkrun87
251 -22 26400 1 5280 1 adfdpplkeock
252 -22 28600 1 5720 1 adfdijnmnb78k
253 -22 35200 1 7040 1 adfdijn0loKNHJik
254 -33 33000 1 6600 1 adfd72nh9k
255 -33 33000 1 6600 1 jejdkrun87
256 -33 39600 1 7920 1 adfdpplkeock
257 -33 42900 1 8580 1 adfdijnmnb78k
258 -33 52800 1 10560 1 adfdijn0loKNHJik
259 -44 44000 1 8800 1 adfd72nh9k
260 -44 44000 1 8800 1 jejdkrun87
261 -44 52800 1 10560 1 adfdpplkeock
262 -44 57200 1 11440 1 adfdijnmnb78k
263 -44 65535 1 14080 1 adfdijn0loKNHJik
264 -55 55000 1 11000 1 adfd72nh9k
265 -55 55000 1 11000 1 jejdkrun87
266 -55 65535 1 13200 1 adfdpplkeock
267 -55 65535 1 14300 1 adfdijnmnb78k
268 -55 65535 1 17600 1 adfdijn0loKNHJik
269 -66 65535 1 13200 1 adfd72nh9k
270 -66 65535 1 13200 1 jejdkrun87
271 -66 65535 1 15840 1 adfdpplkeock
272 -66 65535 1 17160 1 adfdijnmnb78k
273 -66 65535 1 21120 1 adfdijn0loKNHJik
274 -ALTER TABLE t1 ADD PRIMARY KEY (a), ADD KEY (b(20));
275 -ERROR 23000: Duplicate entry '22' for key 'PRIMARY'
276 -DELETE FROM t1 WHERE d='null';
277 -ALTER TABLE t1 ADD PRIMARY KEY (a), ADD KEY (b(20));
278 -ERROR 23000: Duplicate entry '22' for key 'PRIMARY'
279 -DELETE FROM t1 WHERE a%2;
280 -CHECK TABLE t1;
281 -Table Op Msg_type Msg_text
282 -test.t1 check status OK
283 -ALTER TABLE t1 ADD PRIMARY KEY (a,b(255),c(255)), ADD KEY (b(767));
284 -SELECT COUNT(*) FROM t1 WHERE a=44;
285 -COUNT(*)
286 -5
287 -SELECT a,
288 -LENGTH(b), b=LEFT(REPEAT(d,100*a), 65535),LENGTH(c), c=REPEAT(d,20*a), d FROM t1;
289 -a LENGTH(b) b=LEFT(REPEAT(d,100*a), 65535) LENGTH(c) c=REPEAT(d,20*a) d
290 -22 22000 1 4400 1 adfd72nh9k
291 -22 35200 1 7040 1 adfdijn0loKNHJik
292 -22 28600 1 5720 1 adfdijnmnb78k
293 -22 26400 1 5280 1 adfdpplkeock
294 -22 22000 1 4400 1 jejdkrun87
295 -44 44000 1 8800 1 adfd72nh9k
296 -44 65535 1 14080 1 adfdijn0loKNHJik
297 -44 57200 1 11440 1 adfdijnmnb78k
298 -44 52800 1 10560 1 adfdpplkeock
299 -44 44000 1 8800 1 jejdkrun87
300 -66 65535 1 13200 1 adfd72nh9k
301 -66 65535 1 21120 1 adfdijn0loKNHJik
302 -66 65535 1 17160 1 adfdijnmnb78k
303 -66 65535 1 15840 1 adfdpplkeock
304 -66 65535 1 13200 1 jejdkrun87
305 -SHOW CREATE TABLE t1;
306 -Table Create Table
307 -t1 CREATE TABLE `t1` (
308 - `a` int(11) NOT NULL,
309 - `b` blob NOT NULL,
310 - `c` text NOT NULL,
311 - `d` text NOT NULL,
312 - PRIMARY KEY (`a`,`b`(255),`c`(255)),
313 - KEY `b` (`b`(767))
314 -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci STATS_PERSISTENT=0
315 -CHECK TABLE t1;
316 -Table Op Msg_type Msg_text
317 -test.t1 check status OK
318 -EXPLAIN SELECT * FROM t1 WHERE b LIKE 'adfd%';
319 -id select_type table type possible_keys key key_len ref rows Extra
320 -1 SIMPLE t1 range b b 769 NULL # Using where
321 -DROP TABLE t1;
322 # Test 8) Test creating a table that could lead to undo log overflow.
323 CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
324 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
325 @@ -397,10 +270,6 @@
326 UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
327 k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b;
328 CREATE INDEX t1a ON t1 (a(767));
329 -CREATE INDEX t1b ON t1 (b(767));
330 -CREATE INDEX t1c ON t1 (c(767));
331 -CREATE INDEX t1d ON t1 (d(767));
332 -CREATE INDEX t1e ON t1 (e(767));
333 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
334 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c;
335 CREATE INDEX t1f ON t1 (f(767));
336 @@ -415,30 +284,6 @@
337 COMMIT;
338 CREATE INDEX t1g ON t1 (g(767));
339 UPDATE t1 SET g=@e;
340 -CREATE INDEX t1h ON t1 (h(767));
341 -UPDATE t1 SET h=@e;
342 -CREATE INDEX t1i ON t1 (i(767));
343 -UPDATE t1 SET i=@e;
344 -CREATE INDEX t1j ON t1 (j(767));
345 -UPDATE t1 SET j=@e;
346 -CREATE INDEX t1k ON t1 (k(767));
347 -UPDATE t1 SET k=@e;
348 -CREATE INDEX t1l ON t1 (l(767));
349 -UPDATE t1 SET l=@e;
350 -CREATE INDEX t1m ON t1 (m(767));
351 -UPDATE t1 SET m=@e;
352 -CREATE INDEX t1n ON t1 (n(767));
353 -UPDATE t1 SET n=@e;
354 -CREATE INDEX t1o ON t1 (o(767));
355 -UPDATE t1 SET o=@e;
356 -CREATE INDEX t1p ON t1 (p(767));
357 -UPDATE t1 SET p=@e;
358 -CREATE INDEX t1q ON t1 (q(767));
359 -UPDATE t1 SET q=@e;
360 -CREATE INDEX t1r ON t1 (r(767));
361 -UPDATE t1 SET r=@e;
362 -CREATE INDEX t1s ON t1 (s(767));
363 -UPDATE t1 SET s=@e;
364 CREATE INDEX t1t ON t1 (t(767));
365 BEGIN;
366 UPDATE t1 SET t=@e;
367 @@ -471,24 +316,8 @@
368 `t` blob DEFAULT NULL,
369 `u` blob DEFAULT NULL,
370 KEY `t1a` (`a`(767)),
371 - KEY `t1b` (`b`(767)),
372 - KEY `t1c` (`c`(767)),
373 - KEY `t1d` (`d`(767)),
374 - KEY `t1e` (`e`(767)),
375 KEY `t1f` (`f`(767)),
376 KEY `t1g` (`g`(767)),
377 - KEY `t1h` (`h`(767)),
378 - KEY `t1i` (`i`(767)),
379 - KEY `t1j` (`j`(767)),
380 - KEY `t1k` (`k`(767)),
381 - KEY `t1l` (`l`(767)),
382 - KEY `t1m` (`m`(767)),
383 - KEY `t1n` (`n`(767)),
384 - KEY `t1o` (`o`(767)),
385 - KEY `t1p` (`p`(767)),
386 - KEY `t1q` (`q`(767)),
387 - KEY `t1r` (`r`(767)),
388 - KEY `t1s` (`s`(767)),
389 KEY `t1t` (`t`(767)),
390 KEY `t1u` (`u`(767)),
391 KEY `t1ut` (`u`(767),`t`(767)),
392 @@ -580,14 +409,14 @@
393 PRIMARY KEY (c(767),d(767)))
394 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
395 Warnings:
396 -Warning 139 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.
397 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
398 DROP TABLE t1;
399 CREATE TABLE t1(
400 c text NOT NULL, d text NOT NULL,
401 PRIMARY KEY (c(767),d(767)))
402 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 CHARSET=ASCII;
403 Warnings:
404 -Warning 139 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.
405 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
406 DROP TABLE t1;
407 CREATE TABLE t1(
408 c text NOT NULL, d text NOT NULL,
409 @@ -597,7 +426,7 @@
410 CREATE TABLE t1(c text, PRIMARY KEY (c(440)))
411 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;
412 Warnings:
413 -Warning 139 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.
414 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
415 DROP TABLE t1;
416 CREATE TABLE t1(c text, PRIMARY KEY (c(293)))
417 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 CHARSET=ASCII;