~drizzle-trunk/drizzle/development

drop table if exists t1;

CREATE TABLE t1 (

gesuchnr int DEFAULT '0' NOT NULL,

benutzer_id int DEFAULT '0' NOT NULL,

PRIMARY KEY (gesuchnr,benutzer_id)

);

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 engine=heap;

replace into t1 (gesuchnr,benutzer_id) values (1,1);

drop table t1;

create table t1 (a int not null auto_increment primary key, b char(20) default "default_value");

insert into t1 values (126,"first"),(63, "middle"),(1,"last");

insert into t1 values (1,"error");

ERROR 23000: Duplicate entry '1' for key 'PRIMARY'

replace into t1 values (126,"first updated");

replace into t1 values (63,default);

select * from t1 order by a;

a	b

1	last

63	default_value

126	first updated

drop table t1;