tests for bug fix

1 files changed, 6 insertions, 0 deletions

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;