test/tools/csql/exp.test022.ksh

   1 echo char datatype 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 Statement Executed: Rows Affected = 1
  11 Statement Executed: Rows Affected = 1
  12 Statement Executed: Rows Affected = 1
  13 Statement Executed: Rows Affected = 1
  14 echo select * from t1;
  15 ---------------------------------------------------------
  16         t1.f1   t1.f2
  17 ---------------------------------------------------------
  18         10      A
  19         11      B
  20         12      C
  21         13      D
  22         14      14
  23         50      E
  24         This is really a ve     E
  25         UPPERCASE       UPPER
  26         uppercase       LOWER
  27         upperletter     LOWER
  28         uppercaseletter LOWER
  29
  30 echo select * from t1 where f1 = '10';
  31 ---------------------------------------------------------
  32         t1.f1   t1.f2
  33 ---------------------------------------------------------
  34         10      A
  35
  36 echo select * from t1 where f1 != '12' AND f2 <= '13';
  37 ---------------------------------------------------------
  38         t1.f1   t1.f2
  39 ---------------------------------------------------------
  40
  41 echo select * from t1 where f1 = '12' AND f2 >= '22';
  42 ---------------------------------------------------------
  43         t1.f1   t1.f2
  44 ---------------------------------------------------------
  45         12      C
  46
  47 echo select * from t1 where f1 = '12' OR  f1 > '13';
  48 ---------------------------------------------------------
  49         t1.f1   t1.f2
  50 ---------------------------------------------------------
  51         12      C
  52         14      14
  53         50      E
  54         This is really a ve     E
  55         UPPERCASE       UPPER
  56         uppercase       LOWER
  57         upperletter     LOWER
  58         uppercaseletter LOWER
  59
  60 echo select * from t1 where f1 = '12' OR f2 = '13';
  61 ---------------------------------------------------------
  62         t1.f1   t1.f2
  63 ---------------------------------------------------------
  64         12      C
  65
  66 echo select * from t1 where f1 = '12' OR f2 < '22';
  67 ---------------------------------------------------------
  68         t1.f1   t1.f2
  69 ---------------------------------------------------------
  70         10      A
  71         11      B
  72         12      C
  73         13      D
  74         14      14
  75         50      E
  76         This is really a ve     E
  77         UPPERCASE       UPPER
  78         uppercase       LOWER
  79         upperletter     LOWER
  80         uppercaseletter LOWER
  81
  82 echo select * from t1 where NOT f1 = '12';
  83 ---------------------------------------------------------
  84         t1.f1   t1.f2
  85 ---------------------------------------------------------
  86         10      A
  87         11      B
  88         13      D
  89         14      14
  90         50      E
  91         This is really a ve     E
  92         UPPERCASE       UPPER
  93         uppercase       LOWER
  94         upperletter     LOWER
  95         uppercaseletter LOWER
  96
  97 echo select * from t1 where f1 != '12';
  98 ---------------------------------------------------------
  99         t1.f1   t1.f2
 100 ---------------------------------------------------------
 101         10      A
 102         11      B
 103         13      D
 104         14      14
 105         50      E
 106         This is really a ve     E
 107         UPPERCASE       UPPER
 108         uppercase       LOWER
 109         upperletter     LOWER
 110         uppercaseletter LOWER
 111
 112 echo select * from t1 where NOT f1 != '12';
 113 ---------------------------------------------------------
 114         t1.f1   t1.f2
 115 ---------------------------------------------------------
 116         12      C
 117
 118 echo select * from t1 where f1 = f2;
 119 ---------------------------------------------------------
 120         t1.f1   t1.f2
 121 ---------------------------------------------------------
 122         14      14
 123
 124 echo select * from t1 where f2 between 'A' AND 'C';
 125 ---------------------------------------------------------
 126         t1.f1   t1.f2
 127 ---------------------------------------------------------
 128         10      A
 129         11      B
 130         12      C
 131
 132 echo update t1 set f2 = '2' where f1 != f2;
 133 Statement Executed: Rows Affected = 10
 134 ---------------------------------------------------------
 135         t1.f1   t1.f2
 136 ---------------------------------------------------------
 137         10      2
 138         11      2
 139         12      2
 140         13      2
 141         14      14
 142         50      2
 143         This is really a ve     2
 144         UPPERCASE       2
 145         uppercase       2
 146         upperletter     2
 147         uppercaseletter 2
 148
 149 echo update t1 set f2 = '3' where f1 = '50';
 150 Statement Executed: Rows Affected = 1
 151 ---------------------------------------------------------
 152         t1.f1   t1.f2
 153 ---------------------------------------------------------
 154         10      2
 155         11      2
 156         12      2
 157         13      2
 158         14      14
 159         50      3
 160         This is really a ve     2
 161         UPPERCASE       2
 162         uppercase       2
 163         upperletter     2
 164         uppercaseletter 2
 165
 166 Statement Executed: Rows Affected = 1
 167 ---------------------------------------------------------
 168         t1.f1   t1.f2
 169 ---------------------------------------------------------
 170         10      2
 171         11      2
 172         12      2
 173         13      2
 174         14      14
 175         This is really a ve     2
 176         UPPERCASE       2
 177         uppercase       2
 178         upperletter     2
 179         uppercaseletter 2
 180
 181 Statement Executed