test/sql/Aggregate/exp.testnw006.ksh

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