diff options
| author | monty@mysql.com <> | 2003-12-17 17:35:34 +0200 |
|---|---|---|
| committer | monty@mysql.com <> | 2003-12-17 17:35:34 +0200 |
| commit | e0cc6799ecc831d296c568c5068947c1421fcaa5 (patch) | |
| tree | 93924b5aab311e02a0f0931cf91e67cdfad04bdf /mysql-test/t/auto_increment.test | |
| parent | 0462f48b344633c7d88d12d9667f4bd50b91c552 (diff) | |
| parent | 30e318311b35b109d230f7184fe0be1b6e29f02b (diff) | |
| download | mariadb-git-e0cc6799ecc831d296c568c5068947c1421fcaa5.tar.gz | |
Merge with 4.0.17
Diffstat (limited to 'mysql-test/t/auto_increment.test')
| -rw-r--r-- | mysql-test/t/auto_increment.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/auto_increment.test b/mysql-test/t/auto_increment.test index 6cf286f86c0..f2a769d9f06 100644 --- a/mysql-test/t/auto_increment.test +++ b/mysql-test/t/auto_increment.test @@ -74,6 +74,25 @@ check table t1; drop table t1; # +# Test negative values (Bug #1366) +# + +create table t1 (a int not null auto_increment primary key); +insert into t1 values (NULL); +insert into t1 values (-1); +select last_insert_id(); +insert into t1 values (NULL); +select * from t1; +drop table t1; + +create table t1 (a int not null auto_increment primary key) /*!41002 type=heap */; +insert into t1 values (NULL); +insert into t1 values (-1); +select last_insert_id(); +insert into t1 values (NULL); +select * from t1; +drop table t1; +# # last_insert_id() madness # create table t1 (i tinyint unsigned not null auto_increment primary key); |