Debian Codegraph @

mysql-test/suite/engines/funcs/r/ai_overflow_error.result

raw
1 DROP TABLE IF EXISTS t1;
2 SET SQL_MODE='TRADITIONAL';
3 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
4 SHOW CREATE TABLE t1;
5 Table Create Table
6 t1 CREATE TABLE `t1` (
7 `c1` tinyint NOT NULL AUTO_INCREMENT,
8 PRIMARY KEY (`c1`)
9 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
10 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
11 ERROR 22003: Out of range value for column 'c1' at row 1
12 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
13 ERROR 22003: Out of range value for column 'c1' at row 1
14 SELECT * FROM t1;
15 c1
16 DROP TABLE t1;
17 SHOW TABLES;
18 Tables_in_test
19 SET SQL_MODE='';
20 SET SQL_MODE='TRADITIONAL';
21 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
22 SHOW CREATE TABLE t1;
23 Table Create Table
24 t1 CREATE TABLE `t1` (
25 `c1` smallint NOT NULL AUTO_INCREMENT,
26 PRIMARY KEY (`c1`)
27 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
28 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
29 ERROR 22003: Out of range value for column 'c1' at row 1
30 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
31 ERROR 22003: Out of range value for column 'c1' at row 1
32 SELECT * FROM t1;
33 c1
34 DROP TABLE t1;
35 SHOW TABLES;
36 Tables_in_test
37 SET SQL_MODE='';
38 SET SQL_MODE='TRADITIONAL';
39 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
40 SHOW CREATE TABLE t1;
41 Table Create Table
42 t1 CREATE TABLE `t1` (
43 `c1` mediumint NOT NULL AUTO_INCREMENT,
44 PRIMARY KEY (`c1`)
45 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
46 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
47 ERROR 22003: Out of range value for column 'c1' at row 1
48 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
49 ERROR 22003: Out of range value for column 'c1' at row 1
50 SELECT * FROM t1;
51 c1
52 DROP TABLE t1;
53 SHOW TABLES;
54 Tables_in_test
55 SET SQL_MODE='';
56 SET SQL_MODE='TRADITIONAL';
57 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
58 SHOW CREATE TABLE t1;
59 Table Create Table
60 t1 CREATE TABLE `t1` (
61 `c1` int NOT NULL AUTO_INCREMENT,
62 PRIMARY KEY (`c1`)
63 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
64 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
65 ERROR 22003: Out of range value for column 'c1' at row 1
66 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
67 ERROR 22003: Out of range value for column 'c1' at row 1
68 SELECT * FROM t1;
69 c1
70 DROP TABLE t1;
71 SHOW TABLES;
72 Tables_in_test
73 SET SQL_MODE='';
74 SET SQL_MODE='TRADITIONAL';
75 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
76 SHOW CREATE TABLE t1;
77 Table Create Table
78 t1 CREATE TABLE `t1` (
79 `c1` int NOT NULL AUTO_INCREMENT,
80 PRIMARY KEY (`c1`)
81 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
82 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
83 ERROR 22003: Out of range value for column 'c1' at row 1
84 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
85 ERROR 22003: Out of range value for column 'c1' at row 1
86 SELECT * FROM t1;
87 c1
88 DROP TABLE t1;
89 SHOW TABLES;
90 Tables_in_test
91 SET SQL_MODE='';
92 SET SQL_MODE='TRADITIONAL';
93 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
94 SHOW CREATE TABLE t1;
95 Table Create Table
96 t1 CREATE TABLE `t1` (
97 `c1` bigint NOT NULL AUTO_INCREMENT,
98 PRIMARY KEY (`c1`)
99 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
100 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
101 ERROR 22003: Out of range value for column 'c1' at row 1
102 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
103 ERROR 22003: Out of range value for column 'c1' at row 1
104 SELECT * FROM t1;
105 c1
106 DROP TABLE t1;
107 SHOW TABLES;
108 Tables_in_test
109 SET SQL_MODE='';
110 SET SQL_MODE='TRADITIONAL';
111 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
112 SHOW CREATE TABLE t1;
113 Table Create Table
114 t1 CREATE TABLE `t1` (
115 `c1` tinyint NOT NULL AUTO_INCREMENT,
116 PRIMARY KEY (`c1`)
117 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
118 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
119 ERROR 22003: Out of range value for column 'c1' at row 1
120 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
121 ERROR 22003: Out of range value for column 'c1' at row 1
122 SELECT * FROM t1;
123 c1
124 DROP TABLE t1;
125 SHOW TABLES;
126 Tables_in_test
127 SET SQL_MODE='';
128 SET SQL_MODE='TRADITIONAL';
129 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
130 SHOW CREATE TABLE t1;
131 Table Create Table
132 t1 CREATE TABLE `t1` (
133 `c1` smallint NOT NULL AUTO_INCREMENT,
134 PRIMARY KEY (`c1`)
135 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
136 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
137 ERROR 22003: Out of range value for column 'c1' at row 1
138 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
139 ERROR 22003: Out of range value for column 'c1' at row 1
140 SELECT * FROM t1;
141 c1
142 DROP TABLE t1;
143 SHOW TABLES;
144 Tables_in_test
145 SET SQL_MODE='';
146 SET SQL_MODE='TRADITIONAL';
147 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
148 SHOW CREATE TABLE t1;
149 Table Create Table
150 t1 CREATE TABLE `t1` (
151 `c1` mediumint NOT NULL AUTO_INCREMENT,
152 PRIMARY KEY (`c1`)
153 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
154 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
155 ERROR 22003: Out of range value for column 'c1' at row 1
156 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
157 ERROR 22003: Out of range value for column 'c1' at row 1
158 SELECT * FROM t1;
159 c1
160 DROP TABLE t1;
161 SHOW TABLES;
162 Tables_in_test
163 SET SQL_MODE='';
164 SET SQL_MODE='TRADITIONAL';
165 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
166 SHOW CREATE TABLE t1;
167 Table Create Table
168 t1 CREATE TABLE `t1` (
169 `c1` int NOT NULL AUTO_INCREMENT,
170 PRIMARY KEY (`c1`)
171 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
172 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
173 ERROR 22003: Out of range value for column 'c1' at row 1
174 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
175 ERROR 22003: Out of range value for column 'c1' at row 1
176 SELECT * FROM t1;
177 c1
178 DROP TABLE t1;
179 SHOW TABLES;
180 Tables_in_test
181 SET SQL_MODE='';
182 SET SQL_MODE='TRADITIONAL';
183 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
184 SHOW CREATE TABLE t1;
185 Table Create Table
186 t1 CREATE TABLE `t1` (
187 `c1` int NOT NULL AUTO_INCREMENT,
188 PRIMARY KEY (`c1`)
189 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
190 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
191 ERROR 22003: Out of range value for column 'c1' at row 1
192 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
193 ERROR 22003: Out of range value for column 'c1' at row 1
194 SELECT * FROM t1;
195 c1
196 DROP TABLE t1;
197 SHOW TABLES;
198 Tables_in_test
199 SET SQL_MODE='';
200 SET SQL_MODE='TRADITIONAL';
201 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
202 SHOW CREATE TABLE t1;
203 Table Create Table
204 t1 CREATE TABLE `t1` (
205 `c1` bigint NOT NULL AUTO_INCREMENT,
206 PRIMARY KEY (`c1`)
207 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
208 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
209 ERROR 22003: Out of range value for column 'c1' at row 1
210 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
211 ERROR 22003: Out of range value for column 'c1' at row 1
212 SELECT * FROM t1;
213 c1
214 DROP TABLE t1;
215 SHOW TABLES;
216 Tables_in_test
217 SET SQL_MODE='';
218 SET SQL_MODE='TRADITIONAL';
219 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
220 SHOW CREATE TABLE t1;
221 Table Create Table
222 t1 CREATE TABLE `t1` (
223 `c1` tinyint AUTO_INCREMENT,
224 UNIQUE KEY `c1` (`c1`)
225 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
226 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
227 ERROR 22003: Out of range value for column 'c1' at row 1
228 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
229 ERROR 22003: Out of range value for column 'c1' at row 1
230 SELECT * FROM t1;
231 c1
232 DROP TABLE t1;
233 SHOW TABLES;
234 Tables_in_test
235 SET SQL_MODE='';
236 SET SQL_MODE='TRADITIONAL';
237 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
238 SHOW CREATE TABLE t1;
239 Table Create Table
240 t1 CREATE TABLE `t1` (
241 `c1` smallint AUTO_INCREMENT,
242 UNIQUE KEY `c1` (`c1`)
243 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
244 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
245 ERROR 22003: Out of range value for column 'c1' at row 1
246 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
247 ERROR 22003: Out of range value for column 'c1' at row 1
248 SELECT * FROM t1;
249 c1
250 DROP TABLE t1;
251 SHOW TABLES;
252 Tables_in_test
253 SET SQL_MODE='';
254 SET SQL_MODE='TRADITIONAL';
255 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
256 SHOW CREATE TABLE t1;
257 Table Create Table
258 t1 CREATE TABLE `t1` (
259 `c1` mediumint AUTO_INCREMENT,
260 UNIQUE KEY `c1` (`c1`)
261 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
262 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
263 ERROR 22003: Out of range value for column 'c1' at row 1
264 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
265 ERROR 22003: Out of range value for column 'c1' at row 1
266 SELECT * FROM t1;
267 c1
268 DROP TABLE t1;
269 SHOW TABLES;
270 Tables_in_test
271 SET SQL_MODE='';
272 SET SQL_MODE='TRADITIONAL';
273 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
274 SHOW CREATE TABLE t1;
275 Table Create Table
276 t1 CREATE TABLE `t1` (
277 `c1` int AUTO_INCREMENT,
278 UNIQUE KEY `c1` (`c1`)
279 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
280 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
281 ERROR 22003: Out of range value for column 'c1' at row 1
282 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
283 ERROR 22003: Out of range value for column 'c1' at row 1
284 SELECT * FROM t1;
285 c1
286 DROP TABLE t1;
287 SHOW TABLES;
288 Tables_in_test
289 SET SQL_MODE='';
290 SET SQL_MODE='TRADITIONAL';
291 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
292 SHOW CREATE TABLE t1;
293 Table Create Table
294 t1 CREATE TABLE `t1` (
295 `c1` int AUTO_INCREMENT,
296 UNIQUE KEY `c1` (`c1`)
297 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
298 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
299 ERROR 22003: Out of range value for column 'c1' at row 1
300 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
301 ERROR 22003: Out of range value for column 'c1' at row 1
302 SELECT * FROM t1;
303 c1
304 DROP TABLE t1;
305 SHOW TABLES;
306 Tables_in_test
307 SET SQL_MODE='';
308 SET SQL_MODE='TRADITIONAL';
309 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
310 SHOW CREATE TABLE t1;
311 Table Create Table
312 t1 CREATE TABLE `t1` (
313 `c1` bigint AUTO_INCREMENT,
314 UNIQUE KEY `c1` (`c1`)
315 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
316 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
317 ERROR 22003: Out of range value for column 'c1' at row 1
318 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
319 ERROR 22003: Out of range value for column 'c1' at row 1
320 SELECT * FROM t1;
321 c1
322 DROP TABLE t1;
323 SHOW TABLES;
324 Tables_in_test
325 SET SQL_MODE='';
326 SET SQL_MODE='TRADITIONAL';
327 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
328 SHOW CREATE TABLE t1;
329 Table Create Table
330 t1 CREATE TABLE `t1` (
331 `c1` tinyint NOT NULL AUTO_INCREMENT,
332 UNIQUE KEY `c1` (`c1`)
333 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
334 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
335 ERROR 22003: Out of range value for column 'c1' at row 1
336 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
337 ERROR 22003: Out of range value for column 'c1' at row 1
338 SELECT * FROM t1;
339 c1
340 DROP TABLE t1;
341 SHOW TABLES;
342 Tables_in_test
343 SET SQL_MODE='';
344 SET SQL_MODE='TRADITIONAL';
345 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
346 SHOW CREATE TABLE t1;
347 Table Create Table
348 t1 CREATE TABLE `t1` (
349 `c1` smallint NOT NULL AUTO_INCREMENT,
350 UNIQUE KEY `c1` (`c1`)
351 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
352 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
353 ERROR 22003: Out of range value for column 'c1' at row 1
354 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
355 ERROR 22003: Out of range value for column 'c1' at row 1
356 SELECT * FROM t1;
357 c1
358 DROP TABLE t1;
359 SHOW TABLES;
360 Tables_in_test
361 SET SQL_MODE='';
362 SET SQL_MODE='TRADITIONAL';
363 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
364 SHOW CREATE TABLE t1;
365 Table Create Table
366 t1 CREATE TABLE `t1` (
367 `c1` mediumint NOT NULL AUTO_INCREMENT,
368 UNIQUE KEY `c1` (`c1`)
369 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
370 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
371 ERROR 22003: Out of range value for column 'c1' at row 1
372 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
373 ERROR 22003: Out of range value for column 'c1' at row 1
374 SELECT * FROM t1;
375 c1
376 DROP TABLE t1;
377 SHOW TABLES;
378 Tables_in_test
379 SET SQL_MODE='';
380 SET SQL_MODE='TRADITIONAL';
381 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
382 SHOW CREATE TABLE t1;
383 Table Create Table
384 t1 CREATE TABLE `t1` (
385 `c1` int NOT NULL AUTO_INCREMENT,
386 UNIQUE KEY `c1` (`c1`)
387 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
388 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
389 ERROR 22003: Out of range value for column 'c1' at row 1
390 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
391 ERROR 22003: Out of range value for column 'c1' at row 1
392 SELECT * FROM t1;
393 c1
394 DROP TABLE t1;
395 SHOW TABLES;
396 Tables_in_test
397 SET SQL_MODE='';
398 SET SQL_MODE='TRADITIONAL';
399 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
400 SHOW CREATE TABLE t1;
401 Table Create Table
402 t1 CREATE TABLE `t1` (
403 `c1` int NOT NULL AUTO_INCREMENT,
404 UNIQUE KEY `c1` (`c1`)
405 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
406 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
407 ERROR 22003: Out of range value for column 'c1' at row 1
408 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
409 ERROR 22003: Out of range value for column 'c1' at row 1
410 SELECT * FROM t1;
411 c1
412 DROP TABLE t1;
413 SHOW TABLES;
414 Tables_in_test
415 SET SQL_MODE='';
416 SET SQL_MODE='TRADITIONAL';
417 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
418 SHOW CREATE TABLE t1;
419 Table Create Table
420 t1 CREATE TABLE `t1` (
421 `c1` bigint NOT NULL AUTO_INCREMENT,
422 UNIQUE KEY `c1` (`c1`)
423 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
424 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
425 ERROR 22003: Out of range value for column 'c1' at row 1
426 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
427 ERROR 22003: Out of range value for column 'c1' at row 1
428 SELECT * FROM t1;
429 c1
430 DROP TABLE t1;
431 SHOW TABLES;
432 Tables_in_test
433 SET SQL_MODE='';
434 SET SQL_MODE='TRADITIONAL';
435 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
436 SHOW CREATE TABLE t1;
437 Table Create Table
438 t1 CREATE TABLE `t1` (
439 `c1` tinyint NOT NULL AUTO_INCREMENT,
440 PRIMARY KEY (`c1`)
441 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
442 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
443 ERROR 22003: Out of range value for column 'c1' at row 1
444 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
445 ERROR 22003: Out of range value for column 'c1' at row 1
446 SELECT * FROM t1;
447 c1
448 DROP TABLE t1;
449 SHOW TABLES;
450 Tables_in_test
451 SET SQL_MODE='';
452 SET SQL_MODE='TRADITIONAL';
453 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
454 SHOW CREATE TABLE t1;
455 Table Create Table
456 t1 CREATE TABLE `t1` (
457 `c1` smallint NOT NULL AUTO_INCREMENT,
458 PRIMARY KEY (`c1`)
459 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
460 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
461 ERROR 22003: Out of range value for column 'c1' at row 1
462 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
463 ERROR 22003: Out of range value for column 'c1' at row 1
464 SELECT * FROM t1;
465 c1
466 DROP TABLE t1;
467 SHOW TABLES;
468 Tables_in_test
469 SET SQL_MODE='';
470 SET SQL_MODE='TRADITIONAL';
471 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
472 SHOW CREATE TABLE t1;
473 Table Create Table
474 t1 CREATE TABLE `t1` (
475 `c1` mediumint NOT NULL AUTO_INCREMENT,
476 PRIMARY KEY (`c1`)
477 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
478 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
479 ERROR 22003: Out of range value for column 'c1' at row 1
480 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
481 ERROR 22003: Out of range value for column 'c1' at row 1
482 SELECT * FROM t1;
483 c1
484 DROP TABLE t1;
485 SHOW TABLES;
486 Tables_in_test
487 SET SQL_MODE='';
488 SET SQL_MODE='TRADITIONAL';
489 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
490 SHOW CREATE TABLE t1;
491 Table Create Table
492 t1 CREATE TABLE `t1` (
493 `c1` int NOT NULL AUTO_INCREMENT,
494 PRIMARY KEY (`c1`)
495 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
496 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
497 ERROR 22003: Out of range value for column 'c1' at row 1
498 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
499 ERROR 22003: Out of range value for column 'c1' at row 1
500 SELECT * FROM t1;
501 c1
502 DROP TABLE t1;
503 SHOW TABLES;
504 Tables_in_test
505 SET SQL_MODE='';
506 SET SQL_MODE='TRADITIONAL';
507 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
508 SHOW CREATE TABLE t1;
509 Table Create Table
510 t1 CREATE TABLE `t1` (
511 `c1` int NOT NULL AUTO_INCREMENT,
512 PRIMARY KEY (`c1`)
513 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
514 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
515 ERROR 22003: Out of range value for column 'c1' at row 1
516 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
517 ERROR 22003: Out of range value for column 'c1' at row 1
518 SELECT * FROM t1;
519 c1
520 DROP TABLE t1;
521 SHOW TABLES;
522 Tables_in_test
523 SET SQL_MODE='';
524 SET SQL_MODE='TRADITIONAL';
525 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
526 SHOW CREATE TABLE t1;
527 Table Create Table
528 t1 CREATE TABLE `t1` (
529 `c1` bigint NOT NULL AUTO_INCREMENT,
530 PRIMARY KEY (`c1`)
531 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
532 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
533 ERROR 22003: Out of range value for column 'c1' at row 1
534 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
535 ERROR 22003: Out of range value for column 'c1' at row 1
536 SELECT * FROM t1;
537 c1
538 DROP TABLE t1;
539 SHOW TABLES;
540 Tables_in_test
541 SET SQL_MODE='';
542 SET SQL_MODE='TRADITIONAL';
543 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
544 SHOW CREATE TABLE t1;
545 Table Create Table
546 t1 CREATE TABLE `t1` (
547 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
548 PRIMARY KEY (`c1`)
549 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
550 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
551 ERROR 22003: Out of range value for column 'c1' at row 1
552 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
553 ERROR 22003: Out of range value for column 'c1' at row 1
554 SELECT * FROM t1;
555 c1
556 DROP TABLE t1;
557 SHOW TABLES;
558 Tables_in_test
559 SET SQL_MODE='';
560 SET SQL_MODE='TRADITIONAL';
561 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
562 SHOW CREATE TABLE t1;
563 Table Create Table
564 t1 CREATE TABLE `t1` (
565 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
566 PRIMARY KEY (`c1`)
567 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
568 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
569 ERROR 22003: Out of range value for column 'c1' at row 1
570 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
571 ERROR 22003: Out of range value for column 'c1' at row 1
572 SELECT * FROM t1;
573 c1
574 DROP TABLE t1;
575 SHOW TABLES;
576 Tables_in_test
577 SET SQL_MODE='';
578 SET SQL_MODE='TRADITIONAL';
579 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
580 SHOW CREATE TABLE t1;
581 Table Create Table
582 t1 CREATE TABLE `t1` (
583 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
584 PRIMARY KEY (`c1`)
585 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
586 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
587 ERROR 22003: Out of range value for column 'c1' at row 1
588 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
589 ERROR 22003: Out of range value for column 'c1' at row 1
590 SELECT * FROM t1;
591 c1
592 DROP TABLE t1;
593 SHOW TABLES;
594 Tables_in_test
595 SET SQL_MODE='';
596 SET SQL_MODE='TRADITIONAL';
597 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
598 SHOW CREATE TABLE t1;
599 Table Create Table
600 t1 CREATE TABLE `t1` (
601 `c1` int unsigned NOT NULL AUTO_INCREMENT,
602 PRIMARY KEY (`c1`)
603 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
604 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
605 ERROR 22003: Out of range value for column 'c1' at row 1
606 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
607 ERROR 22003: Out of range value for column 'c1' at row 1
608 SELECT * FROM t1;
609 c1
610 DROP TABLE t1;
611 SHOW TABLES;
612 Tables_in_test
613 SET SQL_MODE='';
614 SET SQL_MODE='TRADITIONAL';
615 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
616 SHOW CREATE TABLE t1;
617 Table Create Table
618 t1 CREATE TABLE `t1` (
619 `c1` int unsigned NOT NULL AUTO_INCREMENT,
620 PRIMARY KEY (`c1`)
621 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
622 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
623 ERROR 22003: Out of range value for column 'c1' at row 1
624 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
625 ERROR 22003: Out of range value for column 'c1' at row 1
626 SELECT * FROM t1;
627 c1
628 DROP TABLE t1;
629 SHOW TABLES;
630 Tables_in_test
631 SET SQL_MODE='';
632 SET SQL_MODE='TRADITIONAL';
633 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
634 SHOW CREATE TABLE t1;
635 Table Create Table
636 t1 CREATE TABLE `t1` (
637 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
638 PRIMARY KEY (`c1`)
639 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
640 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
641 ERROR 22003: Out of range value for column 'c1' at row 1
642 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
643 ERROR 22003: Out of range value for column 'c1' at row 1
644 SELECT * FROM t1;
645 c1
646 DROP TABLE t1;
647 SHOW TABLES;
648 Tables_in_test
649 SET SQL_MODE='';
650 SET SQL_MODE='TRADITIONAL';
651 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
652 SHOW CREATE TABLE t1;
653 Table Create Table
654 t1 CREATE TABLE `t1` (
655 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
656 PRIMARY KEY (`c1`)
657 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
658 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
659 ERROR 22003: Out of range value for column 'c1' at row 1
660 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
661 ERROR 22003: Out of range value for column 'c1' at row 1
662 SELECT * FROM t1;
663 c1
664 DROP TABLE t1;
665 SHOW TABLES;
666 Tables_in_test
667 SET SQL_MODE='';
668 SET SQL_MODE='TRADITIONAL';
669 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
670 SHOW CREATE TABLE t1;
671 Table Create Table
672 t1 CREATE TABLE `t1` (
673 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
674 PRIMARY KEY (`c1`)
675 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
676 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
677 ERROR 22003: Out of range value for column 'c1' at row 1
678 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
679 ERROR 22003: Out of range value for column 'c1' at row 1
680 SELECT * FROM t1;
681 c1
682 DROP TABLE t1;
683 SHOW TABLES;
684 Tables_in_test
685 SET SQL_MODE='';
686 SET SQL_MODE='TRADITIONAL';
687 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
688 SHOW CREATE TABLE t1;
689 Table Create Table
690 t1 CREATE TABLE `t1` (
691 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
692 PRIMARY KEY (`c1`)
693 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
694 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
695 ERROR 22003: Out of range value for column 'c1' at row 1
696 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
697 ERROR 22003: Out of range value for column 'c1' at row 1
698 SELECT * FROM t1;
699 c1
700 DROP TABLE t1;
701 SHOW TABLES;
702 Tables_in_test
703 SET SQL_MODE='';
704 SET SQL_MODE='TRADITIONAL';
705 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
706 SHOW CREATE TABLE t1;
707 Table Create Table
708 t1 CREATE TABLE `t1` (
709 `c1` int unsigned NOT NULL AUTO_INCREMENT,
710 PRIMARY KEY (`c1`)
711 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
712 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
713 ERROR 22003: Out of range value for column 'c1' at row 1
714 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
715 ERROR 22003: Out of range value for column 'c1' at row 1
716 SELECT * FROM t1;
717 c1
718 DROP TABLE t1;
719 SHOW TABLES;
720 Tables_in_test
721 SET SQL_MODE='';
722 SET SQL_MODE='TRADITIONAL';
723 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
724 SHOW CREATE TABLE t1;
725 Table Create Table
726 t1 CREATE TABLE `t1` (
727 `c1` int unsigned NOT NULL AUTO_INCREMENT,
728 PRIMARY KEY (`c1`)
729 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
730 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
731 ERROR 22003: Out of range value for column 'c1' at row 1
732 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
733 ERROR 22003: Out of range value for column 'c1' at row 1
734 SELECT * FROM t1;
735 c1
736 DROP TABLE t1;
737 SHOW TABLES;
738 Tables_in_test
739 SET SQL_MODE='';
740 SET SQL_MODE='TRADITIONAL';
741 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
742 SHOW CREATE TABLE t1;
743 Table Create Table
744 t1 CREATE TABLE `t1` (
745 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
746 PRIMARY KEY (`c1`)
747 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
748 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
749 ERROR 22003: Out of range value for column 'c1' at row 1
750 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
751 ERROR 22003: Out of range value for column 'c1' at row 1
752 SELECT * FROM t1;
753 c1
754 DROP TABLE t1;
755 SHOW TABLES;
756 Tables_in_test
757 SET SQL_MODE='';
758 SET SQL_MODE='TRADITIONAL';
759 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
760 SHOW CREATE TABLE t1;
761 Table Create Table
762 t1 CREATE TABLE `t1` (
763 `c1` tinyint unsigned AUTO_INCREMENT,
764 UNIQUE KEY `c1` (`c1`)
765 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
766 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
767 ERROR 22003: Out of range value for column 'c1' at row 1
768 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
769 ERROR 22003: Out of range value for column 'c1' at row 1
770 SELECT * FROM t1;
771 c1
772 DROP TABLE t1;
773 SHOW TABLES;
774 Tables_in_test
775 SET SQL_MODE='';
776 SET SQL_MODE='TRADITIONAL';
777 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
778 SHOW CREATE TABLE t1;
779 Table Create Table
780 t1 CREATE TABLE `t1` (
781 `c1` smallint unsigned AUTO_INCREMENT,
782 UNIQUE KEY `c1` (`c1`)
783 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
784 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
785 ERROR 22003: Out of range value for column 'c1' at row 1
786 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
787 ERROR 22003: Out of range value for column 'c1' at row 1
788 SELECT * FROM t1;
789 c1
790 DROP TABLE t1;
791 SHOW TABLES;
792 Tables_in_test
793 SET SQL_MODE='';
794 SET SQL_MODE='TRADITIONAL';
795 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
796 SHOW CREATE TABLE t1;
797 Table Create Table
798 t1 CREATE TABLE `t1` (
799 `c1` mediumint unsigned AUTO_INCREMENT,
800 UNIQUE KEY `c1` (`c1`)
801 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
802 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
803 ERROR 22003: Out of range value for column 'c1' at row 1
804 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
805 ERROR 22003: Out of range value for column 'c1' at row 1
806 SELECT * FROM t1;
807 c1
808 DROP TABLE t1;
809 SHOW TABLES;
810 Tables_in_test
811 SET SQL_MODE='';
812 SET SQL_MODE='TRADITIONAL';
813 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
814 SHOW CREATE TABLE t1;
815 Table Create Table
816 t1 CREATE TABLE `t1` (
817 `c1` int unsigned AUTO_INCREMENT,
818 UNIQUE KEY `c1` (`c1`)
819 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
820 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
821 ERROR 22003: Out of range value for column 'c1' at row 1
822 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
823 ERROR 22003: Out of range value for column 'c1' at row 1
824 SELECT * FROM t1;
825 c1
826 DROP TABLE t1;
827 SHOW TABLES;
828 Tables_in_test
829 SET SQL_MODE='';
830 SET SQL_MODE='TRADITIONAL';
831 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
832 SHOW CREATE TABLE t1;
833 Table Create Table
834 t1 CREATE TABLE `t1` (
835 `c1` int unsigned AUTO_INCREMENT,
836 UNIQUE KEY `c1` (`c1`)
837 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
838 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
839 ERROR 22003: Out of range value for column 'c1' at row 1
840 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
841 ERROR 22003: Out of range value for column 'c1' at row 1
842 SELECT * FROM t1;
843 c1
844 DROP TABLE t1;
845 SHOW TABLES;
846 Tables_in_test
847 SET SQL_MODE='';
848 SET SQL_MODE='TRADITIONAL';
849 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
850 SHOW CREATE TABLE t1;
851 Table Create Table
852 t1 CREATE TABLE `t1` (
853 `c1` bigint unsigned AUTO_INCREMENT,
854 UNIQUE KEY `c1` (`c1`)
855 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
856 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
857 ERROR 22003: Out of range value for column 'c1' at row 1
858 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
859 ERROR 22003: Out of range value for column 'c1' at row 1
860 SELECT * FROM t1;
861 c1
862 DROP TABLE t1;
863 SHOW TABLES;
864 Tables_in_test
865 SET SQL_MODE='';
866 SET SQL_MODE='TRADITIONAL';
867 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
868 SHOW CREATE TABLE t1;
869 Table Create Table
870 t1 CREATE TABLE `t1` (
871 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
872 UNIQUE KEY `c1` (`c1`)
873 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
874 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
875 ERROR 22003: Out of range value for column 'c1' at row 1
876 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
877 ERROR 22003: Out of range value for column 'c1' at row 1
878 SELECT * FROM t1;
879 c1
880 DROP TABLE t1;
881 SHOW TABLES;
882 Tables_in_test
883 SET SQL_MODE='';
884 SET SQL_MODE='TRADITIONAL';
885 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
886 SHOW CREATE TABLE t1;
887 Table Create Table
888 t1 CREATE TABLE `t1` (
889 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
890 UNIQUE KEY `c1` (`c1`)
891 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
892 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
893 ERROR 22003: Out of range value for column 'c1' at row 1
894 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
895 ERROR 22003: Out of range value for column 'c1' at row 1
896 SELECT * FROM t1;
897 c1
898 DROP TABLE t1;
899 SHOW TABLES;
900 Tables_in_test
901 SET SQL_MODE='';
902 SET SQL_MODE='TRADITIONAL';
903 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
904 SHOW CREATE TABLE t1;
905 Table Create Table
906 t1 CREATE TABLE `t1` (
907 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
908 UNIQUE KEY `c1` (`c1`)
909 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
910 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
911 ERROR 22003: Out of range value for column 'c1' at row 1
912 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
913 ERROR 22003: Out of range value for column 'c1' at row 1
914 SELECT * FROM t1;
915 c1
916 DROP TABLE t1;
917 SHOW TABLES;
918 Tables_in_test
919 SET SQL_MODE='';
920 SET SQL_MODE='TRADITIONAL';
921 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
922 SHOW CREATE TABLE t1;
923 Table Create Table
924 t1 CREATE TABLE `t1` (
925 `c1` int unsigned NOT NULL AUTO_INCREMENT,
926 UNIQUE KEY `c1` (`c1`)
927 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
928 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
929 ERROR 22003: Out of range value for column 'c1' at row 1
930 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
931 ERROR 22003: Out of range value for column 'c1' at row 1
932 SELECT * FROM t1;
933 c1
934 DROP TABLE t1;
935 SHOW TABLES;
936 Tables_in_test
937 SET SQL_MODE='';
938 SET SQL_MODE='TRADITIONAL';
939 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
940 SHOW CREATE TABLE t1;
941 Table Create Table
942 t1 CREATE TABLE `t1` (
943 `c1` int unsigned NOT NULL AUTO_INCREMENT,
944 UNIQUE KEY `c1` (`c1`)
945 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
946 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
947 ERROR 22003: Out of range value for column 'c1' at row 1
948 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
949 ERROR 22003: Out of range value for column 'c1' at row 1
950 SELECT * FROM t1;
951 c1
952 DROP TABLE t1;
953 SHOW TABLES;
954 Tables_in_test
955 SET SQL_MODE='';
956 SET SQL_MODE='TRADITIONAL';
957 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
958 SHOW CREATE TABLE t1;
959 Table Create Table
960 t1 CREATE TABLE `t1` (
961 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
962 UNIQUE KEY `c1` (`c1`)
963 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
964 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
965 ERROR 22003: Out of range value for column 'c1' at row 1
966 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
967 ERROR 22003: Out of range value for column 'c1' at row 1
968 SELECT * FROM t1;
969 c1
970 DROP TABLE t1;
971 SHOW TABLES;
972 Tables_in_test
973 SET SQL_MODE='';
974 SET SQL_MODE='TRADITIONAL';
975 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
976 SHOW CREATE TABLE t1;
977 Table Create Table
978 t1 CREATE TABLE `t1` (
979 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
980 PRIMARY KEY (`c1`)
981 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
982 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
983 ERROR 22003: Out of range value for column 'c1' at row 1
984 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
985 ERROR 22003: Out of range value for column 'c1' at row 1
986 SELECT * FROM t1;
987 c1
988 DROP TABLE t1;
989 SHOW TABLES;
990 Tables_in_test
991 SET SQL_MODE='';
992 SET SQL_MODE='TRADITIONAL';
993 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
994 SHOW CREATE TABLE t1;
995 Table Create Table
996 t1 CREATE TABLE `t1` (
997 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
998 PRIMARY KEY (`c1`)
999 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1000 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1001 ERROR 22003: Out of range value for column 'c1' at row 1
1002 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1003 ERROR 22003: Out of range value for column 'c1' at row 1
1004 SELECT * FROM t1;
1005 c1
1006 DROP TABLE t1;
1007 SHOW TABLES;
1008 Tables_in_test
1009 SET SQL_MODE='';
1010 SET SQL_MODE='TRADITIONAL';
1011 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1012 SHOW CREATE TABLE t1;
1013 Table Create Table
1014 t1 CREATE TABLE `t1` (
1015 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
1016 PRIMARY KEY (`c1`)
1017 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1018 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1019 ERROR 22003: Out of range value for column 'c1' at row 1
1020 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1021 ERROR 22003: Out of range value for column 'c1' at row 1
1022 SELECT * FROM t1;
1023 c1
1024 DROP TABLE t1;
1025 SHOW TABLES;
1026 Tables_in_test
1027 SET SQL_MODE='';
1028 SET SQL_MODE='TRADITIONAL';
1029 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1030 SHOW CREATE TABLE t1;
1031 Table Create Table
1032 t1 CREATE TABLE `t1` (
1033 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1034 PRIMARY KEY (`c1`)
1035 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1036 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1037 ERROR 22003: Out of range value for column 'c1' at row 1
1038 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1039 ERROR 22003: Out of range value for column 'c1' at row 1
1040 SELECT * FROM t1;
1041 c1
1042 DROP TABLE t1;
1043 SHOW TABLES;
1044 Tables_in_test
1045 SET SQL_MODE='';
1046 SET SQL_MODE='TRADITIONAL';
1047 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1048 SHOW CREATE TABLE t1;
1049 Table Create Table
1050 t1 CREATE TABLE `t1` (
1051 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1052 PRIMARY KEY (`c1`)
1053 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1054 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1055 ERROR 22003: Out of range value for column 'c1' at row 1
1056 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1057 ERROR 22003: Out of range value for column 'c1' at row 1
1058 SELECT * FROM t1;
1059 c1
1060 DROP TABLE t1;
1061 SHOW TABLES;
1062 Tables_in_test
1063 SET SQL_MODE='';
1064 SET SQL_MODE='TRADITIONAL';
1065 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1066 SHOW CREATE TABLE t1;
1067 Table Create Table
1068 t1 CREATE TABLE `t1` (
1069 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1070 PRIMARY KEY (`c1`)
1071 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1072 INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1073 ERROR 22003: Out of range value for column 'c1' at row 1
1074 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1075 ERROR 22003: Out of range value for column 'c1' at row 1
1076 SELECT * FROM t1;
1077 c1
1078 DROP TABLE t1;
1079 SHOW TABLES;
1080 Tables_in_test
1081 SET SQL_MODE='';