diff options
author | Sinisa@sinisa.nasamreza.org <> | 2002-03-07 15:36:14 +0200 |
---|---|---|
committer | Sinisa@sinisa.nasamreza.org <> | 2002-03-07 15:36:14 +0200 |
commit | c65ac4e7ac256a2f286504d0209d4f3ec705f674 (patch) | |
tree | 6b0b2ce046a188785ae32330406bc66a7183bad2 /mysql-test | |
parent | c0ea76f4bcdf9d27c82535668628b98bb8581685 (diff) | |
download | mariadb-git-c65ac4e7ac256a2f286504d0209d4f3ec705f674.tar.gz |
tests for bug fix
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/heap.result | 6 | ||||
-rw-r--r-- | mysql-test/t/heap.test | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index fc4a116307e..a7a69694b65 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -25,6 +25,12 @@ alter table t1 add c int not null, add key (c,a); drop table t1; create table t1 (a int not null,b int not null, primary key (a)) type=heap comment="testing heaps"; insert into t1 values(1,1),(2,2),(3,3),(4,4); +delete from t1 where a > 0; +select * from t1; +a b +drop table t1; +create table t1 (a int not null,b int not null, primary key (a)) type=heap comment="testing heaps"; +insert into t1 values(1,1),(2,2),(3,3),(4,4); alter table t1 modify a int not null auto_increment, type=myisam, comment="new myisam table"; select * from t1; a b diff --git a/mysql-test/t/heap.test b/mysql-test/t/heap.test index b08e8f6ea36..1b7175d375c 100644 --- a/mysql-test/t/heap.test +++ b/mysql-test/t/heap.test @@ -19,6 +19,12 @@ drop table t1; create table t1 (a int not null,b int not null, primary key (a)) type=heap comment="testing heaps"; insert into t1 values(1,1),(2,2),(3,3),(4,4); +delete from t1 where a > 0; +select * from t1; +drop table t1; + +create table t1 (a int not null,b int not null, primary key (a)) type=heap comment="testing heaps"; +insert into t1 values(1,1),(2,2),(3,3),(4,4); alter table t1 modify a int not null auto_increment, type=myisam, comment="new myisam table"; #show table status like "t1"; select * from t1; |