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 not null,f3 int);
  18 Statement Executed
  19 echo create index idx2 on t1(f1,f2) hash primary;
  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,f3 int,primary key(f1,f2));
  34 Statement Executed
  35 echo insert into t1 values(1,2,3);
  36 Statement Executed: Rows Affected = 1
  37 echo insert into t1 values(1,2,4);
  38 Statement execute failed with error -21
  39 echo select * from t1;
  40 ---------------------------------------------------------
  41         t1.f1   t1.f2   t1.f3
  42 ---------------------------------------------------------
  43         1       2       3
  44
  45 echo drop table t1;
  46 Statement Executed
  47 echo create table t1(f1 int not null,f2 int,f3 int);
  48 Statement Executed
  49 echo create index idx1 on t1(f1,f3) hash unique;
  50 Statement Executed
  51 echo insert into t1 values(1,2,3);
  52 Statement Executed: Rows Affected = 1
  53 echo insert into t1 values(1,4,3);
  54 Statement execute failed with error -21
  55 echo select * from t1;
  56 ---------------------------------------------------------
  57         t1.f1   t1.f2   t1.f3
  58 ---------------------------------------------------------
  59         1       2       3
  60
  61 echo drop table t1;
  62 Statement Executed
  63 echo create table t1(f1 int not null,f2 int,f3 int not null);
  64 Statement Executed
  65 echo create index idx2 on t1(f1,f3) hash primary;
  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,4,3);
  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,primary key(f1,f3));
  80 Statement Executed
  81 echo insert into t1 values(1,2,3);
  82 Statement Executed: Rows Affected = 1
  83 echo insert into t1 values(1,4,3);
  84 Statement execute failed with error -21
  85 echo select * from t1;
  86 ---------------------------------------------------------
  87         t1.f1   t1.f2   t1.f3
  88 ---------------------------------------------------------
  89         1       2       3
  90
  91 echo drop table t1;
  92 Statement Executed
  93 echo create table t1(f1 int,f2 int,f3 int,f4 int,primary key(f2,f4));
  94 Statement Executed
  95 echo insert into t1 values(1,2,3,4);
  96 Statement Executed: Rows Affected = 1
  97 echo insert into t1 values(1,2,5,4);
  98 Statement execute failed with error -21
  99 echo select * from t1;
 100 ---------------------------------------------------------
 101         t1.f1   t1.f2   t1.f3   t1.f4
 102 ---------------------------------------------------------
 103         1       2       3       4
 104
 105 echo drop table t1;
 106 Statement Executed