test/sql/StmtCache/exp.test006.ksh

   1 AFTER INSERT FREE
   2 STATEMENT CACHE START
   3  SQL=INSERT INTO t1 VALUES(?, 1234, 'CSQL'); hits=0 inuse=0
   4 STATEMENT CACHE END
   5 Dropping table
   6 After drop
   7 STATEMENT CACHE START
   8 STATEMENT CACHE END
   9 After second time prepare
  10 STATEMENT CACHE START
  11  SQL=INSERT INTO t1 VALUES(?, 1234, 'CSQL'); hits=0 inuse=1
  12 STATEMENT CACHE END
  13 After reusing cached insert stmt
  14 STATEMENT CACHE START
  15  SQL=INSERT INTO t1 VALUES(?, 1234, 'CSQL'); hits=0 inuse=0
  16 STATEMENT CACHE END
  17 CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT , f3 VARCHAR (20));
  18 CREATE INDEX t1_idx1_Primary on t1 (  f1  )  HASH  UNIQUE;
  19 INSERT INTO t1 VALUES(1,1, 'First');
  20 INSERT INTO t1 VALUES(2,1, 'Second');
  21 INSERT INTO t1 VALUES(3,1, 'Third');
  22 INSERT INTO t1 VALUES(4,1, 'Fourth');
  23 INSERT INTO t1 VALUES(5,1, 'Fifth');
  24 INSERT INTO t1 VALUES(100,1234, 'CSQL');
  25 INSERT INTO t1 VALUES(200,1234, 'CSQL');