|
1
by brian
clean slate |
1 |
drop table if exists t1; |
2 |
set @org_mode=@@sql_mode; |
|
3 |
create table t1 |
|
4 |
(
|
|
5 |
`a` tinyint(4) NOT NULL auto_increment, |
|
6 |
primary key (`a`) |
|
7 |
) engine = 'InnoDB' ; |
|
8 |
set @@sql_mode='strict_all_tables'; |
|
9 |
insert into t1 values(1000); |
|
10 |
ERROR 22003: Out of range value for column 'a' at row 1 |
|
11 |
select count(*) from t1; |
|
12 |
count(*) |
|
13 |
0
|
|
14 |
set auto_increment_increment=1000; |
|
15 |
set auto_increment_offset=700; |
|
16 |
insert into t1 values(null); |
|
17 |
ERROR 22003: Out of range value for column 'a' at row 1 |
|
18 |
select count(*) from t1; |
|
19 |
count(*) |
|
20 |
0
|
|
21 |
set @@sql_mode=@org_mode; |
|
22 |
insert into t1 values(null); |
|
23 |
Warnings: |
|
24 |
Warning 1264 Out of range value for column 'a' at row 1 |
|
25 |
select * from t1; |
|
26 |
a
|
|
27 |
127
|
|
28 |
drop table t1; |