test/sql/StmtCache/exp.test003.ksh

   1 AFTER UPDATE PREPARE operation
   2 STATEMENT CACHE START
   3  SQL=UPDATE t1 set f2=? where f1=?; hits=0 inuse=1
   4 STATEMENT CACHE END
   5 AFTER STMT FREE operation
   6 STATEMENT CACHE START
   7  SQL=UPDATE t1 set f2=? where f1=?; hits=0 inuse=0
   8 STATEMENT CACHE END
   9 AFTER DELETE PREPARE operation
  10 STATEMENT CACHE START
  11  SQL=UPDATE t1 set f2=? where f1=?; hits=0 inuse=0
  12  SQL=DELETE from t1 where f2=?; hits=0 inuse=1
  13 STATEMENT CACHE END
  14 AFTER STMT FREE operation
  15 STATEMENT CACHE START
  16  SQL=UPDATE t1 set f2=? where f1=?; hits=0 inuse=0
  17  SQL=DELETE from t1 where f2=?; hits=0 inuse=0
  18 STATEMENT CACHE END
  19 AFTER SELECT PREPARE operation
  20 STATEMENT CACHE START
  21  SQL=UPDATE t1 set f2=? where f1=?; hits=0 inuse=0
  22  SQL=DELETE from t1 where f2=?; hits=0 inuse=0
  23  SQL=SELECT f1 from t1 where f2=?; hits=0 inuse=1
  24 STATEMENT CACHE END
  25 Tuple value 2
  26 Tuple value 3
  27 Tuple value 4
  28 Tuple value 5
  29 AFTER STMT FREE operation
  30 STATEMENT CACHE START
  31  SQL=UPDATE t1 set f2=? where f1=?; hits=0 inuse=0
  32  SQL=DELETE from t1 where f2=?; hits=0 inuse=0
  33  SQL=SELECT f1 from t1 where f2=?; hits=0 inuse=0
  34 STATEMENT CACHE END
  35 AFTER disconnect
  36 STATEMENT CACHE START
  37 STATEMENT CACHE END
  38 CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT , f3 VARCHAR (20));
  39 CREATE INDEX t1_idx1_Primary on t1 (  f1  )  HASH  UNIQUE;
  40 INSERT INTO t1 VALUES(2,1, 'Second');
  41 INSERT INTO t1 VALUES(3,1, 'Third');
  42 INSERT INTO t1 VALUES(4,1, 'Fourth');
  43 INSERT INTO t1 VALUES(5,1, 'Fifth');