adding test scripts
[csql.git] / test / tools / csql / exp.test078.ksh
blobf96bf8749c86415940e3c87af0e22a26f44b5ec0
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;
24 Statement Executed: Rows Affected = 4
25 echo commit;
26 echo select * from t1;
27 ---------------------------------------------------------
28 t1.f1 t1.f2 t1.f3
29 ---------------------------------------------------------
31 Statement Executed