test/tools/csql/exp.test009.ksh

   1 echo Description:count(*) test;
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 echo select * from t1;
  10 ---------------------------------------------------------
  11         COUNT(*)
  12 ---------------------------------------------------------
  13         6
  14
  15 echo select * from t1 where f1 =11;
  16 ---------------------------------------------------------
  17         COUNT(*)
  18 ---------------------------------------------------------
  19         1
  20
  21 Statement Executed