~drizzle-trunk/drizzle/development

drop table if exists t1;

create temporary table t1 (a int not null auto_increment,b int, primary key (a)) engine=heap auto_increment=3;

insert into t1 values (1,1),(NULL,3),(NULL,4);

delete from t1 where a=4;

insert into t1 values (NULL,5),(NULL,6);

select * from t1;

a	b

1	1

3	3

5	5

6	6

delete from t1 where a=6;

replace t1 values (3,1);

ALTER TABLE t1 add c int;

replace t1 values (3,3,3);

insert into t1 values (NULL,7,7);

update t1 set a=8,b=b+1,c=c+1 where a=7;

insert into t1 values (NULL,9,9);

select * from t1;

a	b	c

1	1	NULL

3	3	3

5	5	NULL

8	8	8

9	9	9

drop table t1;

create temporary table t1 (

skey int NOT NULL auto_increment PRIMARY KEY,

sval char(20)

) engine=heap;

insert into t1 values (NULL, "hello");

insert into t1 values (NULL, "hey");

select * from t1;

skey	sval

1	hello

2	hey

select _rowid,t1._rowid,skey,sval from t1;

_rowid	_rowid	skey	sval

1	1	1	hello

2	2	2	hey

drop table t1;