test/tools/csql/exp.test064.ksh

   1 echo create table t1(f1 int not null,f2 int,f3 int);
   2 Statement Executed
   3 echo insert into t1 values(1,2,3);
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(10,20,30);
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(100,200,300);
   8 Statement Executed: Rows Affected = 1
   9 echo select * from t1;
  10 ---------------------------------------------------------
  11         t1.f1   t1.f2   t1.f3
  12 ---------------------------------------------------------
  13         1       2       3
  14         10      20      30
  15         100     200     300
  16
  17 echo rollback;
  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
  26 Statement Executed