1#
2# Test for strict-mode autoincrement
3#
4
5--disable_warnings
6drop table if exists t1;
7--enable_warnings
8
9set @org_mode=@@sql_mode;
10eval create table t1
11(
12  `a` tinyint(4) NOT NULL auto_increment,
13  primary key (`a`)
14) engine = $type ;
15set @@sql_mode='strict_all_tables';
16--error ER_WARN_DATA_OUT_OF_RANGE
17insert into t1 values(1000);
18select count(*) from t1;
19
20set auto_increment_increment=1000;
21set auto_increment_offset=700;
22--error ER_WARN_DATA_OUT_OF_RANGE
23insert into t1 values(null);
24select count(*) from t1;
25
26set @@sql_mode=@org_mode;
27insert ignore into t1 values(null);
28select * from t1;
29
30drop table t1;
31
32# End of test
33