1 echo create table t1(f1 int not null,f2 int,f3 int);
2 create table t1(f1 int not null,f2 int,f3 int);
3 echo create index idx1 on t1(f1,f2) hash unique;
4 create index idx1 on t1(f1,f2) hash unique;
5 echo insert into t1 values(1,2,3);
6 insert into t1 values(1,2,3);
7 echo insert into t1 values(1,2,4);
8 insert into t1 values(1,2,4);
14 echo create table t1(f1 int not null,f2 int not null,f3 int);
15 create table t1(f1 int not null,f2 int not null,f3 int);
16 echo create index idx2 on t1(f1,f2) hash primary;
17 create index idx2 on t1(f1,f2) hash primary;
18 echo insert into t1 values(1,2,3);
19 insert into t1 values(1,2,3);
20 echo insert into t1 values(1,2,4);
21 insert into t1 values(1,2,4);
22 echo select * from t1;
27 echo create table t1(f1 int not null,f2 int,f3 int,primary key(f1,f2));
28 create table t1(f1 int not null,f2 int,f3 int,primary key(f1,f2));
29 echo insert into t1 values(1,2,3);
30 insert into t1 values(1,2,3);
31 echo insert into t1 values(1,2,4);
32 insert into t1 values(1,2,4);
33 echo select * from t1;