diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2003-07-22 18:58:30 -0400 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2003-07-22 18:58:30 -0400 |
| commit | 38aa6d1c15e350e22ffbe041bc7fdf7ba5b5414b (patch) | |
| tree | e35c64b5be509138b8c9340bbb820dbea0ed787c /mysql-test/r | |
| parent | cd3e15a6f998a74c0f04560bd8243a04e3218d66 (diff) | |
| download | mariadb-git-38aa6d1c15e350e22ffbe041bc7fdf7ba5b5414b.tar.gz | |
fixed bug 663 and WL 1052 (sql_mode is safe for mysqldump)
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/auto_increment.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/auto_increment.result b/mysql-test/r/auto_increment.result index 19f8ffa84d4..99e5e596fd3 100644 --- a/mysql-test/r/auto_increment.result +++ b/mysql-test/r/auto_increment.result @@ -150,3 +150,28 @@ select last_insert_id(); last_insert_id() 0 drop table t1; +drop table if exists t1; +Warnings: +Note 1051 Unknown table 't1' +create table t1(a int auto_increment,b int null,primary key(a)); +SET SQL_MODE=NO_AUTO_VALUE_ON_ZERO; +insert into t1(a,b)values(NULL,1); +insert into t1(a,b)values(200,2); +insert into t1(a,b)values(0,3); +insert into t1(b)values(4); +SET SQL_MODE=''; +insert into t1(a,b)values(NULL,5); +insert into t1(a,b)values(300,6); +insert into t1(a,b)values(0,7); +insert into t1(b)values(8); +select * from t1; +a b +1 1 +200 2 +0 3 +201 4 +202 5 +300 6 +301 7 +302 8 +drop table t1; |