adding test scripts
[csql.git] / test / cache / CacheTable / exp.test045.ksh
blob57cefd7b170f9b02379455623dfe261993810470
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 ---------------------------------------------------------
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>