~ubuntu-branches/ubuntu/natty/mysql-5.1/natty-proposed

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
drop table if exists t1;
SET SQL_WARNINGS=1;
create table t1 (this int unsigned);
insert into t1 values (1);
insert into t1 values (-1);
Warnings:
Warning	1264	Out of range value for column 'this' at row 1
insert into t1 values ('5000000000');
Warnings:
Warning	1264	Out of range value for column 'this' at row 1
select * from t1;
this
1
0
4294967295
drop table t1;