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 EXECDIRECT SID:1 TID:56 STMT:CREATE TABLE laks(f1 int, f2 int);
  19 PREPARE: SID:2 INSERT INTO laks values (10, 10);
  20 EXEC SID:2 TID:16
  21 FREE SID:2
  22 PREPARE: SID:3 INSERT INTO laks values (20, 20);
  23 EXEC SID:3 TID:16
  24 FREE SID:3
  25 PREPARE: SID:4 INSERT INTO laks values (30, 30);
  26 EXEC SID:4 TID:16
  27 FREE SID:4
  28 PREPARE: SID:5 INSERT INTO laks values (40, 40);
  29 EXEC SID:5 TID:16
  30 FREE SID:5
  31 PREPARE: SID:6 INSERT INTO laks values (50, 50);
  32 EXEC SID:6 TID:16
  33 FREE SID:6
  34 PREPARE: SID:7 UPDATE laks set f2=60 where f1=30;
  35 EXEC SID:7 TID:16
  36 FREE SID:7
  37 PREPARE: SID:8 UPDATE laks set f2=70 where f1=30;
  38 EXEC SID:8 TID:16
  39 FREE SID:8
  40 PREPARE: SID:9 DELETE FROM laks where f1=20;
  41 EXEC SID:9 TID:16
  42 FREE SID:9
  43 Server Killed
  44
  45 Checking Durability
  46 Server Started