test/sql/Aggregate/exp.testnw005.ksh

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