adding test scripts
[csql.git] / test / cache / MultiDsn / Gateway / exp.test002.ksh
blob665a0988f4bff0ad8279b2ec5c177e257c793b55
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 INSERT records using Gateway(csql -g)
69 INSERT records into t1 and t2 table.
70 Statement Executed: Rows Affected = 1
71 Statement Executed: Rows Affected = 1
72 Statement Executed: Rows Affected = 1
73 Statement Executed: Rows Affected = 1
74 Statement Executed: Rows Affected = 1
75 Statement Executed: Rows Affected = 1
76 INSERT records into tt1 and tt2 table.
77 Statement Executed: Rows Affected = 1
78 Statement Executed: Rows Affected = 1
79 Statement Executed: Rows Affected = 1
80 Statement Executed: Rows Affected = 1
81 Statement Executed: Rows Affected = 1
82 Statement Executed: Rows Affected = 1
84 SELECT records from cached and non-cached tables using Gateway(csql -g)
85 select 't1' and 't2' table.
86 ---------------------------------------------------------
87 t1.f1 t1.f2
88 ---------------------------------------------------------
89 1 Hi
90 2 Hello
91 3 Hi All
92 4 Everyone
93 5 NoOne
94 6 EveryBody
96 ---------------------------------------------------------
97 f1 f2
98 ---------------------------------------------------------
99 10 mysql
100 20 open
101 30 source
102 40 its
103 50 faster
104 60 and free
106 select 'tt1' and 'tt2' table.
107 ---------------------------------------------------------
108 tt1.f1 tt1.f2
109 ---------------------------------------------------------
110 11 one
111 22 two
112 33 three
113 44 four
114 55 five
115 66 six
117 ---------------------------------------------------------
118 f1 f2
119 ---------------------------------------------------------
120 1111 psql
121 2222 open
122 3333 source
123 4444 its
124 5555 freely
125 6666 available