diff options
author | Michael Widenius <monty@askmonty.org> | 2012-04-04 00:16:38 +0300 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2012-04-04 00:16:38 +0300 |
commit | b04c4801b0529aebb39c8d9be95c123d2f3b7d46 (patch) | |
tree | 0a4f72935b5ac6816996172ae412b62327b4caf4 /mysql-test/suite/heap/heap_auto_increment.test | |
parent | 34ed8f33795b639d21817003236ce0f6c069481d (diff) | |
download | mariadb-git-b04c4801b0529aebb39c8d9be95c123d2f3b7d46.tar.gz |
Created suites for heap, archive and csv.
Moved test from main suite to the new suites.
Move tests from maria/t and maria/r to maria
mysql-test/mysql-test-run.pl:
Added support for the new suites
Diffstat (limited to 'mysql-test/suite/heap/heap_auto_increment.test')
-rw-r--r-- | mysql-test/suite/heap/heap_auto_increment.test | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/suite/heap/heap_auto_increment.test b/mysql-test/suite/heap/heap_auto_increment.test new file mode 100644 index 00000000000..016bc946209 --- /dev/null +++ b/mysql-test/suite/heap/heap_auto_increment.test @@ -0,0 +1,35 @@ +# +# Test of auto_increment; The test for BDB tables is in bdb.test +# + +--disable_warnings +drop table if exists t1; +--enable_warnings + +create table t1 (a int not null auto_increment,b int, primary key (a)) engine=heap auto_increment=3; +insert into t1 values (1,1),(NULL,3),(NULL,4); +delete from t1 where a=4; +insert into t1 values (NULL,5),(NULL,6); +select * from t1; +delete from t1 where a=6; +#show table status like "t1"; +replace t1 values (3,1); +ALTER TABLE t1 add c int; +replace t1 values (3,3,3); +insert into t1 values (NULL,7,7); +update t1 set a=8,b=b+1,c=c+1 where a=7; +insert into t1 values (NULL,9,9); +select * from t1; +drop table t1; + +create table t1 ( + skey tinyint unsigned NOT NULL auto_increment PRIMARY KEY, + sval char(20) +) engine=heap; +insert into t1 values (NULL, "hello"); +insert into t1 values (NULL, "hey"); +select * from t1; +select _rowid,t1._rowid,skey,sval from t1; +drop table t1; + +# End of 4.1 tests |