diff options
Diffstat (limited to 'mysql-test/r/auto_increment.result')
| -rw-r--r-- | mysql-test/r/auto_increment.result | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/mysql-test/r/auto_increment.result b/mysql-test/r/auto_increment.result index 03cfcc50e17..8c898bae699 100644 --- a/mysql-test/r/auto_increment.result +++ b/mysql-test/r/auto_increment.result @@ -1,4 +1,5 @@ drop table if exists t1; +SET SQL_WARNINGS=1; create table t1 (a int not null auto_increment,b int, primary key (a)) type=myisam auto_increment=3; insert into t1 values (1,1),(NULL,3),(NULL,4); delete from t1 where a=4; @@ -130,7 +131,7 @@ last_insert_id() 255 insert into t1 set i = null; Warnings: -Warning 1262 Data truncated, out of range for column 'i' at row 1 +Warning 1263 Data truncated, out of range for column 'i' at row 1 select last_insert_id(); last_insert_id() 255 @@ -181,7 +182,7 @@ a b delete from t1 where a=0; update t1 set a=NULL where b=6; Warnings: -Warning 1261 Data truncated, NULL supplied to NOT NULL column 'a' at row 4 +Warning 1262 Data truncated, NULL supplied to NOT NULL column 'a' at row 4 update t1 set a=300 where b=7; SET SQL_MODE=''; insert into t1(a,b)values(NULL,8); @@ -223,7 +224,7 @@ a b delete from t1 where a=0; update t1 set a=NULL where b=13; Warnings: -Warning 1261 Data truncated, NULL supplied to NOT NULL column 'a' at row 9 +Warning 1262 Data truncated, NULL supplied to NOT NULL column 'a' at row 9 update t1 set a=500 where b=14; select * from t1 order by b; a b |