summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <tim@cane.mysql.fi>2000-12-21 12:00:09 +0200
committerunknown <tim@cane.mysql.fi>2000-12-21 12:00:09 +0200
commita09659dd577dcf4c9ff907c680df0abf011d047c (patch)
tree0fcc294e65f2ac0aa26f05054339eb7a5a9b040a /mysql-test
parenta9db7b74980cd4644fe2ee04e3d99bdaeed2072b (diff)
parent9cecbe9bc20c1d888b9cb8a49a55b48a305166ae (diff)
downloadmariadb-git-a09659dd577dcf4c9ff907c680df0abf011d047c.tar.gz
Merge work.mysql.com:/home/bk/mysql
into cane.mysql.fi:/usr/home/tim/my/work acconfig.h: Auto merged configure.in: Auto merged
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/delete.result0
-rw-r--r--mysql-test/r/replace.result0
-rw-r--r--mysql-test/t/delete.test8
-rw-r--r--mysql-test/t/replace.test21
4 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/delete.result b/mysql-test/r/delete.result
new file mode 100644
index 00000000000..e69de29bb2d
--- /dev/null
+++ b/mysql-test/r/delete.result
diff --git a/mysql-test/r/replace.result b/mysql-test/r/replace.result
new file mode 100644
index 00000000000..e69de29bb2d
--- /dev/null
+++ b/mysql-test/r/replace.result
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;