test/sql/Aggregate/exp.test001.ksh

   1 echo select count(f1) from t2;
   2 Statement prepare failed with error -5
   3 echo select count(f1) from t1;
   4 ---------------------------------------------------------
   5         COUNT(f1)
   6 ---------------------------------------------------------
   7         5
   8
   9 echo select sum(f1) from t1;
  10 ---------------------------------------------------------
  11         SUM(f1)
  12 ---------------------------------------------------------
  13         500
  14
  15 echo select avg(f1) from t1;
  16 ---------------------------------------------------------
  17         AVG(f1)
  18 ---------------------------------------------------------
  19         100.000000
  20
  21 echo select min(f1) from t1;
  22 ---------------------------------------------------------
  23         MIN(f1)
  24 ---------------------------------------------------------
  25         98
  26
  27 echo select max(f1) from t1;
  28 ---------------------------------------------------------
  29         MAX(f1)
  30 ---------------------------------------------------------
  31         102
  32