test/tools/csql/exp.test098.ksh

   1 echo create table t1 (f1 int,f2 char(10),f3 int,f4 int,f5 bigint,primary key(f1) size 1500);
   2 Statement Executed
   3 echo create index ind1 on t1(f2) hash size 750;
   4 Statement Executed
   5 echo create index ind2 on t1(f3) tree size 10000;
   6 Statement Executed
   7 echo create table t2 (f1 int,f2 char(10),f3 int,f4 int,f5 bigint,primary key(f2) size 1500);
   8 Statement Executed
   9 echo create index ind3 on t2(f1) hash unique size 750;
  10 Statement Executed
  11 CREATE TABLE t1 (f1 INT  NOT NULL , f2 CHAR (12), f3 INT , f4 INT , f5 BIGINT );
  12 CREATE INDEX t1_idx1_Primary on t1 (  f1  )  HASH  UNIQUE SIZE 1500 ;
  13 CREATE INDEX ind1 on t1 (  f2  )  HASH  SIZE 750 ;
  14 CREATE INDEX ind2 on t1 (  f3  )  TREE  SIZE 10000 ;
  15 CREATE TABLE t2 (f1 INT , f2 CHAR (12) NOT NULL , f3 INT , f4 INT , f5 BIGINT );
  16 CREATE INDEX t2_idx1_Primary on t2 (  f2  )  HASH  UNIQUE SIZE 1500 ;
  17 CREATE INDEX ind3 on t2 (  f1  )  HASH  UNIQUE SIZE 750 ;
  18 SET AUTOCOMMIT OFF;
  19 Statement Executed
  20 Statement Executed