Debian Codegraph @

src/interfaces/ecpg/test/expected/preproc-cursor.stderr

raw
1 [NO_PID]: ECPGdebug: set to 1
2 [NO_PID]: sqlca: code: 0, state: 00000
3 [NO_PID]: ECPGconnect: opening database ecpg1_regression on <DEFAULT> port <DEFAULT>
4 [NO_PID]: sqlca: code: 0, state: 00000
5 [NO_PID]: ECPGconnect: opening database ecpg2_regression on <DEFAULT> port <DEFAULT>
6 [NO_PID]: sqlca: code: 0, state: 00000
7 [NO_PID]: ecpg_execute on line 43: query: set datestyle to iso; with 0 parameter(s) on connection test1
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_execute on line 43: using PQexec
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: ecpg_process_output on line 43: OK: SET
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: ecpg_execute on line 46: query: create table t1 ( id serial primary key , t text ); with 0 parameter(s) on connection test1
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: ecpg_execute on line 46: using PQexec
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: ecpg_process_output on line 46: OK: CREATE TABLE
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ecpg_execute on line 47: query: create table t1 ( id serial primary key , t text ); with 0 parameter(s) on connection test2
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_execute on line 47: using PQexec
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ecpg_process_output on line 47: OK: CREATE TABLE
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: ecpg_execute on line 50: query: insert into t1 ( id , t ) values ( default , 'a' ); with 0 parameter(s) on connection test1
26 [NO_PID]: sqlca: code: 0, state: 00000
27 [NO_PID]: ecpg_execute on line 50: using PQexec
28 [NO_PID]: sqlca: code: 0, state: 00000
29 [NO_PID]: ecpg_process_output on line 50: OK: INSERT 0 1
30 [NO_PID]: sqlca: code: 0, state: 00000
31 [NO_PID]: ecpg_execute on line 51: query: insert into t1 ( id , t ) values ( default , 'b' ); with 0 parameter(s) on connection test1
32 [NO_PID]: sqlca: code: 0, state: 00000
33 [NO_PID]: ecpg_execute on line 51: using PQexec
34 [NO_PID]: sqlca: code: 0, state: 00000
35 [NO_PID]: ecpg_process_output on line 51: OK: INSERT 0 1
36 [NO_PID]: sqlca: code: 0, state: 00000
37 [NO_PID]: ecpg_execute on line 52: query: insert into t1 ( id , t ) values ( default , 'c' ); with 0 parameter(s) on connection test1
38 [NO_PID]: sqlca: code: 0, state: 00000
39 [NO_PID]: ecpg_execute on line 52: using PQexec
40 [NO_PID]: sqlca: code: 0, state: 00000
41 [NO_PID]: ecpg_process_output on line 52: OK: INSERT 0 1
42 [NO_PID]: sqlca: code: 0, state: 00000
43 [NO_PID]: ecpg_execute on line 53: query: insert into t1 ( id , t ) values ( default , 'd' ); with 0 parameter(s) on connection test1
44 [NO_PID]: sqlca: code: 0, state: 00000
45 [NO_PID]: ecpg_execute on line 53: using PQexec
46 [NO_PID]: sqlca: code: 0, state: 00000
47 [NO_PID]: ecpg_process_output on line 53: OK: INSERT 0 1
48 [NO_PID]: sqlca: code: 0, state: 00000
49 [NO_PID]: ecpg_execute on line 54: query: insert into t1 ( id , t ) values ( default , 'e' ); with 0 parameter(s) on connection test2
50 [NO_PID]: sqlca: code: 0, state: 00000
51 [NO_PID]: ecpg_execute on line 54: using PQexec
52 [NO_PID]: sqlca: code: 0, state: 00000
53 [NO_PID]: ecpg_process_output on line 54: OK: INSERT 0 1
54 [NO_PID]: sqlca: code: 0, state: 00000
55 [NO_PID]: ECPGtrans on line 57: action "commit"; connection "test1"
56 [NO_PID]: sqlca: code: 0, state: 00000
57 [NO_PID]: ECPGtrans on line 58: action "commit"; connection "test2"
58 [NO_PID]: sqlca: code: 0, state: 00000
59 [NO_PID]: ecpg_execute on line 67: query: declare mycur cursor for select id , t from t1; with 0 parameter(s) on connection test1
60 [NO_PID]: sqlca: code: 0, state: 00000
61 [NO_PID]: ecpg_execute on line 67: using PQexec
62 [NO_PID]: sqlca: code: 0, state: 00000
63 [NO_PID]: ecpg_process_output on line 67: OK: DECLARE CURSOR
64 [NO_PID]: sqlca: code: 0, state: 00000
65 [NO_PID]: ecpg_execute on line 70: query: fetch forward from mycur; with 0 parameter(s) on connection test1
66 [NO_PID]: sqlca: code: 0, state: 00000
67 [NO_PID]: ecpg_execute on line 70: using PQexec
68 [NO_PID]: sqlca: code: 0, state: 00000
69 [NO_PID]: ecpg_process_output on line 70: correctly got 1 tuples with 2 fields
70 [NO_PID]: sqlca: code: 0, state: 00000
71 [NO_PID]: ecpg_get_data on line 70: RESULT: 1 offset: -1; array: no
72 [NO_PID]: sqlca: code: 0, state: 00000
73 [NO_PID]: ecpg_get_data on line 70: RESULT: a offset: -1; array: no
74 [NO_PID]: sqlca: code: 0, state: 00000
75 [NO_PID]: ecpg_execute on line 74: query: fetch forward mycur; with 0 parameter(s) on connection test1
76 [NO_PID]: sqlca: code: 0, state: 00000
77 [NO_PID]: ecpg_execute on line 74: using PQexec
78 [NO_PID]: sqlca: code: 0, state: 00000
79 [NO_PID]: ecpg_process_output on line 74: correctly got 1 tuples with 2 fields
80 [NO_PID]: sqlca: code: 0, state: 00000
81 [NO_PID]: ecpg_get_data on line 74: RESULT: 2 offset: -1; array: no
82 [NO_PID]: sqlca: code: 0, state: 00000
83 [NO_PID]: ecpg_get_data on line 74: RESULT: b offset: -1; array: no
84 [NO_PID]: sqlca: code: 0, state: 00000
85 [NO_PID]: ecpg_execute on line 78: query: fetch 1 from mycur; with 0 parameter(s) on connection test1
86 [NO_PID]: sqlca: code: 0, state: 00000
87 [NO_PID]: ecpg_execute on line 78: using PQexec
88 [NO_PID]: sqlca: code: 0, state: 00000
89 [NO_PID]: ecpg_process_output on line 78: correctly got 1 tuples with 2 fields
90 [NO_PID]: sqlca: code: 0, state: 00000
91 [NO_PID]: ecpg_get_data on line 78: RESULT: 3 offset: -1; array: no
92 [NO_PID]: sqlca: code: 0, state: 00000
93 [NO_PID]: ecpg_get_data on line 78: RESULT: c offset: -1; array: no
94 [NO_PID]: sqlca: code: 0, state: 00000
95 [NO_PID]: ecpg_execute on line 83: query: fetch 1 from mycur; with 0 parameter(s) on connection test1
96 [NO_PID]: sqlca: code: 0, state: 00000
97 [NO_PID]: ecpg_execute on line 83: using PQexec
98 [NO_PID]: sqlca: code: 0, state: 00000
99 [NO_PID]: ecpg_process_output on line 83: correctly got 1 tuples with 2 fields
100 [NO_PID]: sqlca: code: 0, state: 00000
101 [NO_PID]: ecpg_get_data on line 83: RESULT: 4 offset: -1; array: no
102 [NO_PID]: sqlca: code: 0, state: 00000
103 [NO_PID]: ecpg_get_data on line 83: RESULT: d offset: -1; array: no
104 [NO_PID]: sqlca: code: 0, state: 00000
105 [NO_PID]: ecpg_execute on line 87: query: move absolute 0 in mycur; with 0 parameter(s) on connection test1
106 [NO_PID]: sqlca: code: 0, state: 00000
107 [NO_PID]: ecpg_execute on line 87: using PQexec
108 [NO_PID]: sqlca: code: 0, state: 00000
109 [NO_PID]: ecpg_process_output on line 87: OK: MOVE 0
110 [NO_PID]: sqlca: code: 0, state: 00000
111 [NO_PID]: ecpg_execute on line 90: query: fetch 1 mycur; with 0 parameter(s) on connection test1
112 [NO_PID]: sqlca: code: 0, state: 00000
113 [NO_PID]: ecpg_execute on line 90: using PQexec
114 [NO_PID]: sqlca: code: 0, state: 00000
115 [NO_PID]: ecpg_process_output on line 90: correctly got 1 tuples with 2 fields
116 [NO_PID]: sqlca: code: 0, state: 00000
117 [NO_PID]: ecpg_get_data on line 90: RESULT: 1 offset: -1; array: no
118 [NO_PID]: sqlca: code: 0, state: 00000
119 [NO_PID]: ecpg_get_data on line 90: RESULT: a offset: -1; array: no
120 [NO_PID]: sqlca: code: 0, state: 00000
121 [NO_PID]: ecpg_execute on line 95: query: fetch 1 mycur; with 0 parameter(s) on connection test1
122 [NO_PID]: sqlca: code: 0, state: 00000
123 [NO_PID]: ecpg_execute on line 95: using PQexec
124 [NO_PID]: sqlca: code: 0, state: 00000
125 [NO_PID]: ecpg_process_output on line 95: correctly got 1 tuples with 2 fields
126 [NO_PID]: sqlca: code: 0, state: 00000
127 [NO_PID]: ecpg_get_data on line 95: RESULT: 2 offset: -1; array: no
128 [NO_PID]: sqlca: code: 0, state: 00000
129 [NO_PID]: ecpg_get_data on line 95: RESULT: b offset: -1; array: no
130 [NO_PID]: sqlca: code: 0, state: 00000
131 [NO_PID]: ecpg_execute on line 99: query: close mycur; with 0 parameter(s) on connection test1
132 [NO_PID]: sqlca: code: 0, state: 00000
133 [NO_PID]: ecpg_execute on line 99: using PQexec
134 [NO_PID]: sqlca: code: 0, state: 00000
135 [NO_PID]: ecpg_process_output on line 99: OK: CLOSE CURSOR
136 [NO_PID]: sqlca: code: 0, state: 00000
137 [NO_PID]: ecpg_execute on line 108: query: declare mycur cursor for select id , t from t1; with 0 parameter(s) on connection test1
138 [NO_PID]: sqlca: code: 0, state: 00000
139 [NO_PID]: ecpg_execute on line 108: using PQexec
140 [NO_PID]: sqlca: code: 0, state: 00000
141 [NO_PID]: ecpg_process_output on line 108: OK: DECLARE CURSOR
142 [NO_PID]: sqlca: code: 0, state: 00000
143 [NO_PID]: ecpg_execute on line 111: query: fetch from mycur; with 0 parameter(s) on connection test1
144 [NO_PID]: sqlca: code: 0, state: 00000
145 [NO_PID]: ecpg_execute on line 111: using PQexec
146 [NO_PID]: sqlca: code: 0, state: 00000
147 [NO_PID]: ecpg_process_output on line 111: correctly got 1 tuples with 2 fields
148 [NO_PID]: sqlca: code: 0, state: 00000
149 [NO_PID]: ecpg_get_data on line 111: RESULT: 1 offset: -1; array: no
150 [NO_PID]: sqlca: code: 0, state: 00000
151 [NO_PID]: ecpg_get_data on line 111: RESULT: a offset: -1; array: no
152 [NO_PID]: sqlca: code: 0, state: 00000
153 [NO_PID]: ecpg_execute on line 115: query: fetch mycur; with 0 parameter(s) on connection test1
154 [NO_PID]: sqlca: code: 0, state: 00000
155 [NO_PID]: ecpg_execute on line 115: using PQexec
156 [NO_PID]: sqlca: code: 0, state: 00000
157 [NO_PID]: ecpg_process_output on line 115: correctly got 1 tuples with 2 fields
158 [NO_PID]: sqlca: code: 0, state: 00000
159 [NO_PID]: ecpg_get_data on line 115: RESULT: 2 offset: -1; array: no
160 [NO_PID]: sqlca: code: 0, state: 00000
161 [NO_PID]: ecpg_get_data on line 115: RESULT: b offset: -1; array: no
162 [NO_PID]: sqlca: code: 0, state: 00000
163 [NO_PID]: ecpg_execute on line 119: query: fetch 1 from mycur; with 0 parameter(s) on connection test1
164 [NO_PID]: sqlca: code: 0, state: 00000
165 [NO_PID]: ecpg_execute on line 119: using PQexec
166 [NO_PID]: sqlca: code: 0, state: 00000
167 [NO_PID]: ecpg_process_output on line 119: correctly got 1 tuples with 2 fields
168 [NO_PID]: sqlca: code: 0, state: 00000
169 [NO_PID]: ecpg_get_data on line 119: RESULT: 3 offset: -1; array: no
170 [NO_PID]: sqlca: code: 0, state: 00000
171 [NO_PID]: ecpg_get_data on line 119: RESULT: c offset: -1; array: no
172 [NO_PID]: sqlca: code: 0, state: 00000
173 [NO_PID]: ecpg_execute on line 124: query: fetch 1 from mycur; with 0 parameter(s) on connection test1
174 [NO_PID]: sqlca: code: 0, state: 00000
175 [NO_PID]: ecpg_execute on line 124: using PQexec
176 [NO_PID]: sqlca: code: 0, state: 00000
177 [NO_PID]: ecpg_process_output on line 124: correctly got 1 tuples with 2 fields
178 [NO_PID]: sqlca: code: 0, state: 00000
179 [NO_PID]: ecpg_get_data on line 124: RESULT: 4 offset: -1; array: no
180 [NO_PID]: sqlca: code: 0, state: 00000
181 [NO_PID]: ecpg_get_data on line 124: RESULT: d offset: -1; array: no
182 [NO_PID]: sqlca: code: 0, state: 00000
183 [NO_PID]: ecpg_execute on line 128: query: move absolute 0 mycur; with 0 parameter(s) on connection test1
184 [NO_PID]: sqlca: code: 0, state: 00000
185 [NO_PID]: ecpg_execute on line 128: using PQexec
186 [NO_PID]: sqlca: code: 0, state: 00000
187 [NO_PID]: ecpg_process_output on line 128: OK: MOVE 0
188 [NO_PID]: sqlca: code: 0, state: 00000
189 [NO_PID]: ecpg_execute on line 131: query: fetch 1 mycur; with 0 parameter(s) on connection test1
190 [NO_PID]: sqlca: code: 0, state: 00000
191 [NO_PID]: ecpg_execute on line 131: using PQexec
192 [NO_PID]: sqlca: code: 0, state: 00000
193 [NO_PID]: ecpg_process_output on line 131: correctly got 1 tuples with 2 fields
194 [NO_PID]: sqlca: code: 0, state: 00000
195 [NO_PID]: ecpg_get_data on line 131: RESULT: 1 offset: -1; array: no
196 [NO_PID]: sqlca: code: 0, state: 00000
197 [NO_PID]: ecpg_get_data on line 131: RESULT: a offset: -1; array: no
198 [NO_PID]: sqlca: code: 0, state: 00000
199 [NO_PID]: ecpg_execute on line 136: query: fetch 1 mycur; with 0 parameter(s) on connection test1
200 [NO_PID]: sqlca: code: 0, state: 00000
201 [NO_PID]: ecpg_execute on line 136: using PQexec
202 [NO_PID]: sqlca: code: 0, state: 00000
203 [NO_PID]: ecpg_process_output on line 136: correctly got 1 tuples with 2 fields
204 [NO_PID]: sqlca: code: 0, state: 00000
205 [NO_PID]: ecpg_get_data on line 136: RESULT: 2 offset: -1; array: no
206 [NO_PID]: sqlca: code: 0, state: 00000
207 [NO_PID]: ecpg_get_data on line 136: RESULT: b offset: -1; array: no
208 [NO_PID]: sqlca: code: 0, state: 00000
209 [NO_PID]: ecpg_execute on line 140: query: close mycur; with 0 parameter(s) on connection test1
210 [NO_PID]: sqlca: code: 0, state: 00000
211 [NO_PID]: ecpg_execute on line 140: using PQexec
212 [NO_PID]: sqlca: code: 0, state: 00000
213 [NO_PID]: ecpg_process_output on line 140: OK: CLOSE CURSOR
214 [NO_PID]: sqlca: code: 0, state: 00000
215 [NO_PID]: prepare_common on line 145: name st_id1; query: "SELECT id, t FROM t1"
216 [NO_PID]: sqlca: code: 0, state: 00000
217 [NO_PID]: prepare_common on line 146: name st_id1; query: "SELECT id, t FROM t1"
218 [NO_PID]: sqlca: code: 0, state: 00000
219 [NO_PID]: ecpg_execute on line 153: query: declare mycur cursor for SELECT id, t FROM t1; with 0 parameter(s) on connection test1
220 [NO_PID]: sqlca: code: 0, state: 00000
221 [NO_PID]: ecpg_execute on line 153: using PQexec
222 [NO_PID]: sqlca: code: 0, state: 00000
223 [NO_PID]: ecpg_process_output on line 153: OK: DECLARE CURSOR
224 [NO_PID]: sqlca: code: 0, state: 00000
225 [NO_PID]: ecpg_execute on line 154: query: declare mycur cursor for SELECT id, t FROM t1; with 0 parameter(s) on connection test2
226 [NO_PID]: sqlca: code: 0, state: 00000
227 [NO_PID]: ecpg_execute on line 154: using PQexec
228 [NO_PID]: sqlca: code: 0, state: 00000
229 [NO_PID]: ecpg_process_output on line 154: OK: DECLARE CURSOR
230 [NO_PID]: sqlca: code: 0, state: 00000
231 [NO_PID]: ecpg_execute on line 157: query: fetch mycur; with 0 parameter(s) on connection test2
232 [NO_PID]: sqlca: code: 0, state: 00000
233 [NO_PID]: ecpg_execute on line 157: using PQexec
234 [NO_PID]: sqlca: code: 0, state: 00000
235 [NO_PID]: ecpg_process_output on line 157: correctly got 1 tuples with 2 fields
236 [NO_PID]: sqlca: code: 0, state: 00000
237 [NO_PID]: ecpg_get_data on line 157: RESULT: 1 offset: -1; array: no
238 [NO_PID]: sqlca: code: 0, state: 00000
239 [NO_PID]: ecpg_get_data on line 157: RESULT: e offset: -1; array: no
240 [NO_PID]: sqlca: code: 0, state: 00000
241 [NO_PID]: ecpg_execute on line 161: query: fetch from mycur; with 0 parameter(s) on connection test1
242 [NO_PID]: sqlca: code: 0, state: 00000
243 [NO_PID]: ecpg_execute on line 161: using PQexec
244 [NO_PID]: sqlca: code: 0, state: 00000
245 [NO_PID]: ecpg_process_output on line 161: correctly got 1 tuples with 2 fields
246 [NO_PID]: sqlca: code: 0, state: 00000
247 [NO_PID]: ecpg_get_data on line 161: RESULT: 1 offset: -1; array: no
248 [NO_PID]: sqlca: code: 0, state: 00000
249 [NO_PID]: ecpg_get_data on line 161: RESULT: a offset: -1; array: no
250 [NO_PID]: sqlca: code: 0, state: 00000
251 [NO_PID]: ecpg_execute on line 165: query: fetch 1 from mycur; with 0 parameter(s) on connection test1
252 [NO_PID]: sqlca: code: 0, state: 00000
253 [NO_PID]: ecpg_execute on line 165: using PQexec
254 [NO_PID]: sqlca: code: 0, state: 00000
255 [NO_PID]: ecpg_process_output on line 165: correctly got 1 tuples with 2 fields
256 [NO_PID]: sqlca: code: 0, state: 00000
257 [NO_PID]: ecpg_get_data on line 165: RESULT: 2 offset: -1; array: no
258 [NO_PID]: sqlca: code: 0, state: 00000
259 [NO_PID]: ecpg_get_data on line 165: RESULT: b offset: -1; array: no
260 [NO_PID]: sqlca: code: 0, state: 00000
261 [NO_PID]: ecpg_execute on line 170: query: fetch 1 from mycur; with 0 parameter(s) on connection test1
262 [NO_PID]: sqlca: code: 0, state: 00000
263 [NO_PID]: ecpg_execute on line 170: using PQexec
264 [NO_PID]: sqlca: code: 0, state: 00000
265 [NO_PID]: ecpg_process_output on line 170: correctly got 1 tuples with 2 fields
266 [NO_PID]: sqlca: code: 0, state: 00000
267 [NO_PID]: ecpg_get_data on line 170: RESULT: 3 offset: -1; array: no
268 [NO_PID]: sqlca: code: 0, state: 00000
269 [NO_PID]: ecpg_get_data on line 170: RESULT: c offset: -1; array: no
270 [NO_PID]: sqlca: code: 0, state: 00000
271 [NO_PID]: ecpg_execute on line 174: query: move absolute 0 mycur; with 0 parameter(s) on connection test1
272 [NO_PID]: sqlca: code: 0, state: 00000
273 [NO_PID]: ecpg_execute on line 174: using PQexec
274 [NO_PID]: sqlca: code: 0, state: 00000
275 [NO_PID]: ecpg_process_output on line 174: OK: MOVE 0
276 [NO_PID]: sqlca: code: 0, state: 00000
277 [NO_PID]: ecpg_execute on line 177: query: fetch 1 mycur; with 0 parameter(s) on connection test1
278 [NO_PID]: sqlca: code: 0, state: 00000
279 [NO_PID]: ecpg_execute on line 177: using PQexec
280 [NO_PID]: sqlca: code: 0, state: 00000
281 [NO_PID]: ecpg_process_output on line 177: correctly got 1 tuples with 2 fields
282 [NO_PID]: sqlca: code: 0, state: 00000
283 [NO_PID]: ecpg_get_data on line 177: RESULT: 1 offset: -1; array: no
284 [NO_PID]: sqlca: code: 0, state: 00000
285 [NO_PID]: ecpg_get_data on line 177: RESULT: a offset: -1; array: no
286 [NO_PID]: sqlca: code: 0, state: 00000
287 [NO_PID]: ecpg_execute on line 182: query: fetch 1 mycur; with 0 parameter(s) on connection test1
288 [NO_PID]: sqlca: code: 0, state: 00000
289 [NO_PID]: ecpg_execute on line 182: using PQexec
290 [NO_PID]: sqlca: code: 0, state: 00000
291 [NO_PID]: ecpg_process_output on line 182: correctly got 1 tuples with 2 fields
292 [NO_PID]: sqlca: code: 0, state: 00000
293 [NO_PID]: ecpg_get_data on line 182: RESULT: 2 offset: -1; array: no
294 [NO_PID]: sqlca: code: 0, state: 00000
295 [NO_PID]: ecpg_get_data on line 182: RESULT: b offset: -1; array: no
296 [NO_PID]: sqlca: code: 0, state: 00000
297 [NO_PID]: ecpg_execute on line 186: query: close mycur; with 0 parameter(s) on connection test1
298 [NO_PID]: sqlca: code: 0, state: 00000
299 [NO_PID]: ecpg_execute on line 186: using PQexec
300 [NO_PID]: sqlca: code: 0, state: 00000
301 [NO_PID]: ecpg_process_output on line 186: OK: CLOSE CURSOR
302 [NO_PID]: sqlca: code: 0, state: 00000
303 [NO_PID]: ecpg_execute on line 187: query: close mycur; with 0 parameter(s) on connection test2
304 [NO_PID]: sqlca: code: 0, state: 00000
305 [NO_PID]: ecpg_execute on line 187: using PQexec
306 [NO_PID]: sqlca: code: 0, state: 00000
307 [NO_PID]: ecpg_process_output on line 187: OK: CLOSE CURSOR
308 [NO_PID]: sqlca: code: 0, state: 00000
309 [NO_PID]: deallocate_one on line 190: name st_id1
310 [NO_PID]: sqlca: code: 0, state: 00000
311 [NO_PID]: deallocate_one on line 191: name st_id1
312 [NO_PID]: sqlca: code: 0, state: 00000
313 [NO_PID]: prepare_common on line 200: name st_id2; query: "SELECT id, t FROM t1"
314 [NO_PID]: sqlca: code: 0, state: 00000
315 [NO_PID]: ecpg_execute on line 206: query: declare mycur cursor for SELECT id, t FROM t1; with 0 parameter(s) on connection test1
316 [NO_PID]: sqlca: code: 0, state: 00000
317 [NO_PID]: ecpg_execute on line 206: using PQexec
318 [NO_PID]: sqlca: code: 0, state: 00000
319 [NO_PID]: ecpg_process_output on line 206: OK: DECLARE CURSOR
320 [NO_PID]: sqlca: code: 0, state: 00000
321 [NO_PID]: ecpg_execute on line 209: query: fetch from mycur; with 0 parameter(s) on connection test1
322 [NO_PID]: sqlca: code: 0, state: 00000
323 [NO_PID]: ecpg_execute on line 209: using PQexec
324 [NO_PID]: sqlca: code: 0, state: 00000
325 [NO_PID]: ecpg_process_output on line 209: correctly got 1 tuples with 2 fields
326 [NO_PID]: sqlca: code: 0, state: 00000
327 [NO_PID]: ecpg_get_data on line 209: RESULT: 1 offset: -1; array: no
328 [NO_PID]: sqlca: code: 0, state: 00000
329 [NO_PID]: ecpg_get_data on line 209: RESULT: a offset: -1; array: no
330 [NO_PID]: sqlca: code: 0, state: 00000
331 [NO_PID]: ecpg_execute on line 213: query: fetch mycur; with 0 parameter(s) on connection test1
332 [NO_PID]: sqlca: code: 0, state: 00000
333 [NO_PID]: ecpg_execute on line 213: using PQexec
334 [NO_PID]: sqlca: code: 0, state: 00000
335 [NO_PID]: ecpg_process_output on line 213: correctly got 1 tuples with 2 fields
336 [NO_PID]: sqlca: code: 0, state: 00000
337 [NO_PID]: ecpg_get_data on line 213: RESULT: 2 offset: -1; array: no
338 [NO_PID]: sqlca: code: 0, state: 00000
339 [NO_PID]: ecpg_get_data on line 213: RESULT: b offset: -1; array: no
340 [NO_PID]: sqlca: code: 0, state: 00000
341 [NO_PID]: ecpg_execute on line 217: query: fetch 1 from mycur; with 0 parameter(s) on connection test1
342 [NO_PID]: sqlca: code: 0, state: 00000
343 [NO_PID]: ecpg_execute on line 217: using PQexec
344 [NO_PID]: sqlca: code: 0, state: 00000
345 [NO_PID]: ecpg_process_output on line 217: correctly got 1 tuples with 2 fields
346 [NO_PID]: sqlca: code: 0, state: 00000
347 [NO_PID]: ecpg_get_data on line 217: RESULT: 3 offset: -1; array: no
348 [NO_PID]: sqlca: code: 0, state: 00000
349 [NO_PID]: ecpg_get_data on line 217: RESULT: c offset: -1; array: no
350 [NO_PID]: sqlca: code: 0, state: 00000
351 [NO_PID]: ecpg_execute on line 222: query: fetch 1 from mycur; with 0 parameter(s) on connection test1
352 [NO_PID]: sqlca: code: 0, state: 00000
353 [NO_PID]: ecpg_execute on line 222: using PQexec
354 [NO_PID]: sqlca: code: 0, state: 00000
355 [NO_PID]: ecpg_process_output on line 222: correctly got 1 tuples with 2 fields
356 [NO_PID]: sqlca: code: 0, state: 00000
357 [NO_PID]: ecpg_get_data on line 222: RESULT: 4 offset: -1; array: no
358 [NO_PID]: sqlca: code: 0, state: 00000
359 [NO_PID]: ecpg_get_data on line 222: RESULT: d offset: -1; array: no
360 [NO_PID]: sqlca: code: 0, state: 00000
361 [NO_PID]: ecpg_execute on line 226: query: move absolute 0 mycur; with 0 parameter(s) on connection test1
362 [NO_PID]: sqlca: code: 0, state: 00000
363 [NO_PID]: ecpg_execute on line 226: using PQexec
364 [NO_PID]: sqlca: code: 0, state: 00000
365 [NO_PID]: ecpg_process_output on line 226: OK: MOVE 0
366 [NO_PID]: sqlca: code: 0, state: 00000
367 [NO_PID]: ecpg_execute on line 229: query: fetch 1 mycur; with 0 parameter(s) on connection test1
368 [NO_PID]: sqlca: code: 0, state: 00000
369 [NO_PID]: ecpg_execute on line 229: using PQexec
370 [NO_PID]: sqlca: code: 0, state: 00000
371 [NO_PID]: ecpg_process_output on line 229: correctly got 1 tuples with 2 fields
372 [NO_PID]: sqlca: code: 0, state: 00000
373 [NO_PID]: ecpg_get_data on line 229: RESULT: 1 offset: -1; array: no
374 [NO_PID]: sqlca: code: 0, state: 00000
375 [NO_PID]: ecpg_get_data on line 229: RESULT: a offset: -1; array: no
376 [NO_PID]: sqlca: code: 0, state: 00000
377 [NO_PID]: ecpg_execute on line 234: query: fetch 1 mycur; with 0 parameter(s) on connection test1
378 [NO_PID]: sqlca: code: 0, state: 00000
379 [NO_PID]: ecpg_execute on line 234: using PQexec
380 [NO_PID]: sqlca: code: 0, state: 00000
381 [NO_PID]: ecpg_process_output on line 234: correctly got 1 tuples with 2 fields
382 [NO_PID]: sqlca: code: 0, state: 00000
383 [NO_PID]: ecpg_get_data on line 234: RESULT: 2 offset: -1; array: no
384 [NO_PID]: sqlca: code: 0, state: 00000
385 [NO_PID]: ecpg_get_data on line 234: RESULT: b offset: -1; array: no
386 [NO_PID]: sqlca: code: 0, state: 00000
387 [NO_PID]: ecpg_execute on line 238: query: close mycur; with 0 parameter(s) on connection test1
388 [NO_PID]: sqlca: code: 0, state: 00000
389 [NO_PID]: ecpg_execute on line 238: using PQexec
390 [NO_PID]: sqlca: code: 0, state: 00000
391 [NO_PID]: ecpg_process_output on line 238: OK: CLOSE CURSOR
392 [NO_PID]: sqlca: code: 0, state: 00000
393 [NO_PID]: deallocate_one on line 241: name st_id2
394 [NO_PID]: sqlca: code: 0, state: 00000
395 [NO_PID]: ecpg_execute on line 246: query: drop table t1; with 0 parameter(s) on connection test1
396 [NO_PID]: sqlca: code: 0, state: 00000
397 [NO_PID]: ecpg_execute on line 246: using PQexec
398 [NO_PID]: sqlca: code: 0, state: 00000
399 [NO_PID]: ecpg_process_output on line 246: OK: DROP TABLE
400 [NO_PID]: sqlca: code: 0, state: 00000
401 [NO_PID]: ecpg_execute on line 247: query: drop table t1; with 0 parameter(s) on connection test2
402 [NO_PID]: sqlca: code: 0, state: 00000
403 [NO_PID]: ecpg_execute on line 247: using PQexec
404 [NO_PID]: sqlca: code: 0, state: 00000
405 [NO_PID]: ecpg_process_output on line 247: OK: DROP TABLE
406 [NO_PID]: sqlca: code: 0, state: 00000
407 [NO_PID]: ECPGtrans on line 250: action "commit"; connection "test1"
408 [NO_PID]: sqlca: code: 0, state: 00000
409 [NO_PID]: ecpg_finish: connection test2 closed
410 [NO_PID]: sqlca: code: 0, state: 00000
411 [NO_PID]: ecpg_finish: connection test1 closed
412 [NO_PID]: sqlca: code: 0, state: 00000