test/tools/csql/exp.testnw025.ksh

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