Debian Codegraph @

mysql-test/suite/engines/funcs/t/ai_overflow_error.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 SET SQL_MODE='TRADITIONAL';
5 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY );
6 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
8 SHOW CREATE TABLE t1;
9 --error 1264
10 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
11 --error 1264
12 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
13 SELECT * FROM t1;
14 DROP TABLE t1;
15 SHOW TABLES;
16 SET SQL_MODE='';
17 SET SQL_MODE='TRADITIONAL';
18 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY );
19 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
20 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
21 SHOW CREATE TABLE t1;
22 --error 1264
23 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
24 --error 1264
25 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
26 SELECT * FROM t1;
27 DROP TABLE t1;
28 SHOW TABLES;
29 SET SQL_MODE='';
30 SET SQL_MODE='TRADITIONAL';
31 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY );
32 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
33 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
34 SHOW CREATE TABLE t1;
35 --error 1264
36 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
37 --error 1264
38 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
39 SELECT * FROM t1;
40 DROP TABLE t1;
41 SHOW TABLES;
42 SET SQL_MODE='';
43 SET SQL_MODE='TRADITIONAL';
44 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY );
45 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
47 SHOW CREATE TABLE t1;
48 --error 1264
49 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
50 --error 1264
51 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
52 SELECT * FROM t1;
53 DROP TABLE t1;
54 SHOW TABLES;
55 SET SQL_MODE='';
56 SET SQL_MODE='TRADITIONAL';
57 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY );
58 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
59 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
60 SHOW CREATE TABLE t1;
61 --error 1264
62 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
63 --error 1264
64 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
65 SELECT * FROM t1;
66 DROP TABLE t1;
67 SHOW TABLES;
68 SET SQL_MODE='';
69 SET SQL_MODE='TRADITIONAL';
70 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY );
71 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
72 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
73 SHOW CREATE TABLE t1;
74 --error 1264
75 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
76 --error 1264
77 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
78 SELECT * FROM t1;
79 DROP TABLE t1;
80 SHOW TABLES;
81 SET SQL_MODE='';
82 SET SQL_MODE='TRADITIONAL';
83 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
84 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
85 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
86 SHOW CREATE TABLE t1;
87 --error 1264
88 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
89 --error 1264
90 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
91 SELECT * FROM t1;
92 DROP TABLE t1;
93 SHOW TABLES;
94 SET SQL_MODE='';
95 SET SQL_MODE='TRADITIONAL';
96 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
97 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
98 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
99 SHOW CREATE TABLE t1;
100 --error 1264
101 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
102 --error 1264
103 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
104 SELECT * FROM t1;
105 DROP TABLE t1;
106 SHOW TABLES;
107 SET SQL_MODE='';
108 SET SQL_MODE='TRADITIONAL';
109 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
110 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
111 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
112 SHOW CREATE TABLE t1;
113 --error 1264
114 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
115 --error 1264
116 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
117 SELECT * FROM t1;
118 DROP TABLE t1;
119 SHOW TABLES;
120 SET SQL_MODE='';
121 SET SQL_MODE='TRADITIONAL';
122 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
123 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
124 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
125 SHOW CREATE TABLE t1;
126 --error 1264
127 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
128 --error 1264
129 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
130 SELECT * FROM t1;
131 DROP TABLE t1;
132 SHOW TABLES;
133 SET SQL_MODE='';
134 SET SQL_MODE='TRADITIONAL';
135 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
136 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
137 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
138 SHOW CREATE TABLE t1;
139 --error 1264
140 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
141 --error 1264
142 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
143 SELECT * FROM t1;
144 DROP TABLE t1;
145 SHOW TABLES;
146 SET SQL_MODE='';
147 SET SQL_MODE='TRADITIONAL';
148 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
149 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
150 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
151 SHOW CREATE TABLE t1;
152 --error 1264
153 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
154 --error 1264
155 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
156 SELECT * FROM t1;
157 DROP TABLE t1;
158 SHOW TABLES;
159 SET SQL_MODE='';
160 SET SQL_MODE='TRADITIONAL';
161 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
162 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
163 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
164 SHOW CREATE TABLE t1;
165 --error 1264
166 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
167 --error 1264
168 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
169 SELECT * FROM t1;
170 DROP TABLE t1;
171 SHOW TABLES;
172 SET SQL_MODE='';
173 SET SQL_MODE='TRADITIONAL';
174 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
175 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
177 SHOW CREATE TABLE t1;
178 --error 1264
179 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
180 --error 1264
181 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
182 SELECT * FROM t1;
183 DROP TABLE t1;
184 SHOW TABLES;
185 SET SQL_MODE='';
186 SET SQL_MODE='TRADITIONAL';
187 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
188 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
189 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
190 SHOW CREATE TABLE t1;
191 --error 1264
192 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
193 --error 1264
194 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
195 SELECT * FROM t1;
196 DROP TABLE t1;
197 SHOW TABLES;
198 SET SQL_MODE='';
199 SET SQL_MODE='TRADITIONAL';
200 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
201 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
202 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
203 SHOW CREATE TABLE t1;
204 --error 1264
205 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
206 --error 1264
207 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
208 SELECT * FROM t1;
209 DROP TABLE t1;
210 SHOW TABLES;
211 SET SQL_MODE='';
212 SET SQL_MODE='TRADITIONAL';
213 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
214 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
215 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
216 SHOW CREATE TABLE t1;
217 --error 1264
218 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
219 --error 1264
220 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
221 SELECT * FROM t1;
222 DROP TABLE t1;
223 SHOW TABLES;
224 SET SQL_MODE='';
225 SET SQL_MODE='TRADITIONAL';
226 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
227 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
228 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
229 SHOW CREATE TABLE t1;
230 --error 1264
231 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
232 --error 1264
233 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
234 SELECT * FROM t1;
235 DROP TABLE t1;
236 SHOW TABLES;
237 SET SQL_MODE='';
238 SET SQL_MODE='TRADITIONAL';
239 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
240 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
241 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
242 SHOW CREATE TABLE t1;
243 --error 1264
244 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
245 --error 1264
246 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
247 SELECT * FROM t1;
248 DROP TABLE t1;
249 SHOW TABLES;
250 SET SQL_MODE='';
251 SET SQL_MODE='TRADITIONAL';
252 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
253 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
254 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
255 SHOW CREATE TABLE t1;
256 --error 1264
257 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
258 --error 1264
259 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
260 SELECT * FROM t1;
261 DROP TABLE t1;
262 SHOW TABLES;
263 SET SQL_MODE='';
264 SET SQL_MODE='TRADITIONAL';
265 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
266 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
267 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
268 SHOW CREATE TABLE t1;
269 --error 1264
270 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
271 --error 1264
272 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
273 SELECT * FROM t1;
274 DROP TABLE t1;
275 SHOW TABLES;
276 SET SQL_MODE='';
277 SET SQL_MODE='TRADITIONAL';
278 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
279 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
280 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
281 SHOW CREATE TABLE t1;
282 --error 1264
283 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
284 --error 1264
285 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
286 SELECT * FROM t1;
287 DROP TABLE t1;
288 SHOW TABLES;
289 SET SQL_MODE='';
290 SET SQL_MODE='TRADITIONAL';
291 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
292 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
293 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
294 SHOW CREATE TABLE t1;
295 --error 1264
296 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
297 --error 1264
298 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
299 SELECT * FROM t1;
300 DROP TABLE t1;
301 SHOW TABLES;
302 SET SQL_MODE='';
303 SET SQL_MODE='TRADITIONAL';
304 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
305 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
306 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
307 SHOW CREATE TABLE t1;
308 --error 1264
309 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
310 --error 1264
311 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
312 SELECT * FROM t1;
313 DROP TABLE t1;
314 SHOW TABLES;
315 SET SQL_MODE='';
316 SET SQL_MODE='TRADITIONAL';
317 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
318 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
319 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
320 SHOW CREATE TABLE t1;
321 --error 1264
322 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
323 --error 1264
324 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
325 SELECT * FROM t1;
326 DROP TABLE t1;
327 SHOW TABLES;
328 SET SQL_MODE='';
329 SET SQL_MODE='TRADITIONAL';
330 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
331 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
332 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
333 SHOW CREATE TABLE t1;
334 --error 1264
335 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
336 --error 1264
337 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
338 SELECT * FROM t1;
339 DROP TABLE t1;
340 SHOW TABLES;
341 SET SQL_MODE='';
342 SET SQL_MODE='TRADITIONAL';
343 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
344 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
345 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
346 SHOW CREATE TABLE t1;
347 --error 1264
348 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
349 --error 1264
350 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
351 SELECT * FROM t1;
352 DROP TABLE t1;
353 SHOW TABLES;
354 SET SQL_MODE='';
355 SET SQL_MODE='TRADITIONAL';
356 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
357 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
358 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
359 SHOW CREATE TABLE t1;
360 --error 1264
361 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
362 --error 1264
363 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
364 SELECT * FROM t1;
365 DROP TABLE t1;
366 SHOW TABLES;
367 SET SQL_MODE='';
368 SET SQL_MODE='TRADITIONAL';
369 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
370 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
371 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
372 SHOW CREATE TABLE t1;
373 --error 1264
374 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
375 --error 1264
376 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
377 SELECT * FROM t1;
378 DROP TABLE t1;
379 SHOW TABLES;
380 SET SQL_MODE='';
381 SET SQL_MODE='TRADITIONAL';
382 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
383 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
384 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
385 SHOW CREATE TABLE t1;
386 --error 1264
387 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
388 --error 1264
389 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
390 SELECT * FROM t1;
391 DROP TABLE t1;
392 SHOW TABLES;
393 SET SQL_MODE='';
394 SET SQL_MODE='TRADITIONAL';
395 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY );
396 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
397 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
398 SHOW CREATE TABLE t1;
399 --error 1264
400 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
401 --error 1264
402 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
403 SELECT * FROM t1;
404 DROP TABLE t1;
405 SHOW TABLES;
406 SET SQL_MODE='';
407 SET SQL_MODE='TRADITIONAL';
408 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY );
409 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
410 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
411 SHOW CREATE TABLE t1;
412 --error 1264
413 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
414 --error 1264
415 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
416 SELECT * FROM t1;
417 DROP TABLE t1;
418 SHOW TABLES;
419 SET SQL_MODE='';
420 SET SQL_MODE='TRADITIONAL';
421 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY );
422 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
423 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
424 SHOW CREATE TABLE t1;
425 --error 1264
426 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
427 --error 1264
428 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
429 SELECT * FROM t1;
430 DROP TABLE t1;
431 SHOW TABLES;
432 SET SQL_MODE='';
433 SET SQL_MODE='TRADITIONAL';
434 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY );
435 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
436 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
437 SHOW CREATE TABLE t1;
438 --error 1264
439 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
440 --error 1264
441 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
442 SELECT * FROM t1;
443 DROP TABLE t1;
444 SHOW TABLES;
445 SET SQL_MODE='';
446 SET SQL_MODE='TRADITIONAL';
447 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
448 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
449 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
450 SHOW CREATE TABLE t1;
451 --error 1264
452 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
453 --error 1264
454 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
455 SELECT * FROM t1;
456 DROP TABLE t1;
457 SHOW TABLES;
458 SET SQL_MODE='';
459 SET SQL_MODE='TRADITIONAL';
460 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY );
461 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
462 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
463 SHOW CREATE TABLE t1;
464 --error 1264
465 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
466 --error 1264
467 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
468 SELECT * FROM t1;
469 DROP TABLE t1;
470 SHOW TABLES;
471 SET SQL_MODE='';
472 SET SQL_MODE='TRADITIONAL';
473 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
474 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
475 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
476 SHOW CREATE TABLE t1;
477 --error 1264
478 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
479 --error 1264
480 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
481 SELECT * FROM t1;
482 DROP TABLE t1;
483 SHOW TABLES;
484 SET SQL_MODE='';
485 SET SQL_MODE='TRADITIONAL';
486 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
487 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
488 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
489 SHOW CREATE TABLE t1;
490 --error 1264
491 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
492 --error 1264
493 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
494 SELECT * FROM t1;
495 DROP TABLE t1;
496 SHOW TABLES;
497 SET SQL_MODE='';
498 SET SQL_MODE='TRADITIONAL';
499 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
500 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
501 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
502 SHOW CREATE TABLE t1;
503 --error 1264
504 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
505 --error 1264
506 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
507 SELECT * FROM t1;
508 DROP TABLE t1;
509 SHOW TABLES;
510 SET SQL_MODE='';
511 SET SQL_MODE='TRADITIONAL';
512 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
513 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
514 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
515 SHOW CREATE TABLE t1;
516 --error 1264
517 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
518 --error 1264
519 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
520 SELECT * FROM t1;
521 DROP TABLE t1;
522 SHOW TABLES;
523 SET SQL_MODE='';
524 SET SQL_MODE='TRADITIONAL';
525 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
526 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
527 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
528 SHOW CREATE TABLE t1;
529 --error 1264
530 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
531 --error 1264
532 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
533 SELECT * FROM t1;
534 DROP TABLE t1;
535 SHOW TABLES;
536 SET SQL_MODE='';
537 SET SQL_MODE='TRADITIONAL';
538 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
539 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
540 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
541 SHOW CREATE TABLE t1;
542 --error 1264
543 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
544 --error 1264
545 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
546 SELECT * FROM t1;
547 DROP TABLE t1;
548 SHOW TABLES;
549 SET SQL_MODE='';
550 SET SQL_MODE='TRADITIONAL';
551 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
552 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
553 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
554 SHOW CREATE TABLE t1;
555 --error 1264
556 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
557 --error 1264
558 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
559 SELECT * FROM t1;
560 DROP TABLE t1;
561 SHOW TABLES;
562 SET SQL_MODE='';
563 SET SQL_MODE='TRADITIONAL';
564 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
565 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
566 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
567 SHOW CREATE TABLE t1;
568 --error 1264
569 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
570 --error 1264
571 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
572 SELECT * FROM t1;
573 DROP TABLE t1;
574 SHOW TABLES;
575 SET SQL_MODE='';
576 SET SQL_MODE='TRADITIONAL';
577 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
578 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
579 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
580 SHOW CREATE TABLE t1;
581 --error 1264
582 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
583 --error 1264
584 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
585 SELECT * FROM t1;
586 DROP TABLE t1;
587 SHOW TABLES;
588 SET SQL_MODE='';
589 SET SQL_MODE='TRADITIONAL';
590 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
591 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
592 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
593 SHOW CREATE TABLE t1;
594 --error 1264
595 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
596 --error 1264
597 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
598 SELECT * FROM t1;
599 DROP TABLE t1;
600 SHOW TABLES;
601 SET SQL_MODE='';
602 SET SQL_MODE='TRADITIONAL';
603 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
604 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
605 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
606 SHOW CREATE TABLE t1;
607 --error 1264
608 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
609 --error 1264
610 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
611 SELECT * FROM t1;
612 DROP TABLE t1;
613 SHOW TABLES;
614 SET SQL_MODE='';
615 SET SQL_MODE='TRADITIONAL';
616 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
617 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
618 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
619 SHOW CREATE TABLE t1;
620 --error 1264
621 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
622 --error 1264
623 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
624 SELECT * FROM t1;
625 DROP TABLE t1;
626 SHOW TABLES;
627 SET SQL_MODE='';
628 SET SQL_MODE='TRADITIONAL';
629 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
630 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
631 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
632 SHOW CREATE TABLE t1;
633 --error 1264
634 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
635 --error 1264
636 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
637 SELECT * FROM t1;
638 DROP TABLE t1;
639 SHOW TABLES;
640 SET SQL_MODE='';
641 SET SQL_MODE='TRADITIONAL';
642 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
643 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
644 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
645 SHOW CREATE TABLE t1;
646 --error 1264
647 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
648 --error 1264
649 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
650 SELECT * FROM t1;
651 DROP TABLE t1;
652 SHOW TABLES;
653 SET SQL_MODE='';
654 SET SQL_MODE='TRADITIONAL';
655 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
656 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
657 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
658 SHOW CREATE TABLE t1;
659 --error 1264
660 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
661 --error 1264
662 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
663 SELECT * FROM t1;
664 DROP TABLE t1;
665 SHOW TABLES;
666 SET SQL_MODE='';
667 SET SQL_MODE='TRADITIONAL';
668 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
669 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
670 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
671 SHOW CREATE TABLE t1;
672 --error 1264
673 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
674 --error 1264
675 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
676 SELECT * FROM t1;
677 DROP TABLE t1;
678 SHOW TABLES;
679 SET SQL_MODE='';
680 SET SQL_MODE='TRADITIONAL';
681 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
682 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
683 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
684 SHOW CREATE TABLE t1;
685 --error 1264
686 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
687 --error 1264
688 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
689 SELECT * FROM t1;
690 DROP TABLE t1;
691 SHOW TABLES;
692 SET SQL_MODE='';
693 SET SQL_MODE='TRADITIONAL';
694 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
695 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
696 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
697 SHOW CREATE TABLE t1;
698 --error 1264
699 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
700 --error 1264
701 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
702 SELECT * FROM t1;
703 DROP TABLE t1;
704 SHOW TABLES;
705 SET SQL_MODE='';
706 SET SQL_MODE='TRADITIONAL';
707 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
708 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
709 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
710 SHOW CREATE TABLE t1;
711 --error 1264
712 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
713 --error 1264
714 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
715 SELECT * FROM t1;
716 DROP TABLE t1;
717 SHOW TABLES;
718 SET SQL_MODE='';
719 SET SQL_MODE='TRADITIONAL';
720 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
721 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
722 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
723 SHOW CREATE TABLE t1;
724 --error 1264
725 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
726 --error 1264
727 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
728 SELECT * FROM t1;
729 DROP TABLE t1;
730 SHOW TABLES;
731 SET SQL_MODE='';
732 SET SQL_MODE='TRADITIONAL';
733 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
734 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
735 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
736 SHOW CREATE TABLE t1;
737 --error 1264
738 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
739 --error 1264
740 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
741 SELECT * FROM t1;
742 DROP TABLE t1;
743 SHOW TABLES;
744 SET SQL_MODE='';
745 SET SQL_MODE='TRADITIONAL';
746 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
747 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
748 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
749 SHOW CREATE TABLE t1;
750 --error 1264
751 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
752 --error 1264
753 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
754 SELECT * FROM t1;
755 DROP TABLE t1;
756 SHOW TABLES;
757 SET SQL_MODE='';
758 SET SQL_MODE='TRADITIONAL';
759 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
760 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
761 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
762 SHOW CREATE TABLE t1;
763 --error 1264
764 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
765 --error 1264
766 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
767 SELECT * FROM t1;
768 DROP TABLE t1;
769 SHOW TABLES;
770 SET SQL_MODE='';
771 SET SQL_MODE='TRADITIONAL';
772 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
773 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
774 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
775 SHOW CREATE TABLE t1;
776 --error 1264
777 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
778 --error 1264
779 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
780 SELECT * FROM t1;
781 DROP TABLE t1;
782 SHOW TABLES;
783 SET SQL_MODE='';
784