*** empty log message ***
[csql.git] / test / tools / csql / exp.test075.ksh
blobd7dcac19d8e3e55b1cad7f4a81701d02af876be7
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 update t1 set f2=0,f3=f1*0 where f1<=100 and f1 >1;
24 Statement Executed: Rows Affected = 2
25 echo select * from t1;
26 ---------------------------------------------------------
27 t1.f1 t1.f2 t1.f3
28 ---------------------------------------------------------
29 1 2 3
30 10 0 0
31 100 0 0
32 1000 2000 3000
34 echo rollback;
35 echo select * from t1;
36 ---------------------------------------------------------
37 t1.f1 t1.f2 t1.f3
38 ---------------------------------------------------------
39 1 2 3
40 10 20 30
41 100 200 300
42 1000 2000 3000
44 Statement Executed