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 EXECDIRECT SID:1 TID:72 STMT:CREATE TABLE t1(f1 int not null, f2 int not null);
  11 SET SID:2 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100
  12 EXEC SID:2 TID:80
  13 SET SID:2 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:200
  14 EXEC SID:2 TID:80
  15 FREE SID:2
  16 EXECDIRECT SID:3 TID:64 STMT:create index idx on t1 (f2) primary hash;
  17 SET SID:4 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100
  18 FREE SID:4
  19 EXECDIRECT SID:5 TID:36 STMT:drop index idx;
  20 SET SID:6 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100
  21 EXEC SID:6 TID:44
  22 FREE SID:6
  23 Server Killed
  24
  25 Checking Durability
  26 Server Started
  27 CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT  NOT NULL );
  28 INSERT INTO t1 VALUES(1234,100);
  29 INSERT INTO t1 VALUES(1234,200);
  30 INSERT INTO t1 VALUES(1234,100);