diff options
| author | monty@hundin.mysql.fi <> | 2001-10-08 05:36:35 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-10-08 05:36:35 +0300 |
| commit | 938a8dc2ef15eb0878c9a71f2f60ae521084494a (patch) | |
| tree | 87a4027a65ad98a422987c566b6d394464e95623 /mysql-test/r/auto_increment.result | |
| parent | 0c81c7ea07b8f28746fef96409eafb6995c5d7c9 (diff) | |
| parent | 88aff4bf851e8f0d67cc7cd860d445e0fb234717 (diff) | |
| download | mariadb-git-938a8dc2ef15eb0878c9a71f2f60ae521084494a.tar.gz | |
merge
Diffstat (limited to 'mysql-test/r/auto_increment.result')
| -rw-r--r-- | mysql-test/r/auto_increment.result | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/mysql-test/r/auto_increment.result b/mysql-test/r/auto_increment.result index 476b496db93..e785252bd2f 100644 --- a/mysql-test/r/auto_increment.result +++ b/mysql-test/r/auto_increment.result @@ -23,30 +23,6 @@ a b c 8 8 8 9 9 9 drop table t1; -create table t1 (a int not null auto_increment,b int, primary key (a)) type=isam; -insert into t1 values (1,1),(NULL,2),(3,3),(NULL,4); -delete from t1 where a=4 or a=2; -insert into t1 values (NULL,4),(NULL,5),(6,6); -select * from t1; -a b -1 1 -5 5 -3 3 -4 4 -6 6 -delete from t1 where a=6; -replace t1 values (3,1); -replace t1 values (3,3); -ALTER TABLE t1 add c int; -insert into t1 values (NULL,6,6); -select * from t1; -a b c -1 1 NULL -5 5 NULL -3 3 NULL -4 4 NULL -6 6 6 -drop table t1; create table t1 ( skey tinyint unsigned NOT NULL auto_increment PRIMARY KEY, sval char(20) |