Debian Codegraph @

mysql-test/suite/innodb_zip/r/index_large_prefix.result

raw
1 SET default_storage_engine=InnoDB;
2 set global innodb_file_per_table=1;
3 ### Test 1 ###
4 create table worklog5743(a TEXT not null, primary key (a(1000))) charset latin1 ROW_FORMAT=DYNAMIC;
5 show warnings;
6 Level Code Message
7 insert into worklog5743 values(repeat("a", 20000));
8 update worklog5743 set a = (repeat("b", 16000));
9 create index idx on worklog5743(a(2000));
10 show warnings;
11 Level Code Message
12 begin;
13 update worklog5743 set a = (repeat("x", 17000));
14 select @@session.transaction_isolation;
15 @@session.transaction_isolation
16 REPEATABLE-READ
17 select a = repeat("x", 17000) from worklog5743;
18 a = repeat("x", 17000)
19 0
20 select a = repeat("b", 16000) from worklog5743;
21 a = repeat("b", 16000)
22 1
23 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
24 select @@session.transaction_isolation;
25 @@session.transaction_isolation
26 READ-UNCOMMITTED
27 select a = repeat("x", 17000) from worklog5743;
28 a = repeat("x", 17000)
29 1
30 rollback;
31 drop table worklog5743;
32 ### Test 2 ###
33 create table worklog5743(a1 int, a2 TEXT not null) charset latin1 ROW_FORMAT=DYNAMIC;
34 show warnings;
35 Level Code Message
36 create index idx on worklog5743(a1, a2(2000));
37 show warnings;
38 Level Code Message
39 insert into worklog5743 values(9, repeat("a", 10000));
40 begin;
41 update worklog5743 set a1 = 1000;
42 select @@session.transaction_isolation;
43 @@session.transaction_isolation
44 REPEATABLE-READ
45 explain select a1, a2 = repeat("a", 10000) from worklog5743 where a1 = 9;
46 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
47 1 SIMPLE worklog5743 NULL ref idx idx 5 const 1 100.00 NULL
48 Warnings:
49 Note 1003 /* select#1 */ select `test`.`worklog5743`.`a1` AS `a1`,(`test`.`worklog5743`.`a2` = convert(repeat('a',10000) using latin1)) AS `a2 = repeat("a", 10000)` from `test`.`worklog5743` where (`test`.`worklog5743`.`a1` = 9)
50 select a1, a2 = repeat("a", 10000) from worklog5743 where a1 = 9;
51 a1 a2 = repeat("a", 10000)
52 9 1
53 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
54 select @@session.transaction_isolation;
55 @@session.transaction_isolation
56 READ-UNCOMMITTED
57 select a1, a2 = repeat("a", 10000) from worklog5743 where a1 = 9;
58 a1 a2 = repeat("a", 10000)
59 rollback;
60 drop table worklog5743;
61 ### Test 3 ###
62 create table worklog5743(a1 int, a2 TEXT not null) ROW_FORMAT=DYNAMIC;
63 create index idx on worklog5743(a1, a2(50));
64 insert into worklog5743 values(9, repeat("a", 10000));
65 begin;
66 update worklog5743 set a1 = 1000;
67 select @@session.transaction_isolation;
68 @@session.transaction_isolation
69 REPEATABLE-READ
70 explain select a1, a2 = repeat("a", 10000) from worklog5743 where a1 = 9;
71 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
72 1 SIMPLE worklog5743 NULL ref idx idx 5 const 1 100.00 NULL
73 Warnings:
74 Note 1003 /* select#1 */ select `test`.`worklog5743`.`a1` AS `a1`,(`test`.`worklog5743`.`a2` = repeat('a',10000)) AS `a2 = repeat("a", 10000)` from `test`.`worklog5743` where (`test`.`worklog5743`.`a1` = 9)
75 select a1, a2 = repeat("a", 10000) from worklog5743 where a1 = 9;
76 a1 a2 = repeat("a", 10000)
77 9 1
78 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
79 select @@session.transaction_isolation;
80 @@session.transaction_isolation
81 READ-UNCOMMITTED
82 select a1, a2 = repeat("a", 10000) from worklog5743 where a1 = 9;
83 a1 a2 = repeat("a", 10000)
84 rollback;
85 drop table worklog5743;
86 ### Test 4 ###
87 create table worklog5743_1(a1 int, a2 TEXT not null) charset latin1 KEY_BLOCK_SIZE=1;
88 create table worklog5743_2(a1 int, a2 TEXT not null) charset latin1 KEY_BLOCK_SIZE=2;
89 create table worklog5743_4(a1 int, a2 TEXT not null) charset latin1 KEY_BLOCK_SIZE=4;
90 create table worklog5743_8(a1 int, a2 TEXT, a3 TEXT) charset latin1 KEY_BLOCK_SIZE=8;
91 create table worklog5743_16(a1 int, a2 TEXT, a3 TEXT) charset latin1 KEY_BLOCK_SIZE=16;
92 create index idx2 on worklog5743_1(a2(4000));
93 ERROR 42000: Specified key was too long; max key length is 3072 bytes
94 show warnings;
95 Level Code Message
96 Error 1071 Specified key was too long; max key length is 3072 bytes
97 create index idx3 on worklog5743_1(a2(436));
98 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
99 show warnings;
100 Level Code Message
101 Error 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
102 create index idx4 on worklog5743_1(a2(434));
103 show warnings;
104 Level Code Message
105 create index idx5 on worklog5743_1(a1, a2(430));
106 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
107 show warnings;
108 Level Code Message
109 Error 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
110 create index idx6 on worklog5743_1(a1, a2(428));
111 show warnings;
112 Level Code Message
113 SET sql_mode= '';
114 create index idx2 on worklog5743_2(a2(4000));
115 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
116 show warnings;
117 Level Code Message
118 Warning 1071 Specified key was too long; max key length is 3072 bytes
119 Error 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
120 create index idx3 on worklog5743_2(a2(948));
121 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
122 show warnings;
123 Level Code Message
124 Error 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
125 create index idx4 on worklog5743_2(a2(946));
126 show warnings;
127 Level Code Message
128 create index idx5 on worklog5743_2(a1, a2(942));
129 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
130 show warnings;
131 Level Code Message
132 Error 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
133 create index idx6 on worklog5743_2(a1, a2(940));
134 show warnings;
135 Level Code Message
136 create index idx2 on worklog5743_4(a2(4000));
137 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
138 show warnings;
139 Level Code Message
140 Warning 1071 Specified key was too long; max key length is 3072 bytes
141 Error 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
142 create index idx3 on worklog5743_4(a2(1972));
143 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
144 show warnings;
145 Level Code Message
146 Error 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
147 create index idx4 on worklog5743_4(a2(1970));
148 show warnings;
149 Level Code Message
150 create index idx5 on worklog5743_4(a1, a2(1966));
151 ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
152 show warnings;
153 Level Code Message
154 Error 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
155 create index idx6 on worklog5743_4(a1, a2(1964));
156 show warnings;
157 Level Code Message
158 create index idx2 on worklog5743_8(a2(3073));
159 Warnings:
160 Warning 1071 Specified key was too long; max key length is 3072 bytes
161 show warnings;
162 Level Code Message
163 Warning 1071 Specified key was too long; max key length is 3072 bytes
164 create index idx3 on worklog5743_8(a2(3072));
165 Warnings:
166 Warning 1831 Duplicate index 'idx3' defined on the table 'test.worklog5743_8'. This is deprecated and will be disallowed in a future release.
167 show warnings;
168 Level Code Message
169 Warning 1831 Duplicate index 'idx3' defined on the table 'test.worklog5743_8'. This is deprecated and will be disallowed in a future release.
170 create index idx4 on worklog5743_8(a1, a2(3069));
171 ERROR 42000: Specified key was too long; max key length is 3072 bytes
172 show warnings;
173 Level Code Message
174 Error 1071 Specified key was too long; max key length is 3072 bytes
175 create index idx5 on worklog5743_8(a1, a2(3068));
176 show warnings;
177 Level Code Message
178 create index idx6 on worklog5743_8(a1, a2(2000), a3(1069));
179 ERROR 42000: Specified key was too long; max key length is 3072 bytes
180 show warnings;
181 Level Code Message
182 Error 1071 Specified key was too long; max key length is 3072 bytes
183 create index idx7 on worklog5743_8(a1, a2(2000), a3(1068));
184 show warnings;
185 Level Code Message
186 create index idx2 on worklog5743_16(a2(3073));
187 Warnings:
188 Warning 1071 Specified key was too long; max key length is 3072 bytes
189 show warnings;
190 Level Code Message
191 Warning 1071 Specified key was too long; max key length is 3072 bytes
192 create index idx3 on worklog5743_16(a2(3072));
193 Warnings:
194 Warning 1831 Duplicate index 'idx3' defined on the table 'test.worklog5743_16'. This is deprecated and will be disallowed in a future release.
195 show warnings;
196 Level Code Message
197 Warning 1831 Duplicate index 'idx3' defined on the table 'test.worklog5743_16'. This is deprecated and will be disallowed in a future release.
198 create index idx4 on worklog5743_16(a1, a2(3069));
199 ERROR 42000: Specified key was too long; max key length is 3072 bytes
200 show warnings;
201 Level Code Message
202 Error 1071 Specified key was too long; max key length is 3072 bytes
203 create index idx5 on worklog5743_16(a1, a2(3068));
204 show warnings;
205 Level Code Message
206 create index idx6 on worklog5743_16(a1, a2(2000), a3(1069));
207 ERROR 42000: Specified key was too long; max key length is 3072 bytes
208 show warnings;
209 Level Code Message
210 Error 1071 Specified key was too long; max key length is 3072 bytes
211 create index idx7 on worklog5743_16(a1, a2(2000), a3(1068));
212 show warnings;
213 Level Code Message
214 set sql_mode= default;
215 insert into worklog5743_1 values(9, repeat("a", 10000));
216 insert into worklog5743_2 values(9, repeat("a", 10000));
217 insert into worklog5743_4 values(9, repeat("a", 10000));
218 insert into worklog5743_8 values(9, repeat("a", 10000), repeat("a", 10000));
219 insert into worklog5743_16 values(9, repeat("a", 10000), repeat("a", 10000));
220 insert into worklog5743_1 values(2, repeat("b", 10000));
221 insert into worklog5743_2 values(2, repeat("b", 10000));
222 insert into worklog5743_4 values(2, repeat("b", 10000));
223 insert into worklog5743_8 values(2, repeat("b", 10000), repeat("b", 10000));
224 insert into worklog5743_16 values(2, repeat("b", 10000), repeat("b", 10000));
225 select a1, left(a2, 20) from worklog5743_1;
226 a1 left(a2, 20)
227 9 aaaaaaaaaaaaaaaaaaaa
228 2 bbbbbbbbbbbbbbbbbbbb
229 select a1, left(a2, 20) from worklog5743_2;
230 a1 left(a2, 20)
231 9 aaaaaaaaaaaaaaaaaaaa
232 2 bbbbbbbbbbbbbbbbbbbb
233 select a1, left(a2, 20) from worklog5743_4;
234 a1 left(a2, 20)
235 9 aaaaaaaaaaaaaaaaaaaa
236 2 bbbbbbbbbbbbbbbbbbbb
237 select a1, left(a2, 20) from worklog5743_8;
238 a1 left(a2, 20)
239 9 aaaaaaaaaaaaaaaaaaaa
240 2 bbbbbbbbbbbbbbbbbbbb
241 select a1, left(a2, 20) from worklog5743_16;
242 a1 left(a2, 20)
243 9 aaaaaaaaaaaaaaaaaaaa
244 2 bbbbbbbbbbbbbbbbbbbb
245 begin;
246 update worklog5743_1 set a1 = 1000;
247 update worklog5743_2 set a1 = 1000;
248 update worklog5743_4 set a1 = 1000;
249 update worklog5743_8 set a1 = 1000;
250 update worklog5743_16 set a1 = 1000;
251 select a1, left(a2, 20) from worklog5743_1;
252 a1 left(a2, 20)
253 1000 aaaaaaaaaaaaaaaaaaaa
254 1000 bbbbbbbbbbbbbbbbbbbb
255 select a1, left(a2, 20) from worklog5743_2;
256 a1 left(a2, 20)
257 1000 aaaaaaaaaaaaaaaaaaaa
258 1000 bbbbbbbbbbbbbbbbbbbb
259 select a1, left(a2, 20) from worklog5743_4;
260 a1 left(a2, 20)
261 1000 aaaaaaaaaaaaaaaaaaaa
262 1000 bbbbbbbbbbbbbbbbbbbb
263 select a1, left(a2, 20) from worklog5743_8;
264 a1 left(a2, 20)
265 1000 aaaaaaaaaaaaaaaaaaaa
266 1000 bbbbbbbbbbbbbbbbbbbb
267 select a1, left(a2, 20) from worklog5743_16;
268 a1 left(a2, 20)
269 1000 aaaaaaaaaaaaaaaaaaaa
270 1000 bbbbbbbbbbbbbbbbbbbb
271 select @@session.transaction_isolation;
272 @@session.transaction_isolation
273 REPEATABLE-READ
274 explain select a1, left(a2, 20) from worklog5743_1 where a1 = 9;
275 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
276 1 SIMPLE worklog5743_1 NULL ref idx6 idx6 5 const 1 100.00 NULL
277 Warnings:
278 Note 1003 /* select#1 */ select `test`.`worklog5743_1`.`a1` AS `a1`,left(`test`.`worklog5743_1`.`a2`,20) AS `left(a2, 20)` from `test`.`worklog5743_1` where (`test`.`worklog5743_1`.`a1` = 9)
279 explain select a1, left(a2, 20) from worklog5743_2 where a1 = 9;
280 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
281 1 SIMPLE worklog5743_2 NULL ref idx6 idx6 5 const 1 100.00 NULL
282 Warnings:
283 Note 1003 /* select#1 */ select `test`.`worklog5743_2`.`a1` AS `a1`,left(`test`.`worklog5743_2`.`a2`,20) AS `left(a2, 20)` from `test`.`worklog5743_2` where (`test`.`worklog5743_2`.`a1` = 9)
284 explain select a1, left(a2, 20) from worklog5743_4 where a1 = 9;
285 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
286 1 SIMPLE worklog5743_4 NULL ref idx6 idx6 5 const 1 100.00 NULL
287 Warnings:
288 Note 1003 /* select#1 */ select `test`.`worklog5743_4`.`a1` AS `a1`,left(`test`.`worklog5743_4`.`a2`,20) AS `left(a2, 20)` from `test`.`worklog5743_4` where (`test`.`worklog5743_4`.`a1` = 9)
289 explain select a1, left(a2, 20) from worklog5743_8 where a1 = 9;
290 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
291 1 SIMPLE worklog5743_8 NULL ref idx5,idx7 idx5 5 const 1 100.00 NULL
292 Warnings:
293 Note 1003 /* select#1 */ select `test`.`worklog5743_8`.`a1` AS `a1`,left(`test`.`worklog5743_8`.`a2`,20) AS `left(a2, 20)` from `test`.`worklog5743_8` where (`test`.`worklog5743_8`.`a1` = 9)
294 explain select a1, left(a2, 20) from worklog5743_16 where a1 = 9;
295 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
296 1 SIMPLE worklog5743_16 NULL ref idx5,idx7 idx5 5 const 1 100.00 NULL
297 Warnings:
298 Note 1003 /* select#1 */ select `test`.`worklog5743_16`.`a1` AS `a1`,left(`test`.`worklog5743_16`.`a2`,20) AS `left(a2, 20)` from `test`.`worklog5743_16` where (`test`.`worklog5743_16`.`a1` = 9)
299 select a1, left(a2, 20) from worklog5743_1 where a1 = 9;
300 a1 left(a2, 20)
301 9 aaaaaaaaaaaaaaaaaaaa
302 select a1, left(a2, 20) from worklog5743_2 where a1 = 9;
303 a1 left(a2, 20)
304 9 aaaaaaaaaaaaaaaaaaaa
305 select a1, left(a2, 20) from worklog5743_4 where a1 = 9;
306 a1 left(a2, 20)
307 9 aaaaaaaaaaaaaaaaaaaa
308 select a1, left(a2, 20) from worklog5743_8 where a1 = 9;
309 a1 left(a2, 20)
310 9 aaaaaaaaaaaaaaaaaaaa
311 select a1, left(a2, 20) from worklog5743_16 where a1 = 9;
312 a1 left(a2, 20)
313 9 aaaaaaaaaaaaaaaaaaaa
314 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
315 select @@session.transaction_isolation;
316 @@session.transaction_isolation
317 READ-UNCOMMITTED
318 select a1, left(a2, 20) from worklog5743_1 where a1 = 9;
319 a1 left(a2, 20)
320 select a1, left(a2, 20) from worklog5743_2 where a1 = 9;
321 a1 left(a2, 20)
322 select a1, left(a2, 20) from worklog5743_4 where a1 = 9;
323 a1 left(a2, 20)
324 select a1, left(a2, 20) from worklog5743_8 where a1 = 9;
325 a1 left(a2, 20)
326 select a1, left(a2, 20) from worklog5743_16 where a1 = 9;
327 a1 left(a2, 20)
328 rollback;
329 drop table worklog5743_1;
330 drop table worklog5743_2;
331 drop table worklog5743_4;
332 drop table worklog5743_8;
333 drop table worklog5743_16;
334 ### Test 5 ###
335 create table worklog5743(a1 int,
336 a2 varchar(20000),
337 a3 varchar(3073),
338 a4 varchar(3072),
339 a5 varchar(3069),
340 a6 varchar(3068))
341 charset latin1
342 ROW_FORMAT=DYNAMIC;
343 SET sql_mode='';
344 create index idx1 on worklog5743(a2);
345 Warnings:
346 Warning 1071 Specified key was too long; max key length is 3072 bytes
347 create index idx2 on worklog5743(a3);
348 Warnings:
349 Warning 1071 Specified key was too long; max key length is 3072 bytes
350 create index idx3 on worklog5743(a4);
351 show warnings;
352 Level Code Message
353 SET sql_mode= default;
354 create index idx4 on worklog5743(a1, a2);
355 ERROR 42000: Specified key was too long; max key length is 3072 bytes
356 show warnings;
357 Level Code Message
358 Error 1071 Specified key was too long; max key length is 3072 bytes
359 create index idx5 on worklog5743(a1, a5);
360 ERROR 42000: Specified key was too long; max key length is 3072 bytes
361 show warnings;
362 Level Code Message
363 Error 1071 Specified key was too long; max key length is 3072 bytes
364 create index idx6 on worklog5743(a1, a6);
365 show warnings;
366 Level Code Message
367 show create table worklog5743;
368 Table Create Table
369 worklog5743 CREATE TABLE `worklog5743` (
370 `a1` int DEFAULT NULL,
371 `a2` varchar(20000) DEFAULT NULL,
372 `a3` varchar(3073) DEFAULT NULL,
373 `a4` varchar(3072) DEFAULT NULL,
374 `a5` varchar(3069) DEFAULT NULL,
375 `a6` varchar(3068) DEFAULT NULL,
376 KEY `idx1` (`a2`(3072)),
377 KEY `idx2` (`a3`(3072)),
378 KEY `idx3` (`a4`),
379 KEY `idx6` (`a1`,`a6`)
380 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
381 insert into worklog5743 values(9,
382 repeat("a", 20000), repeat("a", 3073),
383 repeat("a", 3072), repeat("a", 3069),
384 repeat("a", 3068));
385 begin;
386 update worklog5743 set a1 = 1000;
387 select @@session.transaction_isolation;
388 @@session.transaction_isolation
389 REPEATABLE-READ
390 explain select a1 from worklog5743 where a1 = 9;
391 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
392 1 SIMPLE worklog5743 NULL ref idx6 idx6 5 const 1 100.00 Using index
393 Warnings:
394 Note 1003 /* select#1 */ select `test`.`worklog5743`.`a1` AS `a1` from `test`.`worklog5743` where (`test`.`worklog5743`.`a1` = 9)
395 select a1 from worklog5743 where a1 = 9;
396 a1
397 9
398 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
399 select @@session.transaction_isolation;
400 @@session.transaction_isolation
401 READ-UNCOMMITTED
402 select a1 from worklog5743 where a1 = 9;
403 a1
404 rollback;
405 drop table worklog5743;
406 ### Test 6 ###
407 create table worklog5743(a TEXT not null, primary key (a(1000)))
408 charset latin1
409 row_format=compact;
410 ERROR 42000: Specified key was too long; max key length is 767 bytes
411 create table worklog5743(a TEXT)
412 charset latin1
413 row_format=compact;
414 create index idx on worklog5743(a(768));
415 ERROR 42000: Specified key was too long; max key length is 767 bytes
416 create index idx on worklog5743(a(767));
417 insert into worklog5743 values(repeat("a", 20000));
418 begin;
419 insert into worklog5743 values(repeat("b", 20000));
420 update worklog5743 set a = (repeat("x", 25000));
421 select @@session.transaction_isolation;
422 @@session.transaction_isolation
423 REPEATABLE-READ
424 select a = repeat("a", 20000) from worklog5743;
425 a = repeat("a", 20000)
426 1
427 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
428 select @@session.transaction_isolation;
429 @@session.transaction_isolation
430 READ-UNCOMMITTED
431 select a = repeat("x", 25000) from worklog5743;
432 a = repeat("x", 25000)
433 1
434 1
435 rollback;
436 drop table worklog5743;
437 ### Test 7 ###
438 create table worklog5743(a TEXT not null) ROW_FORMAT=DYNAMIC;
439 SET sql_mode='';
440 create index idx1 on worklog5743(a(3073));
441 Warnings:
442 Warning 1071 Specified key was too long; max key length is 3072 bytes
443 create index idx2 on worklog5743(a(3072));
444 Warnings:
445 Warning 1071 Specified key was too long; max key length is 3072 bytes
446 Warning 1831 Duplicate index 'idx2' defined on the table 'test.worklog5743'. This is deprecated and will be disallowed in a future release.
447 show create table worklog5743;
448 Table Create Table
449 worklog5743 CREATE TABLE `worklog5743` (
450 `a` text NOT NULL,
451 KEY `idx1` (`a`(768)),
452 KEY `idx2` (`a`(768))
453 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
454 drop table worklog5743;
455 SET sql_mode= default;
456 create table worklog5743(a TEXT not null) charset latin1 ROW_FORMAT=REDUNDANT;
457 create index idx on worklog5743(a(768));
458 ERROR 42000: Specified key was too long; max key length is 767 bytes
459 create index idx2 on worklog5743(a(767));
460 drop table worklog5743;
461 create table worklog5743(a TEXT not null) charset latin1 ROW_FORMAT=COMPACT;
462 create index idx on worklog5743(a(768));
463 ERROR 42000: Specified key was too long; max key length is 767 bytes
464 create index idx2 on worklog5743(a(767));
465 drop table worklog5743;
466 SET GLOBAL innodb_file_per_table=1;