diff options
Diffstat (limited to 'mysql-test/r/replace.result')
| -rw-r--r-- | mysql-test/r/replace.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/replace.result b/mysql-test/r/replace.result index 25a6a17da35..0aa80e18ccc 100644 --- a/mysql-test/r/replace.result +++ b/mysql-test/r/replace.result @@ -1,3 +1,26 @@ +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 (2,1); +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=heap; +replace into t1 (gesuchnr,benutzer_id) values (1,1); +drop table t1; +create table t1 (a tinyint not null auto_increment primary key, b char(20)); +insert into t1 values (126,"first"),(0,"last"); +insert into t1 values (0,"error"); +Duplicate entry '127' for key 1 +replace into t1 values (0,"error"); +Duplicate entry '127' for key 1 +replace into t1 values (126,"first updated"); +select * from t1; a b 126 first updated 127 last +drop table t1; |