test/sql/StmtCache/exp.test001.ksh

   1 echo create table t1(f1 int, f2 timestamp);
   2 Statement Executed
   3 echo insert into t1 values(1,'now');
   4 Statement Executed: Rows Affected = 1
   5 echo select count(*) from t1 where f2 < 'now';
   6 ---------------------------------------------------------
   7         COUNT(*)
   8 ---------------------------------------------------------
   9         1
  10
  11 echo insert into t1 values(2,'now');
  12 Statement Executed: Rows Affected = 1
  13 echo select count(*) from t1 where f2 < 'now';
  14 ---------------------------------------------------------
  15         COUNT(*)
  16 ---------------------------------------------------------
  17         2
  18
  19 Statement Executed