From 9cecbe9bc20c1d888b9cb8a49a55b48a305166ae Mon Sep 17 00:00:00 2001 From: unknown 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/r/delete.result | 0 mysql-test/r/replace.result | 0 mysql-test/t/delete.test | 8 ++++++++ mysql-test/t/replace.test | 21 +++++++++++++++++++++ 4 files changed, 29 insertions(+) create mode 100644 mysql-test/r/delete.result create mode 100644 mysql-test/r/replace.result create mode 100644 mysql-test/t/delete.test create mode 100644 mysql-test/t/replace.test (limited to 'mysql-test') diff --git a/mysql-test/r/delete.result b/mysql-test/r/delete.result new file mode 100644 index 00000000000..e69de29bb2d diff --git a/mysql-test/r/replace.result b/mysql-test/r/replace.result new file mode 100644 index 00000000000..e69de29bb2d diff --git a/mysql-test/t/delete.test b/mysql-test/t/delete.test new file mode 100644 index 00000000000..85802354b2c --- /dev/null +++ b/mysql-test/t/delete.test @@ -0,0 +1,8 @@ +drop table if exists t1; + +# test delete using hidden_primary_key +create table t1 (a int) type=bdb; +insert into t1 values (1), (2); +delete from t1 where a = 1; + +drop table t1; 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