test/sql/StmtCache/exp.test010.ksh

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