adding test scripts
[csql.git] / test / cache / MultiDsn / Connection / exp.test011.ksh
blob1f504f126860890ae2c37bad29bd19d3c58e26af
1 Entries made for psql in csqlds.conf file.
2 Entries made for myodbc3 in csqlds.conf file.
3 Table 't1' is created in myodbc3
4 +---------------------------------------+
5 | Connected! |
6 | |
7 | sql-statement |
8 | help [tablename] |
9 | quit |
10 | |
11 +---------------------------------------+
12 \e[?1034hSQL> select * from t1;
13 +-----------+-----------+
14 | f1 | f2 |
15 +-----------+-----------+
16 | 100 | Hi |
17 | 200 | Hello |
18 | 300 | Hi All |
19 +-----------+-----------+
20 SQLRowCount returns 3
21 3 rows fetched
22 SQL> Table 't10' is created in psql
23 +---------------------------------------+
24 | Connected! |
25 | |
26 | sql-statement |
27 | help [tablename] |
28 | quit |
29 | |
30 +---------------------------------------+
31 \e[?1034hSQL> select * from t10;
32 +------------+-----------+
33 | f1 | f2 |
34 +------------+-----------+
35 | 1 | one |
36 | 2 | two |
37 | 3 | three |
38 +------------+-----------+
39 SQLRowCount returns 3
40 3 rows fetched
41 SQL> Table t1 is cached from myodbc3.
42 select * from t1
43 ---------------------------------------------------------
44 t1.f1 t1.f2
45 ---------------------------------------------------------
46 100 Hi
47 200 Hello
48 300 Hi All
50 Table 't10' is cached from psql.
51 select * from t10.
52 ---------------------------------------------------------
53 t10.f1 t10.f2
54 ---------------------------------------------------------
55 1 one
56 2 two
57 3 three