test/tools/csql/exp.test082.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 select * from t1;
  14 ---------------------------------------------------------
  15         t1.f1   t1.f2   t1.f3
  16 ---------------------------------------------------------
  17         1       2       3
  18         10      20      30
  19         100     200     300
  20         1000    2000    3000
  21
  22 echo delete from t1 where f1<=100 and f1>1;
  23 Statement Executed: Rows Affected = 2
  24 echo select * from t1;
  25 ---------------------------------------------------------
  26         t1.f1   t1.f2   t1.f3
  27 ---------------------------------------------------------
  28         1       2       3
  29         1000    2000    3000
  30
  31 echo select * from t1;
  32 ---------------------------------------------------------
  33         t1.f1   t1.f2   t1.f3
  34 ---------------------------------------------------------
  35
  36 Statement Executed