test/durability/recovery/exp.test005.ksh

   1 Durablity = TRUE
   2 Server Started
   3 CREATING TABLE
   4 echo create table t1 (f1 char(10), f2 tinyint, f3 smallint,f4 int, f5 bigint,f6 integer, f7 float, f8 real,f9 double,f10 long,f11 binary(128),f12 date,f13 time,f14 timestamp);
   5 Statement Executed
   6 Server Killed
   7
   8 Durablity = TRUE
   9 Checking Durability
  10 Server Started
  11 Durability Works Fine
  12 INSERTING INTO TABLE
  13 echo insert into t1 values('NIHAR', 1,1,-2147483648,9223372036854775807, 2147483648,1.1, 1000000000.000000,10000001.10000001,99999,'ABCDEF0123456789','2001-1-1', '01:01:01', '2001-11-30 01:01:01');
  14 Statement Executed: Rows Affected = 1
  15 echo insert into t1 values(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  16 Statement Executed: Rows Affected = 1
  17 Server Killed
  18
  19 Durablity = TRUE
  20 Checking Durability
  21 Server Started
  22 Durability Works Fine
  23 UPDATING RECORDS IN TABLE
  24 echo UPDATE t1 set f1='PAPU', f2=10, f3=2, f4=2147483647, f5=-9223372036854775808, f6=-2147483647, f7=10.01, f8=2000000002.000002, f9=20000002.200002, f10=2147483647, f11='9876543210DcAbEf', f12='2003-3-3', f13='03:03:03', f14='2003-3-3 03:03:03';
  25 Statement Executed: Rows Affected = 2
  26 Server Killed
  27
  28 Durablity = TRUE
  29 Checking Durability
  30 Server Started
  31 Durability Works Fine
  32 DELETING RECORDS FROM TABLE
  33 echo delete from t1;
  34 Statement Executed: Rows Affected = 2
  35 Server Killed
  36
  37 Durablity = TRUE
  38 Checking Durability
  39 Server Started
  40 Durability Works Fine
  41 DROPPING TABLE
  42 echo drop table t1;
  43 Statement Executed