test/durability/redologs/exp.test002.ksh

   1 Server Started
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 ---------------------------------------------------------
  12         laks.f1 laks.f2
  13 ---------------------------------------------------------
  14         40      40
  15         50      50
  16
  17 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt
  18 Redo log filename is :/tmp/csql/db/csql.db.cur
  19 EXECDIRECT SID:1 TID:56 STMT:CREATE TABLE laks(f1 int, f2 int);
  20 PREPARE: SID:2 INSERT INTO laks values (10, 10);
  21 EXEC SID:2 TID:16
  22 FREE SID:2
  23 PREPARE: SID:3 INSERT INTO laks values (20, 20);
  24 EXEC SID:3 TID:16
  25 FREE SID:3
  26 PREPARE: SID:4 INSERT INTO laks values (30, 30);
  27 EXEC SID:4 TID:16
  28 FREE SID:4
  29 PREPARE: SID:5 INSERT INTO laks values (40, 40);
  30 EXEC SID:5 TID:16
  31 FREE SID:5
  32 PREPARE: SID:6 INSERT INTO laks values (50, 50);
  33 EXEC SID:6 TID:16
  34 FREE SID:6
  35 PREPARE: SID:7 UPDATE laks set f2=60 where f1=30;
  36 EXEC SID:7 TID:16
  37 FREE SID:7
  38 PREPARE: SID:8 UPDATE laks set f2=70 where f1=30;
  39 EXEC SID:8 TID:16
  40 FREE SID:8
  41 PREPARE: SID:9 DELETE FROM laks where f1=20;
  42 EXEC SID:9 TID:16
  43 FREE SID:9
  44 Server Killed
  45
  46 Checking Durability
  47 Server Started
  48 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt