--
-- ### Index checks
--

create table t1 ( primary a int not null, b int, c string(30));
insert into t1 values ( 1, 2, 'XXX');
insert into t1 values ( 55, 3, 'CCC' );
insert into t1 values ( 3, 4, 'GGGG' );

create unique index id1 on t1 (b);
create index id2 on t1 (c);

select * from t1;
select * from t1 where c = 'CCC';

check index id1;
check index id2;


insert into t1 values ( 56, 7, 'EEEEEE' );
insert into t1 values ( 57, 8, 'KKKK' );
 

drop index id1;
drop table t1;
