*** empty log message ***
[csql.git] / test / tools / csql / exp.test068.ksh
blobb0d702e627614dd9c7d5e5f21a589a2f35d44c58
1 echo set autocommit on;
2 AUTOCOMMIT Mode is set to ON
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 select * from t1;
12 ---------------------------------------------------------
13 t1.f1 t1.f2 t1.f3
14 ---------------------------------------------------------
15 1 2 3
16 10 20 30
17 100 200 300
19 echo rollback;
20 echo select * from t1;
21 ---------------------------------------------------------
22 t1.f1 t1.f2 t1.f3
23 ---------------------------------------------------------
24 1 2 3
25 10 20 30
26 100 200 300
28 Statement Executed