From c65ac4e7ac256a2f286504d0209d4f3ec705f674 Mon Sep 17 00:00:00 2001
From: "Sinisa@sinisa.nasamreza.org" <>
Date: Thu, 7 Mar 2002 15:36:14 +0200
Subject: tests for bug fix

---
 mysql-test/r/heap.result | 6 ++++++
 mysql-test/t/heap.test   | 6 ++++++
 2 files changed, 12 insertions(+)

(limited to 'mysql-test')

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
@@ -17,6 +17,12 @@ select * from t1;
 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;
+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";
-- 
cgit v1.2.1