Debian Codegraph @

mysql-test/suite/innodb/t/default_row_format_16k.test

raw
1 --echo #
2 --echo # BUG#21816041 - ROW_FORMAT=DYNAMIC IS RESTRICTIVE THAN ROW_FORMAT=COMPACT
3 --echo #
4 --source include/no_valgrind_without_big.inc
5
6 CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16383) CHARACTER SET UTF8MB3,
7 PRIMARY KEY(a(255), b(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
8 DROP TABLE t1;
9
10 CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16383) CHARACTER SET UTF8MB3,
11 PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
12 DROP TABLE t1;
13
14 CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16280) CHARACTER SET UTF8MB4,
15 PRIMARY KEY(a(255), b(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC charset latin1;
16 DROP TABLE t1;
17
18 CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB4) ENGINE=INNODB
19 ROW_FORMAT=DYNAMIC;
20 ALTER TABLE t1 ADD PRIMARY KEY(a(100));
21 DROP TABLE t1;
22
23 CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB3,
24 PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
25 DROP TABLE t1;
26
27 CREATE TABLE t1 (a VARCHAR(12383) CHARACTER SET UTF8MB3,
28 PRIMARY KEY(a(255)), KEY k1(a(1024))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
29 INSERT INTO t1 VALUES(REPEAT('A', 500));
30 UPDATE t1 SET a = REPEAT('B', 999);
31 DROP TABLE t1;
32
33 CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB3,
34 PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
35 DROP TABLE t1;
36
37 CREATE TABLE t1 (a VARCHAR(16383), b VARCHAR(3000), c TEXT,
38 PRIMARY KEY(a(255), c(10)), KEY k1(a(500)), KEY k2(b(72), c(3000)))
39 charset latin1 ENGINE=INNODB ROW_FORMAT=DYNAMIC;
40 DROP TABLE t1;
41
42 CREATE TABLE t1 (a VARCHAR(3070) , b TEXT,
43 PRIMARY KEY(a(400)), KEY k1(a)) ENGINE=INNODB ROW_FORMAT=DYNAMIC charset latin1;
44 DROP TABLE t1;
45
46 CREATE TABLE t1 (a VARCHAR(3000) , b TEXT, c INT, d TEXT,
47 PRIMARY KEY(a, b(3), c), KEY k1(a, b(25))) charset latin1 ENGINE=INNODB ROW_FORMAT=DYNAMIC;
48 DROP TABLE t1;
49
50 CREATE TABLE t1 (a INT , b TEXT,
51 PRIMARY KEY(a, b(3)), KEY k1(a)) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
52 DROP TABLE t1;
53
54 CREATE TABLE t1(a CHAR(10), KEY(a(5)));
55 DROP TABLE t1;
56 CREATE TABLE t1(a CHAR(255), KEY(a(200)));
57 DROP TABLE t1;
58
59 CREATE TABLE t1(a CHAR(255), KEY(a));
60 DROP TABLE t1;
61
62 CREATE TABLE t1(a VARCHAR(4000), KEY(a(2000))) charset latin1;
63 DROP TABLE t1;
64
65 CREATE TABLE t1(a VARCHAR(2000), PRIMARY KEY (a), KEY k1(a(2000))) charset latin1;
66 DROP TABLE t1;
67
68 CREATE TABLE t1(a VARCHAR(5000), PRIMARY KEY (a(3000)), KEY k1(a(2000))) charset latin1;
69 DROP TABLE t1;
70
71 CREATE TABLE t1 (
72 c1 INT AUTO_INCREMENT,
73 c2 GEOMETRY NOT NULL SRID 0,
74 PRIMARY KEY(c1),
75 SPATIAL INDEX(c2)
76 ) ENGINE=INNODB;
77 DROP TABLE t1;
78
79 CREATE TABLE t1(a TEXT, b TEXT, c TEXT, FULLTEXT `AB`(a, b), FULLTEXT `C1`(c));
80 DROP TABLE t1;
81
82 CREATE TABLE t1 (
83 col_1_VARBINARY VARBINARY (4000) ,
84 col_2_VARCHAR VARCHAR (4000) ,
85 col_3_TEXT TEXT (4000),
86 col_4_BLOB BLOB (4000),
87 col_5_TEXT TEXT (4000),
88 col_6_TEXT TEXT (4000),
89 col_7_TEXT TEXT (4000),
90 col_8_TEXT TEXT (4000),
91 col_9_TEXT TEXT (4000),
92 col_10_TEXT TEXT (4000),
93 col_11_TEXT TEXT (4000),
94 col_12_TEXT TEXT (4000),
95 col_13_TEXT TEXT (4000),
96 col_14_TEXT TEXT (4000),
97 col_15_TEXT TEXT (4000),
98 col_16_TEXT TEXT (4000),
99 col_17_TEXT TEXT (4000),
100 col_18_TEXT TEXT (4000),
101 col_19_TEXT TEXT (4000),
102 col_20_TEXT TEXT (4000),
103 col_21_TEXT TEXT (4000),
104 col_22_TEXT TEXT (4000),
105 col_23_TEXT TEXT (4000),
106 col_24_BINARY BINARY (255)
107 ) ROW_FORMAT=DYNAMIC, engine = innodb;
108
109 INSERT INTO t1 VALUES(
110 repeat("a", 4000), repeat("o", 4000),
111 repeat("a", 4000), repeat("o", 4000),
112 repeat("a", 4000), repeat("o", 4000),
113 repeat("a", 4000), repeat("o", 4000),
114 repeat("a", 4000), repeat("o", 4000),
115 repeat("a", 4000), repeat("o", 4000),
116 repeat("a", 4000), repeat("o", 4000),
117 repeat("a", 4000), repeat("o", 4000),
118 repeat("a", 4000), repeat("o", 4000),
119 repeat("a", 4000), repeat("o", 4000),
120 repeat("a", 4000), repeat("o", 4000),
121 repeat("a", 4000), repeat("a", 255)
122 );
123
124 CREATE INDEX prefix_idx1 ON t1(col_1_VARBINARY (767));
125 CREATE INDEX prefix_idx2 ON t1(col_2_VARCHAR (767));
126 CREATE INDEX prefix_idx3 ON t1(col_3_TEXT (767));
127 CREATE INDEX prefix_idx4 ON t1(col_4_BLOB (767));
128 CREATE INDEX prefix_idx5 ON t1(col_5_TEXT (767));
129 CREATE INDEX prefix_idx6 ON t1(col_6_TEXT (767));
130 CREATE INDEX prefix_idx7 ON t1(col_7_TEXT (767));
131 CREATE INDEX prefix_idx8 ON t1(col_8_TEXT (767));
132 CREATE INDEX prefix_idx9 ON t1(col_9_TEXT (767));
133 CREATE INDEX prefix_idx10 ON t1(col_10_TEXT (767));
134 CREATE INDEX prefix_idx11 ON t1(col_11_TEXT (767));
135 CREATE INDEX prefix_idx12 ON t1(col_12_TEXT (767));
136 CREATE INDEX prefix_idx13 ON t1(col_13_TEXT (767));
137 CREATE INDEX prefix_idx14 ON t1(col_14_TEXT (767));
138 CREATE INDEX prefix_idx15 ON t1(col_15_TEXT (767));
139 CREATE INDEX prefix_idx16 ON t1(col_16_TEXT (767));
140 CREATE INDEX prefix_idx17 ON t1(col_17_TEXT (767));
141 CREATE INDEX prefix_idx18 ON t1(col_18_TEXT (767));
142 CREATE INDEX prefix_idx19 ON t1(col_19_TEXT (767));
143 CREATE INDEX prefix_idx24 ON t1(col_24_BINARY (250));
144
145 --error ER_UNDO_RECORD_TOO_BIG
146 UPDATE t1 SET col_1_VARBINARY = repeat("x", 4000), col_2_VARCHAR=
147 repeat("c",
148 4000) WHERE col_1_VARBINARY = repeat("a", 4000) AND col_2_VARCHAR =
149 repeat("o", 4000);
150
151 DROP TABLE t1;
152
153 CREATE TABLE t1(a INT, b FLOAT, c CHAR(10),
154 v1 VARCHAR(1001),
155 v2 VARCHAR(1002),
156 vx_blob BLOB,
157 vx_text TEXT,
158 vx_varchar VARCHAR(3005),
159 v3 VARCHAR(1006),
160 v4 VARCHAR(1007),
161 PRIMARY KEY (a,b,c,vx_text(200))) charset latin1 ROW_FORMAT=DYNAMIC;
162 CREATE INDEX idx1 ON t1(a,b,c);
163 CREATE INDEX idx2 ON t1(a,v1(101));
164 CREATE INDEX idx3 ON t1(b,v2(102));
165 CREATE INDEX idx4 ON t1(c,vx_blob(3003));
166 CREATE INDEX idx5 ON t1(a,vx_text(1004));
167 SHOW WARNINGS;
168 INSERT INTO t1 VALUES(1,1,'111111111',
169 repeat('a',1001),
170 repeat('a',1002),
171 repeat('a',4003),
172 repeat('a',3004),
173 repeat('a',3005),
174 repeat('a',1006),
175 repeat('a',1007));
176 UPDATE t1 SET
177 v1=repeat('b',1001),
178 v2=repeat('b',1002),
179 vx_blob=repeat('b',4003),
180 vx_varchar=repeat('b',3005),
181 v3=repeat('b',1006),
182 v4=repeat('b',1007);
183 DROP TABLE t1;
184
185 create table t1(a int, b float, c char(10), d date,
186 vx_varchar varchar(10000), vx_text text, vx_blob BLOB,
187 v1 varchar(1000), v2 varchar(1000),
188 v3 varchar(1000), v4 varchar(3000))
189 charset latin1 ROW_FORMAT=DYNAMIC;
190 create index idx1 on t1(a,b,c,d);
191 create index idx2 on t1(vx_varchar(2000));
192 create index idx3 on t1(vx_text(2000));
193 create index idx8 on t1(vx_blob(2000));
194 create index idx4 on t1(v1);
195 create index idx5 on t1(v2);
196 create index idx6 on t1(v3);
197 create index idx7 on t1(v4);
198 insert into t1 values(1,1,'111111111', '2011-07-11',
199 repeat('a',10000),
200 repeat('a',10000),
201 repeat('a',10000),
202 repeat('a',1000), repeat('a',1000),
203 repeat('a',1000), repeat('a',3000));
204 --error ER_UNDO_RECORD_TOO_BIG
205 update t1 set a=2,b=2,c='2222222222',d='2011-07-12',
206 vx_varchar=repeat('b',10000),
207 vx_text=repeat('b',10000),
208 vx_blob=repeat('b',10000),
209 v1=repeat('b',1000), v2=repeat('b',1000),
210 v3=repeat('b',1000), v4=repeat('b',3000);
211 drop table t1;
212
213 CREATE TABLE t1(x VARCHAR(300), y VARCHAR(200), KEY k1(y,x));
214 ALTER TABLE t1 ADD INDEX k2(x(10));
215 DROP TABLE t1;
216
217 let PREFIX_LEN=767;
218 --source ../include/default_row_format_large.inc
219
220 --exec $MYSQL -uroot test <$MYSQLTEST_VARDIR/tmp/create_table.sql
221 SHOW CREATE TABLE t1;
222
223 UPDATE t1 SET
224 c1=REPEAT('a', 65535),
225 c2=REPEAT('b', 65535),
226 c3=REPEAT('c', 65535),
227 c4=REPEAT('d', 65535),
228 c5=REPEAT('e', 65535),
229 c6=REPEAT('f', 65535),
230 c7=REPEAT('g', 65535),
231 c8=REPEAT('h', 65535),
232 c9=REPEAT('i', 65535),
233 c10=REPEAT('j', 65535),
234 c11=REPEAT('k', 65535),
235 c12=REPEAT('l', 65535),
236 c13=REPEAT('m', 65535),
237 c14=REPEAT('n', 65535),
238 c15=REPEAT('o', 65535);
239
240 --error ER_UNDO_RECORD_TOO_BIG
241 UPDATE t1 SET
242 c14=REPEAT('a', 65535),
243 c13=REPEAT('b', 65535),
244 c12=REPEAT('c', 65535),
245 c11=REPEAT('d', 65535),
246 c10=REPEAT('e', 65535),
247 c9=REPEAT('f', 65535),
248 c8=REPEAT('g', 65535),
249 c7=REPEAT('h', 65535),
250 c6=REPEAT('i', 65535),
251 c5=REPEAT('j', 65535),
252 c4=REPEAT('k', 65535),
253 c3=REPEAT('l', 65535),
254 c2=REPEAT('m', 65535),
255 c1=REPEAT('n', 65535);
256
257 UPDATE t1 SET
258 c14 = REPEAT('a', 65535);
259
260 DROP TABLE t1;
261
262 let PREFIX_LEN=3072;
263 --source ../include/default_row_format_large.inc
264
265 --exec $MYSQL -uroot test <$MYSQLTEST_VARDIR/tmp/create_table.sql
266 SHOW CREATE TABLE t1;
267
268 UPDATE t1 SET
269 c1=REPEAT('a', 65535),
270 c2=REPEAT('b', 65535),
271 c3=REPEAT('c', 65535),
272 c4=REPEAT('d', 65535),
273 c5=REPEAT('e', 65535),
274 c6=REPEAT('f', 65535),
275 c7=REPEAT('g', 65535),
276 c8=REPEAT('h', 65535),
277 c9=REPEAT('i', 65535),
278 c10=REPEAT('j', 65535),
279 c11=REPEAT('k', 65535),
280 c12=REPEAT('l', 65535),
281 c13=REPEAT('m', 65535),
282 c14=REPEAT('n', 65535),
283 c15=REPEAT('o', 65535);
284
285 --error ER_UNDO_RECORD_TOO_BIG
286 UPDATE t1 SET
287 c14=REPEAT('a', 65535),
288 c13=REPEAT('b', 65535),
289 c12=REPEAT('c', 65535),
290 c11=REPEAT('d', 65535),
291 c10=REPEAT('e', 65535),
292 c9=REPEAT('f', 65535),
293 c8=REPEAT('g', 65535),
294 c7=REPEAT('h', 65535),
295 c6=REPEAT('i', 65535),
296 c5=REPEAT('j', 65535),
297 c4=REPEAT('k', 65535),
298 c3=REPEAT('l', 65535),
299 c2=REPEAT('m', 65535),
300 c1=REPEAT('n', 65535);
301
302 --error ER_UNDO_RECORD_TOO_BIG
303 UPDATE t1 SET
304 c14 = REPEAT('a', 65535);
305
306 DROP TABLE t1;
307 --remove_file $MYSQLTEST_VARDIR/tmp/create_table.sql
308
309 --echo #
310 --echo # Bug#21880445 - FAILING ASSERTION: !FIELD->PREFIX_LEN ||
311 --echo # FIELD->FIXED_LEN == FIELD->PREFIX_LEN
312 --echo #
313
314 CREATE TABLE t1(
315 a CHAR(255) CHARACTER SET UTF32,
316 KEY k1(a(254))
317 ) ENGINE=INNODB;
318 DROP TABLE t1;
319
320 CREATE TABLE t1(
321 a VARCHAR(16383) CHARACTER SET UTF32,
322 KEY k1(a(768))
323 ) ENGINE=INNODB;
324 DROP TABLE t1;
325
326 CREATE TABLE t1(
327 a TEXT CHARACTER SET UTF32,
328 KEY k1(a(768))
329 ) ENGINE=INNODB;
330 DROP TABLE t1;
331
332 CREATE TABLE t1(
333 a CHAR(255) CHARACTER SET UTF32,
334 KEY k1(a)
335 )ENGINE=INNODB;
336 DROP TABLE t1;
337
338 CREATE TABLE t1(
339 a CHAR(20) CHARACTER SET UTF32,
340 KEY k1(a(5))
341 ) ENGINE=INNODB;
342 DROP TABLE t1;
343
344 CREATE TABLE t1(
345 a CHAR(255) CHARACTER SET UTF32,
346 KEY k1(a(195))
347 ) ENGINE=INNODB;
348 ALTER TABLE t1 ADD COLUMN b CHAR(255) CHARACTER SET UTF32;
349 ALTER TABLE t1 ADD COLUMN c CHAR(255) CHARACTER SET UTF32;
350 ALTER TABLE t1 ADD INDEX k2(b);
351 ALTER TABLE t1 ADD INDEX k3(c);
352 DROP TABLE t1;
353
354 CREATE TABLE t1(a VARCHAR(1000)) charset latin1 ROW_FORMAT=DYNAMIC;
355 CREATE INDEX idx1 ON t1(a);
356 --error ER_TOO_LONG_KEY
357 ALTER TABLE t1 ROW_FORMAT=COMPACT;
358 DROP TABLE t1;
359
360 --echo #
361 --echo # Bug#25579578 - FAILING ASSERTION: !FIELD->PREFIX_LEN ||
362 --echo # FIELD->FIXED_LEN == FIELD->PREFIX_LEN
363 --echo #
364
365 CREATE TABLE t1(a CHAR(255) CHARACTER SET UTF32,KEY k1(a(195))) ENGINE=INNODB;
366 INSERT INTO t1 VALUES(-233);
367 DROP TABLE t1;
368
369 CREATE TABLE t1(a CHAR(255) CHARACTER SET UTF32,KEY k1(a(195)));
370 INSERT INTO t1 VALUES('x');
371 DROP TABLE t1;
372
373 CREATE TABLE t1(a CHAR(255) CHARACTER SET latin1,KEY k1(a(195)));
374 INSERT INTO t1 VALUES('x');
375 DROP TABLE t1;
376
377 CREATE TABLE t1(a CHAR(255), KEY k1(a(195)));
378 INSERT INTO t1 VALUES('x');
379 DROP TABLE t1;