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 = 'MEMORY'  ;
8set @@sql_mode='strict_all_tables';
9insert into t1 values(1000);
10ERROR 22003: Out of range value for column 'a' at row 1
11select count(*) from t1;
12count(*)
130
14set auto_increment_increment=1000;
15set auto_increment_offset=700;
16insert into t1 values(null);
17ERROR 22003: Out of range value for column 'a' at row 1
18select count(*) from t1;
19count(*)
200
21set @@sql_mode=@org_mode;
22insert into t1 values(null);
23Warnings:
24Warning	1264	Out of range value for column 'a' at row 1
25select * from t1;
26a
27127
28drop table t1;
29