test/tools/Durability/exp.test007.ksh

   1 Durablity = TRUE
   2 Server Started
   3 CREATING TABLE
   4 echo create table t2(f1 int,f2 float,f3 date);
   5 Statement Executed
   6 INSERTING INTO TABLE
   7 DEFAULT AUTOCOMMIT MODE ON
   8 echo insert into t2 values(10,100.001,'2001-1-1');
   9 Statement Executed: Rows Affected = 1
  10 echo insert into t2 values(50,500.005,'2005-5-5');
  11 Statement Executed: Rows Affected = 1
  12 echo insert into t2 values(10,100.001,'2001-1-1');
  13 Statement Executed: Rows Affected = 1
  14 echo insert into t2 values(20,200.002,'2002-2-2');
  15 Statement Executed: Rows Affected = 1
  16 echo insert into t2 values(30,300.003,'2003-3-3');
  17 Statement Executed: Rows Affected = 1
  18 echo SET AUTOCOMMIT OFF;
  19 AUTOCOMMIT Mode is set to OFF
  20 echo insert into t2 values(100,1000.0001,'2001-1-1');
  21 Statement Executed: Rows Affected = 1
  22 echo insert into t2 values(500,5000.0005,'2005-5-5');
  23 Statement Executed: Rows Affected = 1
  24 echo insert into t2 values(100,1000.0001,'2001-1-1');
  25 Statement Executed: Rows Affected = 1
  26 echo insert into t2 values(200,2000.0002,'2002-2-2');
  27 Statement Executed: Rows Affected = 1
  28 echo insert into t2 values(300,3000.0003,'2003-3-3');
  29 Statement Executed: Rows Affected = 1
  30 echo select * from t2;
  31 ---------------------------------------------------------
  32         t2.f1   t2.f2   t2.f3
  33 ---------------------------------------------------------
  34         10      100.000999      2001/1/1
  35         50      500.005005      2005/5/5
  36         10      100.000999      2001/1/1
  37         20      200.001999      2002/2/2
  38         30      300.002991      2003/3/3
  39         100     1000.000122     2001/1/1
  40         500     5000.000488     2005/5/5
  41         100     1000.000122     2001/1/1
  42         200     2000.000244     2002/2/2
  43         300     3000.000244     2003/3/3
  44
  45 echo COMMIT;
  46 Server Killed
  47 Durablity = TRUE
  48 Checking Durability
  49 Server Started
  50 ---------------------------------------------------------
  51         t2.f1   t2.f2   t2.f3
  52 ---------------------------------------------------------
  53         10      100.000999      2001/1/1
  54         50      500.005005      2005/5/5
  55         10      100.000999      2001/1/1
  56         20      200.001999      2002/2/2
  57         30      300.002991      2003/3/3
  58         100     1000.000122     2001/1/1
  59         500     5000.000488     2005/5/5
  60         100     1000.000122     2001/1/1
  61         200     2000.000244     2002/2/2
  62         300     3000.000244     2003/3/3
  63
  64 Statement Executed