adding test scripts
[csql.git] / test / cache / MultiDsn / Gateway / exp.test020.ksh
bloba25335a3cf3da6558f7c3cb69b94f99a356673a2
1 Entries made for myodbc3 in csqlds.conf file.
2 Entries made for psql in csqlds.conf file.
3 Table 't1 and t2' is created in myodbc3
4 SELECT records from myodbc3
5 +---------------------------------------+
6 | Connected! |
7 | |
8 | sql-statement |
9 | help [tablename] |
10 | quit |
11 | |
12 +---------------------------------------+
13 \e[?1034hSQL> select * from t1;
14 +-----------+---------------------+
15 | f1 | f2 |
16 +-----------+---------------------+
17 | 1 | Hi |
18 | 2 | Hello |
19 | 3 | Hi All |
20 +-----------+---------------------+
21 SQLRowCount returns 3
22 3 rows fetched
23 SQL> select * from t2;
24 +-----------+---------------------+
25 | f1 | f2 |
26 +-----------+---------------------+
27 | 10 | mysql |
28 | 20 | open |
29 | 30 | source |
30 +-----------+---------------------+
31 SQLRowCount returns 3
32 3 rows fetched
33 SQL>
34 Table 'tt1 and tt2' is created in psql
35 SELECT records from psql
36 +---------------------------------------+
37 | Connected! |
38 | |
39 | sql-statement |
40 | help [tablename] |
41 | quit |
42 | |
43 +---------------------------------------+
44 \e[?1034hSQL> select * from tt1;
45 +------------+-----------+
46 | f1 | f2 |
47 +------------+-----------+
48 | 11 | one |
49 | 22 | two |
50 | 33 | three |
51 +------------+-----------+
52 SQLRowCount returns 3
53 3 rows fetched
54 SQL> select * from tt2;
55 +------------+-----------+
56 | f1 | f2 |
57 +------------+-----------+
58 | 1111 | psql |
59 | 2222 | open |
60 | 3333 | source |
61 +------------+-----------+
62 SQLRowCount returns 3
63 3 rows fetched
64 SQL>
65 Table t1 is cached from myodbc3.
66 Table 'tt1' is cached from psql.
68 Select records using Gateway(csql -g)
69 select records from t1 and t2
70 ---------------------------------------------------------
71 t1.f1 t1.f2
72 ---------------------------------------------------------
73 1 Hi
74 2 Hello
75 3 Hi All
77 ---------------------------------------------------------
78 f1 f2
79 ---------------------------------------------------------
80 10 mysql
81 20 open
82 30 source
84 select records from tt1 and tt2.
85 ---------------------------------------------------------
86 f1 f2
87 ---------------------------------------------------------
88 11 one
89 22 two
90 33 three
92 ---------------------------------------------------------
93 f1 f2
94 ---------------------------------------------------------
95 1111 psql
96 2222 open
97 3333 source