~drizzle-trunk/drizzle/development

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;