*** empty log message ***
[csql.git] / test / tools / csql / exp.test079.ksh
blob3901a51f0228c11931aaf684106fc385ae7b5454
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
23 echo delete from t1 where f1<=100 and f1>1;
24 Statement Executed: Rows Affected = 2
25 echo commit;
26 echo select * from t1;
27 ---------------------------------------------------------
28 t1.f1 t1.f2 t1.f3
29 ---------------------------------------------------------
30 1 2 3
31 1000 2000 3000
33 Statement Executed