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/t/auto_increment.test | |
| 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/t/auto_increment.test')
| -rw-r--r-- | mysql-test/t/auto_increment.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/auto_increment.test b/mysql-test/t/auto_increment.test index 189320a8dcb..e187d42625e 100644 --- a/mysql-test/t/auto_increment.test +++ b/mysql-test/t/auto_increment.test @@ -106,3 +106,17 @@ select last_insert_id(); drop table t1; +drop table if exists 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; +drop table t1; |