adding test scripts
[csql.git] / test / cache / CacheTable / exp.test045.ksh.psql
blob6c1a8cf41f0d629e6085f83f82255b82d8afb768
1 CREATING TABLE t1 and INSERTING 1 RECORDS IN TARGET DB
2 +---------------------------------------+
3 | Connected!                            |
4 |                                       |
5 | sql-statement                         |
6 | help [tablename]                      |
7 | quit                                  |
8 |                                       |
9 +---------------------------------------+
10 \e[?1034hSQL> echo create table t1(f1 int);
11 SQL> create table t1(f1 int);
12 SQLRowCount returns 0
13 SQL> echo insert into t1 values(1);
14 SQL> insert into t1 values(1);
15 SQLRowCount returns 1
16 SQL> echo select * from t1;
17 SQL> select * from t1;
18 +------------+
19 | f1         |
20 +------------+
21 | 1          |
22 +------------+
23 SQLRowCount returns 1
24 1 rows fetched
25 SQL> CREATING TABLE t1 and INSERTING 1 RECORDS AT CSQL
26 echo create table t1(f1 int);
27 Statement Executed
28 echo insert into t1 values(2);
29 Statement Executed: Rows Affected = 1
30 echo select * from t1;
31 ---------------------------------------------------------
32         t1.f1   
33 ---------------------------------------------------------
34         2       
35         
36 AFTER INSERT AT CSQL DATA IN TDB
37 +---------------------------------------+
38 | Connected!                            |
39 |                                       |
40 | sql-statement                         |
41 | help [tablename]                      |
42 | quit                                  |
43 |                                       |
44 +---------------------------------------+
45 \e[?1034hSQL> echo select * from t1;
46 SQL> select * from t1;
47 +------------+
48 | f1         |
49 +------------+
50 | 1          |
51 +------------+
52 SQLRowCount returns 1
53 1 rows fetched
54 SQL> echo drop table t1;
55 Statement Executed
56 +---------------------------------------+
57 | Connected!                            |
58 |                                       |
59 | sql-statement                         |
60 | help [tablename]                      |
61 | quit                                  |
62 |                                       |
63 +---------------------------------------+
64 \e[?1034hSQL> echo drop table t1;
65 SQL> drop table t1;
66 SQLRowCount returns 0
67 SQL>