1drop table if exists t1;
2set @org_mode=@@sql_mode;
3create table t1
4(
5`a` tinyint(4) NOT NULL auto_increment,
6primary key (`a`)
7) engine = 'InnoDB'  ;
8set @@sql_mode='strict_all_tables';
9Warnings:
10Warning	3135	'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
11Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
12insert into t1 values(1000);
13ERROR 22003: Out of range value for column 'a' at row 1
14select count(*) from t1;
15count(*)
160
17set auto_increment_increment=1000;
18set auto_increment_offset=700;
19insert into t1 values(null);
20ERROR 22003: Out of range value for column 'a' at row 1
21select count(*) from t1;
22count(*)
230
24set @@sql_mode=@org_mode;
25Warnings:
26Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
27insert ignore into t1 values(null);
28Warnings:
29Warning	1264	Out of range value for column 'a' at row 1
30select * from t1;
31a
32127
33drop table t1;
34