From 6ea697884728f9b05cc8604154788dbf7d108406 Mon Sep 17 00:00:00 2001
From: "tim@cane.mysql.fi" <>
Date: Thu, 21 Dec 2000 11:58:02 +0200
Subject: Test replace on all table types. Test delete from BDB table using
 hidden primary key.

---
 mysql-test/t/replace.test | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 mysql-test/t/replace.test

(limited to 'mysql-test/t/replace.test')

diff --git a/mysql-test/t/replace.test b/mysql-test/t/replace.test
new file mode 100644
index 00000000000..4000ee1b4e2
--- /dev/null
+++ b/mysql-test/t/replace.test
@@ -0,0 +1,21 @@
+#
+# Test of REPLACE with ISAM and MyISAM and BDB
+#
+
+drop table if exists t1;
+
+CREATE TABLE t1 (
+  gesuchnr int(11) DEFAULT '0' NOT NULL,
+  benutzer_id int(11) DEFAULT '0' NOT NULL,
+  PRIMARY KEY (gesuchnr,benutzer_id)
+) type=ISAM;
+
+replace into t1 (gesuchnr,benutzer_id) values (1,1);
+replace into t1 (gesuchnr,benutzer_id) values (1,1);
+alter table t1 type=myisam;
+replace into t1 (gesuchnr,benutzer_id) values (1,1);
+alter table t1 type=bdb;
+replace into t1 (gesuchnr,benutzer_id) values (1,1);
+alter table t1 type=heap;
+replace into t1 (gesuchnr,benutzer_id) values (1,1);
+drop table t1;
-- 
cgit v1.2.1