diff options
| author | unknown <tim@cane.mysql.fi> | 2000-12-21 11:58:02 +0200 |
|---|---|---|
| committer | unknown <tim@cane.mysql.fi> | 2000-12-21 11:58:02 +0200 |
| commit | 9cecbe9bc20c1d888b9cb8a49a55b48a305166ae (patch) | |
| tree | 8cc30a1c2a09a84abcc4f9d1046b179d996ee0cf /mysql-test/t/replace.test | |
| parent | 97679a923251b8a35a78c6d0f4e69a360fdd290e (diff) | |
| download | mariadb-git-9cecbe9bc20c1d888b9cb8a49a55b48a305166ae.tar.gz | |
Test replace on all table types.
Test delete from BDB table using hidden primary key.
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; |