test/sql/StmtCache/exp.test007.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 creating index
   6 After create index
   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 ---------------------------------------------------------
  18         t1.f1   t1.f2   t1.f3
  19 ---------------------------------------------------------
  20         100     1234    CSQL
  21
  22  <TABLE-NODE>
  23  <NAME> t1 </NAME>
  24  <ScanType> HashScan </ScanType>
  25    <PREDICATE>
  26    <FieldName1> f1 </FieldName1>
  27    <CompOp> Equals </CompOp>
  28    <OperandPtr> VALUE </OperandPtr>
  29    </PREDICATE>
  30  </TABLE-NODE>
  31 ---------------------------------------------------------
  32         t1.f1   t1.f2   t1.f3
  33 ---------------------------------------------------------
  34         200     1234    CSQL
  35