test/tools/csql/exp.testnw012.ksh

   1 Network CSql
   2 echo smallint data type testing;
   3 Statement Executed
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 echo select * from t1;
  12 ---------------------------------------------------------
  13         t1.f1   t1.f2
  14 ---------------------------------------------------------
  15         10      1
  16         11      1
  17         12      1
  18         13      1
  19         -9998   1
  20         9998    1
  21         50      23
  22
  23 echo select * from t1 where f1 = 10;
  24 ---------------------------------------------------------
  25         t1.f1   t1.f2
  26 ---------------------------------------------------------
  27         10      1
  28
  29 echo select * from t1 where f1 != 12 AND f2 <= 13;
  30 ---------------------------------------------------------
  31         t1.f1   t1.f2
  32 ---------------------------------------------------------
  33         10      1
  34         11      1
  35         13      1
  36         -9998   1
  37         9998    1
  38
  39 echo select * from t1 where f1 = 12 AND f2 >= 22;
  40 ---------------------------------------------------------
  41         t1.f1   t1.f2
  42 ---------------------------------------------------------
  43
  44 echo select * from t1 where f1 = 12 OR f2 < 13;
  45 ---------------------------------------------------------
  46         t1.f1   t1.f2
  47 ---------------------------------------------------------
  48         10      1
  49         11      1
  50         12      1
  51         13      1
  52         -9998   1
  53         9998    1
  54
  55 echo select * from t1 where f1 = 12 OR f2 <> 22;
  56 ---------------------------------------------------------
  57         t1.f1   t1.f2
  58 ---------------------------------------------------------
  59         10      1
  60         11      1
  61         12      1
  62         13      1
  63         -9998   1
  64         9998    1
  65         50      23
  66
  67 echo select * from t1 where NOT f1 = 12;
  68 ---------------------------------------------------------
  69         t1.f1   t1.f2
  70 ---------------------------------------------------------
  71         10      1
  72         11      1
  73         13      1
  74         -9998   1
  75         9998    1
  76         50      23
  77
  78 echo select * from t1 where f1 != 12;
  79 ---------------------------------------------------------
  80         t1.f1   t1.f2
  81 ---------------------------------------------------------
  82         10      1
  83         11      1
  84         13      1
  85         -9998   1
  86         9998    1
  87         50      23
  88
  89 echo select * from t1 where NOT f1 != 12;
  90 ---------------------------------------------------------
  91         t1.f1   t1.f2
  92 ---------------------------------------------------------
  93         12      1
  94
  95 echo select * from t1 where f1 = f2;
  96 ---------------------------------------------------------
  97         t1.f1   t1.f2
  98 ---------------------------------------------------------
  99
 100 echo select * from t1 where f1 between 9997 and 9999;
 101 ---------------------------------------------------------
 102         t1.f1   t1.f2
 103 ---------------------------------------------------------
 104         9998    1
 105
 106 echo select * from t1 where f1 between -9999 and -9997;
 107 ---------------------------------------------------------
 108         t1.f1   t1.f2
 109 ---------------------------------------------------------
 110         -9998   1
 111
 112 echo update t1 set f2 = 2 where f1 != f2;
 113 Statement Executed: Rows Affected = 7
 114 ---------------------------------------------------------
 115         t1.f1   t1.f2
 116 ---------------------------------------------------------
 117         10      2
 118         11      2
 119         12      2
 120         13      2
 121         -9998   2
 122         9998    2
 123         50      2
 124
 125 echo update t1 set f2 = 3 where f1 = 50;
 126 Statement Executed: Rows Affected = 1
 127 ---------------------------------------------------------
 128         t1.f1   t1.f2
 129 ---------------------------------------------------------
 130         10      2
 131         11      2
 132         12      2
 133         13      2
 134         -9998   2
 135         9998    2
 136         50      3
 137
 138 Statement Executed: Rows Affected = 1
 139 ---------------------------------------------------------
 140         t1.f1   t1.f2
 141 ---------------------------------------------------------
 142         10      2
 143         11      2
 144         12      2
 145         13      2
 146         -9998   2
 147         9998    2
 148
 149 Statement Executed