Debian Codegraph @

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