test/tools/csql/exp.testnw011.ksh

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