test/durability/redologs/exp.test005.ksh

   1 Server Started
   2 Statement Executed
   3 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt
   4 PREPARE: SID:2 INSERT INTO t1 VALUES(1234,?);
   5 FREE: SID:2 TID:12
   6 PREPARE: SID:4 INSERT INTO t1 VALUES(1234,?);
   7 FREE: SID:4 TID:12
   8 PREPARE: SID:6 INSERT INTO t1 VALUES(1234,?);
   9 FREE: SID:6 TID:12
  10 Redo log filename is :/tmp/csql/db/csql.db.cur
  11 EXECDIRECT SID:1 TID:72 STMT:CREATE TABLE t1(f1 int not null, f2 int not null);
  12 SET SID:2 POS:1 TYPE:0 LEN:4 Value:100
  13 EXEC SID:2 TID:72
  14 SET SID:2 POS:1 TYPE:0 LEN:4 Value:200
  15 EXEC SID:2 TID:72
  16 FREE SID:2
  17 EXECDIRECT SID:3 TID:64 STMT:create index idx on t1 (f2) primary hash;
  18 SET SID:4 POS:1 TYPE:0 LEN:4 Value:100
  19 FREE SID:4
  20 EXECDIRECT SID:5 TID:36 STMT:drop index idx;
  21 SET SID:6 POS:1 TYPE:0 LEN:4 Value:100
  22 EXEC SID:6 TID:40
  23 FREE SID:6
  24 Server Killed
  25
  26 Checking Durability
  27 Server Started
  28 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt
  29 CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT  NOT NULL );
  30 INSERT INTO t1 VALUES(1234,100);
  31 INSERT INTO t1 VALUES(1234,200);
  32 INSERT INTO t1 VALUES(1234,100);