--
-- ### BTree checks
--

create table t1 ( a int not null, b int not null, c string(30));

create primary btree on t1 ( a );
create unique btree b1 on t1 ( b );
create btree b2 on t1 ( c);

tableinfo t1;

insert into t1 values ( 1, 2, 'XXX');
insert into t1 values ( 55, 3, 'CCC' );
insert into t1 values ( 3, 4, 'GGGG' );
insert into t1 values ( 44, 5, 'GFFFF' );
insert into t1 values ( 9, 8, 'GFFFF' );


-- create index id2 on t1 (c);

delete from t1 where a = 44;
 
drop table t1;
