test/tools/csql/exp.test075.ksh

   1 echo set autocommit off;
   2 AUTOCOMMIT Mode is set to OFF
   3 echo create table t1(f1 int not null,f2 int,f3 int);
   4 Statement Executed
   5 echo insert into t1 values(1,2,3);
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(10,20,30);
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 values(100,200,300);
  10 Statement Executed: Rows Affected = 1
  11 echo insert into t1 values(1000,2000,3000);
  12 Statement Executed: Rows Affected = 1
  13 echo commit;
  14 echo select * from t1;
  15 ---------------------------------------------------------
  16         t1.f1   t1.f2   t1.f3
  17 ---------------------------------------------------------
  18         1       2       3
  19         10      20      30
  20         100     200     300
  21         1000    2000    3000
  22
  23 echo update t1 set f2=0,f3=f1*0 where f1<=100 and f1 >1;
  24 Statement Executed: Rows Affected = 2
  25 echo select * from t1;
  26 ---------------------------------------------------------
  27         t1.f1   t1.f2   t1.f3
  28 ---------------------------------------------------------
  29         1       2       3
  30         10      0       0
  31         100     0       0
  32         1000    2000    3000
  33
  34 echo rollback;
  35 echo select * from t1;
  36 ---------------------------------------------------------
  37         t1.f1   t1.f2   t1.f3
  38 ---------------------------------------------------------
  39         1       2       3
  40         10      20      30
  41         100     200     300
  42         1000    2000    3000
  43
  44 Statement Executed