test/tools/csql/exp.test086.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 update t1 set f2='X';
  27 Statement Executed: Rows Affected = 2
  28 echo insert into t1 values(3,'k');
  29 Statement Executed: Rows Affected = 1
  30 echo insert into t1 values(4,'p');
  31 Statement Executed: Rows Affected = 1
  32 echo commit;
  33 echo select * from t1;
  34 ---------------------------------------------------------
  35         t1.f1   t1.f2
  36 ---------------------------------------------------------
  37         1       X
  38         2       X
  39         3       k
  40         4       p
  41
  42 echo update t1 set f2='Z';
  43 Statement Executed: Rows Affected = 4
  44 echo create table t2(f1 int,f2 char(10));
  45 Statement Executed
  46 echo delete from t1 where f1=1;
  47 Statement Executed: Rows Affected = 1
  48 echo select * from t1;
  49 ---------------------------------------------------------
  50         t1.f1   t1.f2
  51 ---------------------------------------------------------
  52         1       X
  53         2       X
  54         3       k
  55         4       p
  56
  57 Statement Executed
  58 echo drop table t2;
  59 Statement Executed