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