test/sql/Aggregate/exp.testnw004.ksh

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