diff options
| author | tim@cane.mysql.fi <> | 2000-12-21 12:00:09 +0200 |
|---|---|---|
| committer | tim@cane.mysql.fi <> | 2000-12-21 12:00:09 +0200 |
| commit | 7e3fd8ce798c681cdbe18dcdecb563f63160166c (patch) | |
| tree | 0fcc294e65f2ac0aa26f05054339eb7a5a9b040a /mysql-test/t/replace.test | |
| parent | 45d537d58014587caa1f61a2d69a9fc7bbaa0856 (diff) | |
| parent | 6ea697884728f9b05cc8604154788dbf7d108406 (diff) | |
| download | mariadb-git-7e3fd8ce798c681cdbe18dcdecb563f63160166c.tar.gz | |
Merge work.mysql.com:/home/bk/mysql
into cane.mysql.fi:/usr/home/tim/my/work
Diffstat (limited to 'mysql-test/t/replace.test')
| -rw-r--r-- | mysql-test/t/replace.test | 21 |
1 files changed, 21 insertions, 0 deletions
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; |