test/tools/csql/exp.test129.ksh

   1 echo CREATE TABLE t1(f1 SMALLINT,f2 INT,f3 BIGINT,f4 FLOAT,f5 DOUBLE,f6 CHAR(20),f7 DATE,f8 TIME,f9 TIMESTAMP);
   2 Statement Executed
   3 echo INSERT INTO t1 values(1,111,11111111,1111.1111,1111111.111111,'AAAA','2001-01-01','01:01:01','2001-01-01 01:01:01');
   4 Statement Executed: Rows Affected = 1
   5 echo INSERT INTO t1 values(2,222,22222222,2222.2222,2222222.222222,'BBBB','2002-02-02','02:02:02','2002-02-02 02:02:02');
   6 Statement Executed: Rows Affected = 1
   7 echo INSERT INTO t1 values(4,444,44444444,4444.4444,4444444.444444,'CCCC','2004-04-04','04:04:04','2004-04-04 04:04:04');
   8 Statement Executed: Rows Affected = 1
   9 echo INSERT INTO t1 values(3,333,33333333,3333.3333,3333333.333333,'CCCC','2003-03-03','03:03:03','2003-03-03 03:03:03');
  10 Statement Executed: Rows Affected = 1
  11 echo SELECT * FROM t1;
  12 ---------------------------------------------------------
  13         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
  14 ---------------------------------------------------------
  15         1       111     11111111        1111.111084     1111111.111111  AAAA    2001/1/1        1:1:1.0 2001/1/1 1:1:1.0
  16         2       222     22222222        2222.222168     2222222.222222  BBBB    2002/2/2        2:2:2.0 2002/2/2 2:2:2.0
  17         4       444     44444444        4444.444336     4444444.444444  CCCC    2004/4/4        4:4:4.0 2004/4/4 4:4:4.0
  18         3       333     33333333        3333.333252     3333333.333333  CCCC    2003/3/3        3:3:3.0 2003/3/3 3:3:3.0
  19
  20 echo SELECT COUNT(*) FROM t1;
  21 ---------------------------------------------------------
  22         COUNT(*)
  23 ---------------------------------------------------------
  24         4
  25
  26 echo SELECT COUNT(f1) FROM t1;
  27 ---------------------------------------------------------
  28         COUNT(f1)
  29 ---------------------------------------------------------
  30         4
  31
  32 echo SELECT COUNT(f2) FROM t1;
  33 ---------------------------------------------------------
  34         COUNT(f2)
  35 ---------------------------------------------------------
  36         4
  37
  38 echo SELECT COUNT(f3) FROM t1;
  39 ---------------------------------------------------------
  40         COUNT(f3)
  41 ---------------------------------------------------------
  42         4
  43
  44 echo SELECT COUNT(f4) FROM t1;
  45 ---------------------------------------------------------
  46         COUNT(f4)
  47 ---------------------------------------------------------
  48         4
  49
  50 echo SELECT COUNT(f5) FROM t1;
  51 ---------------------------------------------------------
  52         COUNT(f5)
  53 ---------------------------------------------------------
  54         4
  55
  56 echo SELECT COUNT(f6) FROM t1;
  57 ---------------------------------------------------------
  58         COUNT(f6)
  59 ---------------------------------------------------------
  60         4
  61
  62 echo SELECT COUNT(f7) FROM t1;
  63 ---------------------------------------------------------
  64         COUNT(f7)
  65 ---------------------------------------------------------
  66         4
  67
  68 echo SELECT COUNT(f8) FROM t1;
  69 ---------------------------------------------------------
  70         COUNT(f8)
  71 ---------------------------------------------------------
  72         4
  73
  74 echo SELECT COUNT(f9) FROM t1;
  75 ---------------------------------------------------------
  76         COUNT(f9)
  77 ---------------------------------------------------------
  78         4
  79
  80 echo SELECT * FROM t1;
  81 ---------------------------------------------------------
  82         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
  83 ---------------------------------------------------------
  84         1       111     11111111        1111.111084     1111111.111111  AAAA    2001/1/1        1:1:1.0 2001/1/1 1:1:1.0
  85         2       222     22222222        2222.222168     2222222.222222  BBBB    2002/2/2        2:2:2.0 2002/2/2 2:2:2.0
  86         4       444     44444444        4444.444336     4444444.444444  CCCC    2004/4/4        4:4:4.0 2004/4/4 4:4:4.0
  87         3       333     33333333        3333.333252     3333333.333333  CCCC    2003/3/3        3:3:3.0 2003/3/3 3:3:3.0
  88
  89 echo SELECT SUM(f1) FROM t1;
  90 ---------------------------------------------------------
  91         SUM(f1)
  92 ---------------------------------------------------------
  93         10
  94
  95 echo SELECT SUM(f2) FROM t1;
  96 ---------------------------------------------------------
  97         SUM(f2)
  98 ---------------------------------------------------------
  99         1110
 100
 101 echo SELECT SUM(f3) FROM t1;
 102 ---------------------------------------------------------
 103         SUM(f3)
 104 ---------------------------------------------------------
 105         111111110
 106
 107 echo SELECT SUM(f4) FROM t1;
 108 ---------------------------------------------------------
 109         SUM(f4)
 110 ---------------------------------------------------------
 111         11111.110352
 112
 113 echo SELECT SUM(f5) FROM t1;
 114 ---------------------------------------------------------
 115         SUM(f5)
 116 ---------------------------------------------------------
 117         11111111.111110
 118
 119 echo SELECT * FROM t1;
 120 ---------------------------------------------------------
 121         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
 122 ---------------------------------------------------------
 123         1       111     11111111        1111.111084     1111111.111111  AAAA    2001/1/1        1:1:1.0 2001/1/1 1:1:1.0
 124         2       222     22222222        2222.222168     2222222.222222  BBBB    2002/2/2        2:2:2.0 2002/2/2 2:2:2.0
 125         4       444     44444444        4444.444336     4444444.444444  CCCC    2004/4/4        4:4:4.0 2004/4/4 4:4:4.0
 126         3       333     33333333        3333.333252     3333333.333333  CCCC    2003/3/3        3:3:3.0 2003/3/3 3:3:3.0
 127
 128 echo SELECT AVG(f1) FROM t1;
 129 ---------------------------------------------------------
 130         AVG(f1)
 131 ---------------------------------------------------------
 132         2.500000
 133
 134 echo SELECT AVG(f2) FROM t1;
 135 ---------------------------------------------------------
 136         AVG(f2)
 137 ---------------------------------------------------------
 138         277.500000
 139
 140 echo SELECT AVG(f3) FROM t1;
 141 ---------------------------------------------------------
 142         AVG(f3)
 143 ---------------------------------------------------------
 144         27777777.500000
 145
 146 echo SELECT AVG(f4) FROM t1;
 147 ---------------------------------------------------------
 148         AVG(f4)
 149 ---------------------------------------------------------
 150         2777.777710
 151
 152 echo SELECT AVG(f5) FROM t1;
 153 ---------------------------------------------------------
 154         AVG(f5)
 155 ---------------------------------------------------------
 156         2777777.777777
 157
 158 echo SELECT * FROM t1;
 159 ---------------------------------------------------------
 160         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
 161 ---------------------------------------------------------
 162         1       111     11111111        1111.111084     1111111.111111  AAAA    2001/1/1        1:1:1.0 2001/1/1 1:1:1.0
 163         2       222     22222222        2222.222168     2222222.222222  BBBB    2002/2/2        2:2:2.0 2002/2/2 2:2:2.0
 164         4       444     44444444        4444.444336     4444444.444444  CCCC    2004/4/4        4:4:4.0 2004/4/4 4:4:4.0
 165         3       333     33333333        3333.333252     3333333.333333  CCCC    2003/3/3        3:3:3.0 2003/3/3 3:3:3.0
 166
 167 echo SELECT MIN(f1) FROM t1;
 168 ---------------------------------------------------------
 169         MIN(f1)
 170 ---------------------------------------------------------
 171         1
 172
 173 echo SELECT MIN(f2) FROM t1;
 174 ---------------------------------------------------------
 175         MIN(f2)
 176 ---------------------------------------------------------
 177         111
 178
 179 echo SELECT MIN(f3) FROM t1;
 180 ---------------------------------------------------------
 181         MIN(f3)
 182 ---------------------------------------------------------
 183         11111111
 184
 185 echo SELECT MIN(f4) FROM t1;
 186 ---------------------------------------------------------
 187         MIN(f4)
 188 ---------------------------------------------------------
 189         1111.111084
 190
 191 echo SELECT MIN(f5) FROM t1;
 192 ---------------------------------------------------------
 193         MIN(f5)
 194 ---------------------------------------------------------
 195         1111111.111111
 196
 197 echo SELECT MIN(f7) FROM t1;
 198 ---------------------------------------------------------
 199         MIN(f7)
 200 ---------------------------------------------------------
 201         2001/1/1
 202
 203 echo SELECT MIN(f8) FROM t1;
 204 ---------------------------------------------------------
 205         MIN(f8)
 206 ---------------------------------------------------------
 207         1:1:1.0
 208
 209 echo SELECT MIN(f9) FROM t1;
 210 ---------------------------------------------------------
 211         MIN(f9)
 212 ---------------------------------------------------------
 213         2001/1/1 1:1:1.0
 214
 215 echo SELECT * FROM t1;
 216 ---------------------------------------------------------
 217         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
 218 ---------------------------------------------------------
 219         1       111     11111111        1111.111084     1111111.111111  AAAA    2001/1/1        1:1:1.0 2001/1/1 1:1:1.0
 220         2       222     22222222        2222.222168     2222222.222222  BBBB    2002/2/2        2:2:2.0 2002/2/2 2:2:2.0
 221         4       444     44444444        4444.444336     4444444.444444  CCCC    2004/4/4        4:4:4.0 2004/4/4 4:4:4.0
 222         3       333     33333333        3333.333252     3333333.333333  CCCC    2003/3/3        3:3:3.0 2003/3/3 3:3:3.0
 223
 224 echo SELECT MAX(f1) FROM t1;
 225 ---------------------------------------------------------
 226         MAX(f1)
 227 ---------------------------------------------------------
 228         4
 229
 230 echo SELECT MAX(f2) FROM t1;
 231 ---------------------------------------------------------
 232         MAX(f2)
 233 ---------------------------------------------------------
 234         444
 235
 236 echo SELECT MAX(f3) FROM t1;
 237 ---------------------------------------------------------
 238         MAX(f3)
 239 ---------------------------------------------------------
 240         44444444
 241
 242 echo SELECT MAX(f4) FROM t1;
 243 ---------------------------------------------------------
 244         MAX(f4)
 245 ---------------------------------------------------------
 246         4444.444336
 247
 248 echo SELECT MAX(f5) FROM t1;
 249 ---------------------------------------------------------
 250         MAX(f5)
 251 ---------------------------------------------------------
 252         4444444.444444
 253
 254 echo SELECT MAX(f7) FROM t1;
 255 ---------------------------------------------------------
 256         MAX(f7)
 257 ---------------------------------------------------------
 258         2004/4/4
 259
 260 echo SELECT MAX(f8) FROM t1;
 261 ---------------------------------------------------------
 262         MAX(f8)
 263 ---------------------------------------------------------
 264         4:4:4.0
 265
 266 echo SELECT MAX(f9) FROM t1;
 267 ---------------------------------------------------------
 268         MAX(f9)
 269 ---------------------------------------------------------
 270         2004/4/4 4:4:4.0
 271
 272 echo SELECT COUNT(*),COUNT(f5),SUM(F1),AVG(f3),MIN(f5),MAX(f8) FROM t1;
 273 ---------------------------------------------------------
 274         COUNT(*)        COUNT(f5)       SUM(f1) AVG(f3) MIN(f5) MAX(f8)
 275 ---------------------------------------------------------
 276         4       4       10      27777777.500000 1111111.111111  4:4:4.0
 277
 278 Statement Executed