PageRenderTime 13ms CodeModel.GetById 2ms app.highlight 7ms RepoModel.GetById 1ms app.codeStats 0ms

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

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