adding test scripts
[csql.git] / test / cache / MultiDsn / Gateway / exp.test022.ksh
blobea38a96fc6a8abf0d0ef9f3a5a275349e7fb83c3
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 UPDATE tables using Gateway(csql -g)
69 update 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 update tt1 and tt2 table.
75 Statement Executed: Rows Affected = 1
76 Statement Executed: Rows Affected = 1
77 Statement Executed: Rows Affected = 1
78 Statement Executed: Rows Affected = 1
80 SELECT records from cached and non-cached tables using Gateway(csql -g)
81 select 't1' and 't2' table.
82 ---------------------------------------------------------
83 t1.f1 t1.f2
84 ---------------------------------------------------------
85 1 Hi
86 2 Hello
87 3 Hi All
89 ---------------------------------------------------------
90 f1 f2
91 ---------------------------------------------------------
92 1000 MySQL
93 2000 Faster
94 30 source
96 select 'tt1' and 'tt2' table.
97 ---------------------------------------------------------
98 tt1.f1 tt1.f2
99 ---------------------------------------------------------
100 11 one
101 22 two
102 33 three
104 ---------------------------------------------------------
105 f1 f2
106 ---------------------------------------------------------
107 3333 source
108 1 psql
109 2 open