test/tools/csql/exp.testnw007.ksh

   1 Network CSql
   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 execute failed with error -21
  12 echo select * from t1;
  13 ---------------------------------------------------------
  14         t1.f1   t1.f2
  15 ---------------------------------------------------------
  16         10      200
  17         11      210
  18         20      500
  19         13      230
  20         14      240
  21         50      500
  22         5       500
  23         12      240
  24
  25 echo select count(*) from t1;
  26 ---------------------------------------------------------
  27         COUNT(*)
  28 ---------------------------------------------------------
  29         8
  30
  31 echo select count(f1) from t1;
  32 ---------------------------------------------------------
  33         COUNT(f1)
  34 ---------------------------------------------------------
  35         8
  36
  37 echo select count(f2) from t1;
  38 ---------------------------------------------------------
  39         COUNT(f2)
  40 ---------------------------------------------------------
  41         8
  42
  43 echo select * from t1 where f1 =11;
  44 ---------------------------------------------------------
  45         t1.f1   t1.f2
  46 ---------------------------------------------------------
  47         11      210
  48
  49 echo select count(*) from t1 where f1 = 11;
  50 ---------------------------------------------------------
  51         COUNT(*)
  52 ---------------------------------------------------------
  53         1
  54
  55 echo select count(f1) from t1 where f1=20;
  56 ---------------------------------------------------------
  57         COUNT(f1)
  58 ---------------------------------------------------------
  59         1
  60
  61 echo select count(f2) from t1 where f2=500;
  62 ---------------------------------------------------------
  63         COUNT(f2)
  64 ---------------------------------------------------------
  65         3
  66
  67 echo select * from t1;
  68 ---------------------------------------------------------
  69         t1.f1   t1.f2
  70 ---------------------------------------------------------
  71         10      200
  72         11      210
  73         20      500
  74         13      230
  75         14      240
  76         50      500
  77         5       500
  78         12      240
  79
  80 echo select min(f1) from t1;
  81 ---------------------------------------------------------
  82         MIN(f1)
  83 ---------------------------------------------------------
  84         5
  85
  86 echo select min(f2) from t1;
  87 ---------------------------------------------------------
  88         MIN(f2)
  89 ---------------------------------------------------------
  90         200
  91
  92 echo select min(f1) from t1 where f1=20;
  93 ---------------------------------------------------------
  94         MIN(f1)
  95 ---------------------------------------------------------
  96         20
  97
  98 echo select min(f2) from t1 where f2=500;
  99 ---------------------------------------------------------
 100         MIN(f2)
 101 ---------------------------------------------------------
 102         500
 103
 104 echo select * from t1;
 105 ---------------------------------------------------------
 106         t1.f1   t1.f2
 107 ---------------------------------------------------------
 108         10      200
 109         11      210
 110         20      500
 111         13      230
 112         14      240
 113         50      500
 114         5       500
 115         12      240
 116
 117 echo select max(f1) from t1;
 118 ---------------------------------------------------------
 119         MAX(f1)
 120 ---------------------------------------------------------
 121         50
 122
 123 echo select max(f2) from t1;
 124 ---------------------------------------------------------
 125         MAX(f2)
 126 ---------------------------------------------------------
 127         500
 128
 129 echo select max(f1) from t1 where f1=20;
 130 ---------------------------------------------------------
 131         MAX(f1)
 132 ---------------------------------------------------------
 133         20
 134
 135 echo select max(f2) from t1 where f2=500;
 136 ---------------------------------------------------------
 137         MAX(f2)
 138 ---------------------------------------------------------
 139         500
 140
 141 echo select * from t1;
 142 ---------------------------------------------------------
 143         t1.f1   t1.f2
 144 ---------------------------------------------------------
 145         10      200
 146         11      210
 147         20      500
 148         13      230
 149         14      240
 150         50      500
 151         5       500
 152         12      240
 153
 154 echo select avg(f1) from t1;
 155 ---------------------------------------------------------
 156         AVG(f1)
 157 ---------------------------------------------------------
 158         16.875000
 159
 160 echo select avg(f2) from t1;
 161 ---------------------------------------------------------
 162         AVG(f2)
 163 ---------------------------------------------------------
 164         327.500000
 165
 166 echo select avg(f1) from t1 where f1=20;
 167 ---------------------------------------------------------
 168         AVG(f1)
 169 ---------------------------------------------------------
 170         20.000000
 171
 172 echo select avg(f2) from t1 where f2=500;
 173 ---------------------------------------------------------
 174         AVG(f2)
 175 ---------------------------------------------------------
 176         500.000000
 177
 178 echo select * from t1;
 179 ---------------------------------------------------------
 180         t1.f1   t1.f2
 181 ---------------------------------------------------------
 182         10      200
 183         11      210
 184         20      500
 185         13      230
 186         14      240
 187         50      500
 188         5       500
 189         12      240
 190
 191 echo select sum(f1) from t1;
 192 ---------------------------------------------------------
 193         SUM(f1)
 194 ---------------------------------------------------------
 195         135
 196
 197 echo select sum(f2) from t1;
 198 ---------------------------------------------------------
 199         SUM(f2)
 200 ---------------------------------------------------------
 201         2620
 202
 203 echo select sum(f1) from t1 where f1=20;
 204 ---------------------------------------------------------
 205         SUM(f1)
 206 ---------------------------------------------------------
 207         20
 208
 209 echo select sum(f2) from t1 where f2=500;
 210 ---------------------------------------------------------
 211         SUM(f2)
 212 ---------------------------------------------------------
 213         1500
 214
 215 echo drop table t1;
 216 Statement Executed