test/sql/Aggregate/exp.test004.ksh

   1 echo select min(t1.notexist) from t1;
   2 Statement prepare failed with error -19
   3 echo select max(t1.f1), sum(t2.f1) from t1,t2 where t1.f1 = t2.f1 and t1.f1 <100;
   4 ---------------------------------------------------------
   5         MAX(t1.f1)      SUM(t2.f1)
   6 ---------------------------------------------------------
   7         99      197
   8
   9 echo select max(t1.f1), sum(t2.f1) from t1,t2 where t1.f1 = t2.f1 and t1.f1 <100 group by t1.f2;
  10 ---------------------------------------------------------
  11         MAX(t1.f1)      SUM(t2.f1)
  12 ---------------------------------------------------------
  13         98      98
  14         99      99
  15
  16 echo select max(t1.f1), max(t2.notexist) from t1,t2 group by t1.f2;
  17 Statement prepare failed with error -19