test/sql/Aggregate/exp.test005.ksh

   1 echo select t1.f2, t1.f1, t2.f1 from t1,t2;
   2 ---------------------------------------------------------
   3         t1.f2   t1.f1   t2.f1
   4 ---------------------------------------------------------
   5         1       98      98
   6         1       98      99
   7         1       98      100
   8         1       98      101
   9         1       98      102
  10         2       99      98
  11         2       99      99
  12         2       99      100
  13         2       99      101
  14         2       99      102
  15         3       100     98
  16         3       100     99
  17         3       100     100
  18         3       100     101
  19         3       100     102
  20         4       101     98
  21         4       101     99
  22         4       101     100
  23         4       101     101
  24         4       101     102
  25         5       102     98
  26         5       102     99
  27         5       102     100
  28         5       102     101
  29         5       102     102
  30
  31 echo select t1.f2, t1.f1, t2.f1 from t1,t2 group by t1.f2;
  32 Statement prepare failed with error -19
  33 echo select t1.f2, max(t1.f1), sum(t2.f1) from t1, t2 group by t1.f2;
  34 ---------------------------------------------------------
  35         t1.f2   MAX(t1.f1)      SUM(t2.f1)
  36 ---------------------------------------------------------
  37         1       98      500
  38         2       99      500
  39         3       100     500
  40         4       101     500
  41         5       102     500
  42
  43 echo select f1, f2 from t1 group by f1,f2;
  44 ---------------------------------------------------------
  45         f1      f2
  46 ---------------------------------------------------------
  47         98      1
  48         99      2
  49         100     3
  50         101     4
  51         102     5
  52
  53 echo select f1, sum(f2) from t1 group by f3;
  54 Statement prepare failed with error -19