Debian Codegraph @

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

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