test/tools/csql/exp.testnw006.ksh

   1 Network CSql
   2 echo drop table test;
   3 echo create table t1 (f1 integer);
   4 Statement Executed
   5 echo drop table t1;
   6 Statement Executed
   7 echo create table t1 (f1 integer);
   8 Statement Executed
   9 echo drop table t1;
  10 Statement Executed
  11 echo create table t1(f1 int,f2 int);
  12 Statement Executed
  13 echo create index idx1 on t1(f1);
  14 Statement Executed
  15 echo drop index idx1;
  16 Statement Executed
  17 echo create index idx1 on t1(f1);
  18 Statement Executed
  19 echo drop table t1;
  20 Statement Executed
  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);
  22 Statement Executed
  23 echo create index idx1 on t1 (f1);
  24 Statement Executed
  25 echo create index idx2 on t1 (f2) UNIQUE;
  26 Statement Executed
  27 echo create index idx3 on t1 (f3) PRIMARY;
  28 Statement Executed
  29 echo create index idx4 on t1 (f4) HASH PRIMARY;
  30 Statement Executed
  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;
  36 Statement Executed
  37 echo create index idx6 on t1 (f6) TREE PRIMARY;
  38 Statement Executed
  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
  43 echo drop index idx1;
  44 Statement Executed
  45 echo drop index idx2;
  46 Statement Executed
  47 echo drop index idx3;
  48 Statement Executed
  49 echo drop index idx4;
  50 Statement Executed
  51 echo drop index idx5;
  52 Statement Executed
  53 echo drop table t1;
  54 Statement Executed