diff options
| author | vva@eagle.mysql.r18.ru <> | 2003-07-22 18:58:30 -0400 |
|---|---|---|
| committer | vva@eagle.mysql.r18.ru <> | 2003-07-22 18:58:30 -0400 |
| commit | f32299279d9562485cd7714626d267dae130a7a4 (patch) | |
| tree | e35c64b5be509138b8c9340bbb820dbea0ed787c /mysql-test/t/auto_increment.test | |
| parent | 9b6083dbe72f8c5328b33fceacf1884c370ccd38 (diff) | |
| download | mariadb-git-f32299279d9562485cd7714626d267dae130a7a4.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; |