test/tools/csql/exp.testnw024.ksh

   1 Network CSql
   2 echo create table T1 ( f1 int, f2 bigint, f3 smallint,f4 tinyint);
   3 Statement Executed
   4 echo create index idx1 on T1(f1) unique;
   5 Statement Executed
   6 echo create index idx2 on T1(f2) unique;
   7 Statement Executed
   8 echo create index idx3 on T1(f3) unique;
   9 Statement Executed
  10 echo create index idx4 on T1(f4) unique;
  11 Statement Executed
  12 echo create index idx5 on T1(f1,f1) unique;
  13 Statement execute failed with error -4
  14 echo create index idx6 on T1(f1,f2) unique;
  15 Statement Executed
  16 echo create index idx7 on T1(f1,f3) unique;
  17 Statement Executed
  18 echo create index idx8 on T1(f1,f4) unique;
  19 Statement Executed
  20 echo create index idx9 on T1(f2,f1) unique;
  21 Statement execute failed with error -4
  22 echo create index idx10 on T1(f2,f2) unique;
  23 Statement execute failed with error -4
  24 echo create index idx11 on T1(f2,f3) unique;
  25 Statement Executed
  26 echo create index idx12 on T1(f2,f4) unique;
  27 Statement Executed
  28 echo create index idx13 on T1(f3,f1) unique;
  29 Statement execute failed with error -4
  30 echo create index idx14 on T1(f3,f2) unique;
  31 Statement execute failed with error -4
  32 echo create index idx15 on T1(f3,f3) unique;
  33 Statement execute failed with error -4
  34 echo create index idx16 on T1(f3,f4) unique;
  35 Statement Executed
  36 echo create index idx17 on T1(f4,f1) unique;
  37 Statement execute failed with error -4
  38 echo create index idx18 on T1(f4,f2) unique;
  39 Statement execute failed with error -4
  40 echo create index idx19 on T1(f4,f3) unique;
  41 Statement execute failed with error -4
  42 echo create index idx20 on T1(f4,f4) unique;
  43 Statement execute failed with error -4
  44 echo create index idx21 on T1(f1,f2,f3) unique;
  45 Statement Executed
  46 echo create index idx22 on T1(f1,f2,f4) unique;
  47 Statement Executed
  48 echo create index idx23 on T1(f1,f3,f2) unique;
  49 Statement execute failed with error -4
  50 echo create index idx24 on T1(f1,f3,f4) unique;
  51 Statement Executed
  52 echo create index idx25 on T1(f1,f4,f1) unique;
  53 Statement execute failed with error -4
  54 echo create index idx26 on T1(f1,f4,f3) unique;
  55 Statement execute failed with error -4
  56 echo create index idx27 on T1(f2,f1,f3) unique;
  57 Statement execute failed with error -4
  58 echo create index idx28 on T1(f2,f1,f4) unique;
  59 Statement execute failed with error -4
  60 echo create index idx29 on T1(f2,f3,f1) unique;
  61 Statement execute failed with error -4
  62 echo create index idx30 on T1(f2,f3,f4) unique;
  63 Statement Executed
  64 echo create index idx31 on T1(f2,f4,f1) unique;
  65 Statement execute failed with error -4
  66 echo create index idx32 on T1(f2,f4,f3) unique;
  67 Statement execute failed with error -4
  68 echo create index idx33 on T1(f3,f1,f2) unique;
  69 Statement execute failed with error -4
  70 echo create index idx34 on T1(f3,f1,f4) unique;
  71 Statement execute failed with error -4
  72 echo create index idx35 on T1(f3,f1,f2) unique;
  73 Statement execute failed with error -4
  74 echo create index idx36 on T1(f3,f1,f4) unique;
  75 Statement execute failed with error -4
  76 echo create index idx37 on T1(f3,f2,f1) unique;
  77 Statement execute failed with error -4
  78 echo create index idx38 on T1(f3,f2,f4) unique;
  79 Statement execute failed with error -4
  80 echo create index idx39 on T1(f4,f2,f1) unique;
  81 Statement execute failed with error -4
  82 echo create index idx40 on T1(f4,f2,f3) unique;
  83 Statement execute failed with error -4
  84 echo create index idx41 on T1(f4,f3,f1) unique;
  85 Statement execute failed with error -4
  86 echo create index idx42 on T1(f4,f3,f2) unique;
  87 Statement execute failed with error -4
  88 echo create index idx43 on T1(f4,f1,f2) unique;
  89 Statement execute failed with error -4
  90 echo create index idx44 on T1(f4,f1,f3) unique;
  91 Statement execute failed with error -4
  92 echo create index idx45 on T1(f1,f2,f3,f4) unique;
  93 Statement Executed
  94 echo create index idx46 on T1(f2,f1,f4,f3) unique;
  95 Statement execute failed with error -4
  96 echo create index idx47 on T1(f1,f4,f3,f2) unique;
  97 Statement execute failed with error -4
  98 echo create index idx48 on T1(f4,f3,f1,f2) unique;
  99 Statement execute failed with error -4
 100 echo "Tree Index";
 101 echo create index idx01 on T1(f1) tree unique;
 102 Statement Executed
 103 echo create index idx02 on T1(f2) tree unique;
 104 Statement Executed
 105 echo create index idx03 on T1(f3) tree unique;
 106 Statement Executed
 107 echo create index idx04 on T1(f4) tree unique;
 108 Statement Executed
 109 echo create index idx05 on T1(f1,f1) tree unique;
 110 Statement execute failed with error -14
 111 echo create index idx06 on T1(f1,f2) tree unique;
 112 Statement execute failed with error -14
 113 echo create index idx07 on T1(f1,f3) tree unique;
 114 Statement execute failed with error -14
 115 echo create index idx08 on T1(f1,f4) tree unique;
 116 Statement execute failed with error -14
 117 echo create index idx09 on T1(f2,f1) tree unique;
 118 Statement execute failed with error -14
 119 echo DROP TABLE T1;
 120 Statement Executed
 121 Statement Executed
 122 Statement Executed: Rows Affected = 1
 123 Statement Executed: Rows Affected = 1
 124 Statement Executed: Rows Affected = 1
 125 Statement Executed: Rows Affected = 1
 126 echo "Hash Index";
 127 Statement execute failed with error -21
 128 Statement execute failed with error -21
 129 Statement execute failed with error -21
 130 Statement execute failed with error -21
 131 Statement execute failed with error -4
 132 Statement execute failed with error -21
 133 Statement execute failed with error -21
 134 Statement execute failed with error -21
 135 Statement execute failed with error -21
 136 Statement execute failed with error -4
 137 Statement execute failed with error -21
 138 Statement execute failed with error -21
 139 Statement execute failed with error -21
 140 Statement execute failed with error -21
 141 Statement execute failed with error -4
 142 Statement execute failed with error -21
 143 Statement execute failed with error -21
 144 Statement execute failed with error -21
 145 Statement execute failed with error -21
 146 Statement execute failed with error -4
 147 Statement execute failed with error -21
 148 Statement execute failed with error -21
 149 Statement execute failed with error -21
 150 Statement execute failed with error -21
 151 Statement execute failed with error -4
 152 Statement execute failed with error -21
 153 Statement execute failed with error -21
 154 Statement execute failed with error -21
 155 Statement execute failed with error -21
 156 Statement execute failed with error -21
 157 Statement execute failed with error -21
 158 Statement execute failed with error -21
 159 Statement execute failed with error -21
 160 Statement execute failed with error -21
 161 Statement execute failed with error -21
 162 Statement execute failed with error -21
 163 Statement execute failed with error -21
 164 Statement execute failed with error -21
 165 Statement execute failed with error -21
 166 Statement execute failed with error -21
 167 Statement execute failed with error -21
 168 Statement execute failed with error -21
 169 Statement execute failed with error -21
 170 Statement execute failed with error -21
 171 Statement execute failed with error -21
 172 Statement execute failed with error -21
 173 Statement execute failed with error -21
 174 Statement execute failed with error -21
 175 echo "Tree Index";
 176 Statement execute failed with error -21
 177 Statement execute failed with error -21
 178 Statement execute failed with error -21
 179 Statement execute failed with error -21
 180 Statement execute failed with error -14
 181 Statement execute failed with error -14
 182 Statement execute failed with error -14
 183 Statement execute failed with error -14
 184 Statement execute failed with error -14
 185 CREATE TABLE t1 (f1 INT , f2 BIGINT , f3 SMALLINT , f4 TINYINT );
 186 INSERT INTO t1 VALUES(1,2,3,4);
 187 INSERT INTO t1 VALUES(1,3,5,6);
 188 INSERT INTO t1 VALUES(1,3,7,8);
 189 INSERT INTO t1 VALUES(1,3,7,8);
 190 Network CSql
 191 Statement Executed