test/tools/csql/exp.test084.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 commit;
  33 echo select * from t1;
  34 ---------------------------------------------------------
  35         t1.f1   t1.f2
  36 ---------------------------------------------------------
  37         1       x
  38         2       y
  39         3       k
  40         4       p
  41
  42 echo delete from t1 where f1=1;
  43 Statement Executed: Rows Affected = 1
  44 echo select * from t1;
  45 ---------------------------------------------------------
  46         t1.f1   t1.f2
  47 ---------------------------------------------------------
  48         1       x
  49         2       y
  50         3       k
  51         4       p
  52
  53 Statement Executed
  54 echo drop table t2;
  55 Statement Executed