test/tools/csql/exp.test090.ksh

   1 echo create table t1(f1 int not null,f2 int,f3 int);
   2 Statement Executed
   3 echo create index idx1 on t1(f1,f2) hash unique;
   4 Statement Executed
   5 echo insert into t1 values(1,2,3);
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(1,2,4);
   8 Statement execute failed with error -21
   9 echo select * from t1;
  10 ---------------------------------------------------------
  11         t1.f1   t1.f2   t1.f3
  12 ---------------------------------------------------------
  13         1       2       3
  14
  15 echo drop table t1;
  16 Statement Executed
  17 echo create table t1(f1 int not null,f2 int,f3 int);
  18 Statement Executed
  19 echo create index idx2 on t1(f1,f2) tree unique;
  20 Statement Executed
  21 echo insert into t1 values(1,2,3);
  22 Statement Executed: Rows Affected = 1
  23 echo insert into t1 values(1,2,4);
  24 Statement execute failed with error -21
  25 echo select * from t1;
  26 ---------------------------------------------------------
  27         t1.f1   t1.f2   t1.f3
  28 ---------------------------------------------------------
  29         1       2       3
  30
  31 echo drop table t1;
  32 Statement Executed
  33 echo create table t1(f1 int not null,f2 int not null,f3 int);
  34 Statement Executed
  35 echo create index idx2 on t1(f1,f2) hash primary;
  36 Statement Executed
  37 echo insert into t1 values(1,2,3);
  38 Statement Executed: Rows Affected = 1
  39 echo insert into t1 values(1,2,4);
  40 Statement execute failed with error -21
  41 echo select * from t1;
  42 ---------------------------------------------------------
  43         t1.f1   t1.f2   t1.f3
  44 ---------------------------------------------------------
  45         1       2       3
  46
  47 echo drop table t1;
  48 Statement Executed
  49 echo create table t1(f1 int not null,f2 int not null,f3 int);
  50 Statement Executed
  51 echo create index idx2 on t1(f1,f2) tree primary;
  52 Statement Executed
  53 echo insert into t1 values(1,2,3);
  54 Statement Executed: Rows Affected = 1
  55 echo insert into t1 values(1,2,4);
  56 Statement execute failed with error -21
  57 echo select * from t1;
  58 ---------------------------------------------------------
  59         t1.f1   t1.f2   t1.f3
  60 ---------------------------------------------------------
  61         1       2       3
  62
  63 echo drop table t1;
  64 Statement Executed
  65 echo create table t1(f1 int not null,f2 int,f3 int,primary key(f1,f2));
  66 Statement Executed
  67 echo insert into t1 values(1,2,3);
  68 Statement Executed: Rows Affected = 1
  69 echo insert into t1 values(1,2,4);
  70 Statement execute failed with error -21
  71 echo select * from t1;
  72 ---------------------------------------------------------
  73         t1.f1   t1.f2   t1.f3
  74 ---------------------------------------------------------
  75         1       2       3
  76
  77 echo drop table t1;
  78 Statement Executed
  79 echo create table t1(f1 int not null,f2 int,f3 int);
  80 Statement Executed
  81 echo create index idx1 on t1(f1,f3) hash unique;
  82 Statement Executed
  83 echo insert into t1 values(1,2,3);
  84 Statement Executed: Rows Affected = 1
  85 echo insert into t1 values(1,4,3);
  86 Statement execute failed with error -21
  87 echo select * from t1;
  88 ---------------------------------------------------------
  89         t1.f1   t1.f2   t1.f3
  90 ---------------------------------------------------------
  91         1       2       3
  92
  93 echo drop table t1;
  94 Statement Executed
  95 echo create table t1(f1 int not null,f2 int,f3 int);
  96 Statement Executed
  97 echo create index idx2 on t1(f1,f3) tree unique;
  98 Statement Executed
  99 echo insert into t1 values(1,2,3);
 100 Statement Executed: Rows Affected = 1
 101 echo insert into t1 values(1,4,3);
 102 Statement execute failed with error -21
 103 echo select * from t1;
 104 ---------------------------------------------------------
 105         t1.f1   t1.f2   t1.f3
 106 ---------------------------------------------------------
 107         1       2       3
 108
 109 echo drop table t1;
 110 Statement Executed
 111 echo create table t1(f1 int not null,f2 int,f3 int not null);
 112 Statement Executed
 113 echo create index idx2 on t1(f1,f3) hash primary;
 114 Statement Executed
 115 echo insert into t1 values(1,2,3);
 116 Statement Executed: Rows Affected = 1
 117 echo insert into t1 values(1,4,3);
 118 Statement execute failed with error -21
 119 echo select * from t1;
 120 ---------------------------------------------------------
 121         t1.f1   t1.f2   t1.f3
 122 ---------------------------------------------------------
 123         1       2       3
 124
 125 echo drop table t1;
 126 Statement Executed
 127 echo create table t1(f1 int not null,f2 int,f3 int not null);
 128 Statement Executed
 129 echo create index idx2 on t1(f1,f3) tree primary;
 130 Statement Executed
 131 echo insert into t1 values(1,2,3);
 132 Statement Executed: Rows Affected = 1
 133 echo insert into t1 values(1,4,3);
 134 Statement execute failed with error -21
 135 echo select * from t1;
 136 ---------------------------------------------------------
 137         t1.f1   t1.f2   t1.f3
 138 ---------------------------------------------------------
 139         1       2       3
 140
 141 echo drop table t1;
 142 Statement Executed
 143 echo create table t1(f1 int not null,f2 int,f3 int,primary key(f1,f3));
 144 Statement Executed
 145 echo insert into t1 values(1,2,3);
 146 Statement Executed: Rows Affected = 1
 147 echo insert into t1 values(1,4,3);
 148 Statement execute failed with error -21
 149 echo select * from t1;
 150 ---------------------------------------------------------
 151         t1.f1   t1.f2   t1.f3
 152 ---------------------------------------------------------
 153         1       2       3
 154
 155 echo drop table t1;
 156 Statement Executed
 157 echo create table t1(f1 int,f2 int,f3 int,f4 int,primary key(f2,f4));
 158 Statement Executed
 159 echo insert into t1 values(1,2,3,4);
 160 Statement Executed: Rows Affected = 1
 161 echo insert into t1 values(1,2,5,4);
 162 Statement execute failed with error -21
 163 echo select * from t1;
 164 ---------------------------------------------------------
 165         t1.f1   t1.f2   t1.f3   t1.f4
 166 ---------------------------------------------------------
 167         1       2       3       4
 168
 169 echo drop table t1;
 170 Statement Executed