test/durability/redologs/exp.test004.ksh

   1 Server Started
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed
   5 Statement execute failed with error -21
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed
   8 Statement Executed: Rows Affected = 1
   9 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt
  10 EXECDIRECT SID:1 TID:64 STMT:CREATE TABLE laks(f1 int not null, f2 int);
  11 PREPARE: SID:2 INSERT INTO laks values (10, 10);
  12 EXEC SID:2 TID:16
  13 FREE SID:2
  14 EXECDIRECT SID:3 TID:64 STMT:create index idx on laks (f1) primary hash;
  15 PREPARE: SID:4 INSERT INTO laks values (10, 10);
  16 FREE SID:4
  17 PREPARE: SID:5 INSERT INTO laks values (50, 50);
  18 EXEC SID:5 TID:16
  19 FREE SID:5
  20 EXECDIRECT SID:6 TID:36 STMT:DROP Index idx;
  21 PREPARE: SID:7 INSERT INTO laks values (50, 50);
  22 EXEC SID:7 TID:16
  23 FREE SID:7
  24 Server Killed
  25
  26 Checking Durability
  27 Server Started
  28 CREATE TABLE laks (f1 INT  NOT NULL , f2 INT );
  29 INSERT INTO laks VALUES(10,10);
  30 INSERT INTO laks VALUES(50,50);
  31 INSERT INTO laks VALUES(50,50);