test/sql/Aggregate/exp.test006.ksh

   1 echo select * from t1;
   2 ---------------------------------------------------------
   3         t1.f1   t1.f2   t1.f3
   4 ---------------------------------------------------------
   5         98      1       10
   6         99      2       20
   7         100     3       30
   8         101     4       40
   9         102     5       50
  10
  11 echo select min(t1.f2) from t1 group by t1.f1;
  12 ---------------------------------------------------------
  13         MIN(t1.f2)
  14 ---------------------------------------------------------
  15         1
  16         2
  17         3
  18         4
  19         5
  20
  21 echo select avg(t1.f2) from t1 group by t1.f1;
  22 ---------------------------------------------------------
  23         AVG(t1.f2)
  24 ---------------------------------------------------------
  25         1.000000
  26         2.000000
  27         3.000000
  28         4.000000
  29         5.000000
  30
  31 echo select sum(t1.f2) from t1 group by notexist;
  32 Statement prepare failed with error -19
  33 echo select sum(t1.f2) from t1 group by t1.notexist;
  34 Statement prepare failed with error -19
  35 echo select sum(t1.f2) from t1 group by notexist.f1;
  36 Statement prepare failed with error -19