test/tools/csql/exp.test085.ksh

   1 echo create table t1(f1 int,f2 char(10));
   2 Statement Executed
   3 echo insert into t1 values(1,'x');
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(2,'y');
   6 Statement Executed: Rows Affected = 1
   7 echo set autocommit off;
   8 AUTOCOMMIT Mode is set to OFF
   9 echo delete from t1 where f1=1;
  10 Statement Executed: Rows Affected = 1
  11 echo select * from t1;
  12 ---------------------------------------------------------
  13         t1.f1   t1.f2
  14 ---------------------------------------------------------
  15         2       y
  16
  17 echo rollback;
  18 echo select * from t1;
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2
  21 ---------------------------------------------------------
  22         1       x
  23         2       y
  24
  25 echo commit;
  26 echo insert into t1 values(3,'k');
  27 Statement Executed: Rows Affected = 1
  28 echo insert into t1 values(4,'p');
  29 Statement Executed: Rows Affected = 1
  30 echo create table t2(f1 int,f2 char(10));
  31 Statement Executed
  32 echo delete from t1 where f1=1;
  33 Statement Executed: Rows Affected = 1
  34 echo select * from t1;
  35 ---------------------------------------------------------
  36         t1.f1   t1.f2
  37 ---------------------------------------------------------
  38         2       y
  39         3       k
  40         4       p
  41
  42 echo rollback;
  43 echo select * from t1;
  44 ---------------------------------------------------------
  45         t1.f1   t1.f2
  46 ---------------------------------------------------------
  47         1       x
  48         2       y
  49
  50 Statement Executed
  51 echo drop table t2;
  52 Statement Executed