test/tools/csql/exp.test072.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 insert into t1 values(10000,20000,30000);
  15 Statement Executed: Rows Affected = 1
  16 echo insert into t1 values(100000,200000,300000);
  17 Statement Executed: Rows Affected = 1
  18 echo select * from t1;
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2   t1.f3
  21 ---------------------------------------------------------
  22         1       2       3
  23         10      20      30
  24         100     200     300
  25         1000    2000    3000
  26         10000   20000   30000
  27         100000  200000  300000
  28
  29 echo rollback;
  30 echo select * from t1;
  31 ---------------------------------------------------------
  32         t1.f1   t1.f2   t1.f3
  33 ---------------------------------------------------------
  34         1       2       3
  35         10      20      30
  36         100     200     300
  37         1000    2000    3000
  38
  39 Statement Executed