test/tools/Durability/exp.test008.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 Server Killed
  13
  14 Durablity = TRUE
  15 Server Started
  16 Checking Durability
  17 Durability Works Fine
  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 ROLLBACK;
  25 Server Killed
  26
  27 Durablity = TRUE
  28 Server Started
  29 Checking Durability
  30 Durability Works Fine
  31 Statement Executed