3 echo create table t1
(f1 integer
);
7 echo create table t1
(f1 integer
);
11 echo create table t1
(f1 int
,f2 int
);
13 echo create index idx1 on t1
(f1
);
17 echo create index idx1 on t1
(f1
);
21 echo create table t1
(f1 integer not null
, f2 integer not null
,f3 int not null
, f4 int not null
,f5 int not null
, f6 int not null
,f7 int not null
);
23 echo create index idx1 on t1
(f1
);
25 echo create index idx2 on t1
(f2
) UNIQUE
;
27 echo create index idx3 on t1
(f3
) PRIMARY
;
29 echo create index idx4 on t1
(f4
) HASH PRIMARY
;
31 echo create index idx4 on t1
(f5
) HASH PRIMARY
;
32 Statement execute failed with error
-4
33 echo create index idx5 on t1
(f4
) HASH PRIMARY
;
34 Statement execute failed with error
-4
35 echo create index idx5 on t1
(f5
) TREE
;
37 echo create index idx6 on t1
(f6
) TREE PRIMARY
;
39 echo create index idx6 on t1
(f7
) TREE PRIMARY
;
40 Statement execute failed with error
-4
41 echo create index idx7 on t1
(f6
) TREE PRIMARY
;
42 Statement execute failed with error
-4