test/tools/csql/exp.test023.ksh

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