diff options
author | monty@mysql.com <> | 2003-12-19 16:25:50 +0200 |
---|---|---|
committer | monty@mysql.com <> | 2003-12-19 16:25:50 +0200 |
commit | 031390a9a4904924c21929314dcd42886c84c175 (patch) | |
tree | 87e8ff9b43e2e71fc79bfa2e296018b89b08a9e1 /mysql-test/r/auto_increment.result | |
parent | e0cc6799ecc831d296c568c5068947c1421fcaa5 (diff) | |
download | mariadb-git-031390a9a4904924c21929314dcd42886c84c175.tar.gz |
Fixes after merge with 4.0
Cleaned up embedded library access and query cache handling
Changed min stack size to 128K (to allow longer MyISAM keys)
Fixed wrong priority for XOR (should be less than NEG to get -1^1 to work)
Diffstat (limited to 'mysql-test/r/auto_increment.result')
-rw-r--r-- | mysql-test/r/auto_increment.result | 52 |
1 files changed, 26 insertions, 26 deletions
diff --git a/mysql-test/r/auto_increment.result b/mysql-test/r/auto_increment.result index 1390141df51..89d07af6cf3 100644 --- a/mysql-test/r/auto_increment.result +++ b/mysql-test/r/auto_increment.result @@ -106,6 +106,32 @@ Table Op Msg_type Msg_text test.t1 check warning Found row where the auto_increment column has the value 0 test.t1 check status OK drop table t1; +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(); +last_insert_id() +1 +insert into t1 values (NULL); +select * from t1; +a +-1 +1 +2 +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(); +last_insert_id() +1 +insert into t1 values (NULL); +select * from t1; +a +-1 +1 +2 +drop table t1; create table t1 (i tinyint unsigned not null auto_increment primary key); insert into t1 set i = 254; insert into t1 set i = null; @@ -244,29 +270,3 @@ a b 0 13 500 14 drop table t1; -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(); -last_insert_id() -1 -insert into t1 values (NULL); -select * from t1; -a --1 -1 -2 -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(); -last_insert_id() -1 -insert into t1 values (NULL); -select * from t1; -a --1 -1 -2 -drop table t1; |