Debian Codegraph @

src/interfaces/ecpg/test/expected/sql-declare.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 32: query: create table source ( f1 integer , f2 integer , f3 varchar ( 20 ) ); with 0 parameter(s) on connection con1
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_execute on line 32: using PQexec
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: ecpg_process_output on line 32: OK: CREATE TABLE
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: ecpg_execute on line 33: query: create table source ( f1 integer , f2 integer , f3 varchar ( 20 ) ); with 0 parameter(s) on connection con2
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: ecpg_execute on line 33: using PQexec
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: ecpg_process_output on line 33: OK: CREATE TABLE
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ecpg_execute on line 35: query: insert into source values ( 1 , 10 , 'db on con1' ); with 0 parameter(s) on connection con1
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_execute on line 35: using PQexec
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ecpg_process_output on line 35: OK: INSERT 0 1
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: ecpg_execute on line 36: query: insert into source values ( 2 , 20 , 'db on con1' ); with 0 parameter(s) on connection con1
26 [NO_PID]: sqlca: code: 0, state: 00000
27 [NO_PID]: ecpg_execute on line 36: using PQexec
28 [NO_PID]: sqlca: code: 0, state: 00000
29 [NO_PID]: ecpg_process_output on line 36: OK: INSERT 0 1
30 [NO_PID]: sqlca: code: 0, state: 00000
31 [NO_PID]: ecpg_execute on line 38: query: insert into source values ( 1 , 10 , 'db on con2' ); with 0 parameter(s) on connection con2
32 [NO_PID]: sqlca: code: 0, state: 00000
33 [NO_PID]: ecpg_execute on line 38: using PQexec
34 [NO_PID]: sqlca: code: 0, state: 00000
35 [NO_PID]: ecpg_process_output on line 38: OK: INSERT 0 1
36 [NO_PID]: sqlca: code: 0, state: 00000
37 [NO_PID]: ecpg_execute on line 39: query: insert into source values ( 2 , 20 , 'db on con2' ); with 0 parameter(s) on connection con2
38 [NO_PID]: sqlca: code: 0, state: 00000
39 [NO_PID]: ecpg_execute on line 39: using PQexec
40 [NO_PID]: sqlca: code: 0, state: 00000
41 [NO_PID]: ecpg_process_output on line 39: OK: INSERT 0 1
42 [NO_PID]: sqlca: code: 0, state: 00000
43 [NO_PID]: ECPGtrans on line 187: action "commit"; connection "con1"
44 [NO_PID]: sqlca: code: 0, state: 00000
45 [NO_PID]: ECPGtrans on line 188: action "commit"; connection "con2"
46 [NO_PID]: sqlca: code: 0, state: 00000
47 [NO_PID]: prepare_common on line 74: name stmt_1; query: "SELECT f1,f2,f3 FROM source"
48 [NO_PID]: sqlca: code: 0, state: 00000
49 [NO_PID]: ecpg_execute on line 76: query: declare cur_1 cursor for SELECT f1,f2,f3 FROM source; with 0 parameter(s) on connection con2
50 [NO_PID]: sqlca: code: 0, state: 00000
51 [NO_PID]: ecpg_execute on line 76: using PQexec
52 [NO_PID]: sqlca: code: 0, state: 00000
53 [NO_PID]: ecpg_process_output on line 76: OK: DECLARE CURSOR
54 [NO_PID]: sqlca: code: 0, state: 00000
55 [NO_PID]: ecpg_execute on line 82: query: fetch cur_1; with 0 parameter(s) on connection con2
56 [NO_PID]: sqlca: code: 0, state: 00000
57 [NO_PID]: ecpg_execute on line 82: using PQexec
58 [NO_PID]: sqlca: code: 0, state: 00000
59 [NO_PID]: ecpg_process_output on line 82: correctly got 1 tuples with 3 fields
60 [NO_PID]: sqlca: code: 0, state: 00000
61 [NO_PID]: ecpg_get_data on line 82: RESULT: 1 offset: -1; array: no
62 [NO_PID]: sqlca: code: 0, state: 00000
63 [NO_PID]: ecpg_get_data on line 82: RESULT: 10 offset: -1; array: no
64 [NO_PID]: sqlca: code: 0, state: 00000
65 [NO_PID]: ecpg_get_data on line 82: RESULT: db on con2 offset: -1; array: no
66 [NO_PID]: sqlca: code: 0, state: 00000
67 [NO_PID]: ecpg_execute on line 82: query: fetch cur_1; with 0 parameter(s) on connection con2
68 [NO_PID]: sqlca: code: 0, state: 00000
69 [NO_PID]: ecpg_execute on line 82: using PQexec
70 [NO_PID]: sqlca: code: 0, state: 00000
71 [NO_PID]: ecpg_process_output on line 82: correctly got 1 tuples with 3 fields
72 [NO_PID]: sqlca: code: 0, state: 00000
73 [NO_PID]: ecpg_get_data on line 82: RESULT: 2 offset: -1; array: no
74 [NO_PID]: sqlca: code: 0, state: 00000
75 [NO_PID]: ecpg_get_data on line 82: RESULT: 20 offset: -1; array: no
76 [NO_PID]: sqlca: code: 0, state: 00000
77 [NO_PID]: ecpg_get_data on line 82: RESULT: db on con2 offset: -1; array: no
78 [NO_PID]: sqlca: code: 0, state: 00000
79 [NO_PID]: ecpg_execute on line 82: query: fetch cur_1; with 0 parameter(s) on connection con2
80 [NO_PID]: sqlca: code: 0, state: 00000
81 [NO_PID]: ecpg_execute on line 82: using PQexec
82 [NO_PID]: sqlca: code: 0, state: 00000
83 [NO_PID]: ecpg_process_output on line 82: correctly got 0 tuples with 3 fields
84 [NO_PID]: sqlca: code: 0, state: 00000
85 [NO_PID]: raising sqlcode 100 on line 82: no data found on line 82
86 [NO_PID]: sqlca: code: 100, state: 02000
87 [NO_PID]: ecpg_execute on line 85: query: close cur_1; with 0 parameter(s) on connection con2
88 [NO_PID]: sqlca: code: 0, state: 00000
89 [NO_PID]: ecpg_execute on line 85: using PQexec
90 [NO_PID]: sqlca: code: 0, state: 00000
91 [NO_PID]: ecpg_process_output on line 85: OK: CLOSE CURSOR
92 [NO_PID]: sqlca: code: 0, state: 00000
93 [NO_PID]: deallocate_one on line 86: name stmt_1
94 [NO_PID]: sqlca: code: 0, state: 00000
95 [NO_PID]: prepare_common on line 99: name stmt_2; query: "SELECT f1,f2,f3 FROM source"
96 [NO_PID]: sqlca: code: 0, state: 00000
97 [NO_PID]: ecpg_execute on line 101: query: declare cur_2 cursor for SELECT f1,f2,f3 FROM source; with 0 parameter(s) on connection con1
98 [NO_PID]: sqlca: code: 0, state: 00000
99 [NO_PID]: ecpg_execute on line 101: using PQexec
100 [NO_PID]: sqlca: code: 0, state: 00000
101 [NO_PID]: ecpg_process_output on line 101: OK: DECLARE CURSOR
102 [NO_PID]: sqlca: code: 0, state: 00000
103 [NO_PID]: ecpg_execute on line 107: query: fetch cur_2; with 0 parameter(s) on connection con1
104 [NO_PID]: sqlca: code: 0, state: 00000
105 [NO_PID]: ecpg_execute on line 107: using PQexec
106 [NO_PID]: sqlca: code: 0, state: 00000
107 [NO_PID]: ecpg_process_output on line 107: correctly got 1 tuples with 3 fields
108 [NO_PID]: sqlca: code: 0, state: 00000
109 [NO_PID]: ecpg_get_data on line 107: RESULT: 1 offset: -1; array: no
110 [NO_PID]: sqlca: code: 0, state: 00000
111 [NO_PID]: ecpg_get_data on line 107: RESULT: 10 offset: -1; array: no
112 [NO_PID]: sqlca: code: 0, state: 00000
113 [NO_PID]: ecpg_get_data on line 107: RESULT: db on con1 offset: -1; array: no
114 [NO_PID]: sqlca: code: 0, state: 00000
115 [NO_PID]: ecpg_execute on line 107: query: fetch cur_2; with 0 parameter(s) on connection con1
116 [NO_PID]: sqlca: code: 0, state: 00000
117 [NO_PID]: ecpg_execute on line 107: using PQexec
118 [NO_PID]: sqlca: code: 0, state: 00000
119 [NO_PID]: ecpg_process_output on line 107: correctly got 1 tuples with 3 fields
120 [NO_PID]: sqlca: code: 0, state: 00000
121 [NO_PID]: ecpg_get_data on line 107: RESULT: 2 offset: -1; array: no
122 [NO_PID]: sqlca: code: 0, state: 00000
123 [NO_PID]: ecpg_get_data on line 107: RESULT: 20 offset: -1; array: no
124 [NO_PID]: sqlca: code: 0, state: 00000
125 [NO_PID]: ecpg_get_data on line 107: RESULT: db on con1 offset: -1; array: no
126 [NO_PID]: sqlca: code: 0, state: 00000
127 [NO_PID]: ecpg_execute on line 107: query: fetch cur_2; with 0 parameter(s) on connection con1
128 [NO_PID]: sqlca: code: 0, state: 00000
129 [NO_PID]: ecpg_execute on line 107: using PQexec
130 [NO_PID]: sqlca: code: 0, state: 00000
131 [NO_PID]: ecpg_process_output on line 107: correctly got 0 tuples with 3 fields
132 [NO_PID]: sqlca: code: 0, state: 00000
133 [NO_PID]: raising sqlcode 100 on line 107: no data found on line 107
134 [NO_PID]: sqlca: code: 100, state: 02000
135 [NO_PID]: ecpg_execute on line 110: query: close cur_2; with 0 parameter(s) on connection con1
136 [NO_PID]: sqlca: code: 0, state: 00000
137 [NO_PID]: ecpg_execute on line 110: using PQexec
138 [NO_PID]: sqlca: code: 0, state: 00000
139 [NO_PID]: ecpg_process_output on line 110: OK: CLOSE CURSOR
140 [NO_PID]: sqlca: code: 0, state: 00000
141 [NO_PID]: deallocate_one on line 111: name stmt_2
142 [NO_PID]: sqlca: code: 0, state: 00000
143 [NO_PID]: prepare_common on line 123: name stmt_3; query: "SELECT f1,f2,f3 FROM source"
144 [NO_PID]: sqlca: code: 0, state: 00000
145 [NO_PID]: ecpg_execute on line 124: query: SELECT f1,f2,f3 FROM source; with 0 parameter(s) on connection con2
146 [NO_PID]: sqlca: code: 0, state: 00000
147 [NO_PID]: ecpg_execute on line 124: using PQexecPrepared for "SELECT f1,f2,f3 FROM source"
148 [NO_PID]: sqlca: code: 0, state: 00000
149 [NO_PID]: ecpg_process_output on line 124: correctly got 2 tuples with 3 fields
150 [NO_PID]: sqlca: code: 0, state: 00000
151 [NO_PID]: ecpg_get_data on line 124: RESULT: 1 offset: -1; array: no
152 [NO_PID]: sqlca: code: 0, state: 00000
153 [NO_PID]: ecpg_get_data on line 124: RESULT: 2 offset: -1; array: no
154 [NO_PID]: sqlca: code: 0, state: 00000
155 [NO_PID]: ecpg_get_data on line 124: RESULT: 10 offset: -1; array: no
156 [NO_PID]: sqlca: code: 0, state: 00000
157 [NO_PID]: ecpg_get_data on line 124: RESULT: 20 offset: -1; array: no
158 [NO_PID]: sqlca: code: 0, state: 00000
159 [NO_PID]: ecpg_get_data on line 124: RESULT: db on con2 offset: -1; array: no
160 [NO_PID]: sqlca: code: 0, state: 00000
161 [NO_PID]: ecpg_get_data on line 124: RESULT: db on con2 offset: -1; array: no
162 [NO_PID]: sqlca: code: 0, state: 00000
163 [NO_PID]: deallocate_one on line 126: name stmt_3
164 [NO_PID]: sqlca: code: 0, state: 00000
165 [NO_PID]: prepare_common on line 137: name stmt_4; query: "SELECT f1,f2,f3 FROM source"
166 [NO_PID]: sqlca: code: 0, state: 00000
167 [NO_PID]: ecpg_execute on line 139: query: declare cur_4 cursor for SELECT f1,f2,f3 FROM source; with 0 parameter(s) on connection con2
168 [NO_PID]: sqlca: code: 0, state: 00000
169 [NO_PID]: ecpg_execute on line 139: using PQexec
170 [NO_PID]: sqlca: code: 0, state: 00000
171 [NO_PID]: ecpg_process_output on line 139: OK: DECLARE CURSOR
172 [NO_PID]: sqlca: code: 0, state: 00000
173 [NO_PID]: ecpg_execute on line 145: query: fetch cur_4; with 0 parameter(s) on connection con2
174 [NO_PID]: sqlca: code: 0, state: 00000
175 [NO_PID]: ecpg_execute on line 145: using PQexec
176 [NO_PID]: sqlca: code: 0, state: 00000
177 [NO_PID]: ecpg_process_output on line 145: correctly got 1 tuples with 3 fields
178 [NO_PID]: sqlca: code: 0, state: 00000
179 [NO_PID]: ecpg_get_data on line 145: RESULT: 1 offset: -1; array: no
180 [NO_PID]: sqlca: code: 0, state: 00000
181 [NO_PID]: ecpg_get_data on line 145: RESULT: 10 offset: -1; array: no
182 [NO_PID]: sqlca: code: 0, state: 00000
183 [NO_PID]: ecpg_get_data on line 145: RESULT: db on con2 offset: -1; array: no
184 [NO_PID]: sqlca: code: 0, state: 00000
185 [NO_PID]: ecpg_execute on line 145: query: fetch cur_4; with 0 parameter(s) on connection con2
186 [NO_PID]: sqlca: code: 0, state: 00000
187 [NO_PID]: ecpg_execute on line 145: using PQexec
188 [NO_PID]: sqlca: code: 0, state: 00000
189 [NO_PID]: ecpg_process_output on line 145: correctly got 1 tuples with 3 fields
190 [NO_PID]: sqlca: code: 0, state: 00000
191 [NO_PID]: ecpg_get_data on line 145: RESULT: 2 offset: -1; array: no
192 [NO_PID]: sqlca: code: 0, state: 00000
193 [NO_PID]: ecpg_get_data on line 145: RESULT: 20 offset: -1; array: no
194 [NO_PID]: sqlca: code: 0, state: 00000
195 [NO_PID]: ecpg_get_data on line 145: RESULT: db on con2 offset: -1; array: no
196 [NO_PID]: sqlca: code: 0, state: 00000
197 [NO_PID]: ecpg_execute on line 145: query: fetch cur_4; with 0 parameter(s) on connection con2
198 [NO_PID]: sqlca: code: 0, state: 00000
199 [NO_PID]: ecpg_execute on line 145: using PQexec
200 [NO_PID]: sqlca: code: 0, state: 00000
201 [NO_PID]: ecpg_process_output on line 145: correctly got 0 tuples with 3 fields
202 [NO_PID]: sqlca: code: 0, state: 00000
203 [NO_PID]: raising sqlcode 100 on line 145: no data found on line 145
204 [NO_PID]: sqlca: code: 100, state: 02000
205 [NO_PID]: ecpg_execute on line 148: query: close cur_4; with 0 parameter(s) on connection con2
206 [NO_PID]: sqlca: code: 0, state: 00000
207 [NO_PID]: ecpg_execute on line 148: using PQexec
208 [NO_PID]: sqlca: code: 0, state: 00000
209 [NO_PID]: ecpg_process_output on line 148: OK: CLOSE CURSOR
210 [NO_PID]: sqlca: code: 0, state: 00000
211 [NO_PID]: deallocate_one on line 149: name stmt_4
212 [NO_PID]: sqlca: code: 0, state: 00000
213 [NO_PID]: prepare_common on line 158: name stmt_desc; query: "SELECT f1,f2,f3 FROM source"
214 [NO_PID]: sqlca: code: 0, state: 00000
215 [NO_PID]: ecpg_execute on line 160: query: declare cur_desc cursor for SELECT f1,f2,f3 FROM source; with 0 parameter(s) on connection con1
216 [NO_PID]: sqlca: code: 0, state: 00000
217 [NO_PID]: ecpg_execute on line 160: using PQexec
218 [NO_PID]: sqlca: code: 0, state: 00000
219 [NO_PID]: ecpg_process_output on line 160: OK: DECLARE CURSOR
220 [NO_PID]: sqlca: code: 0, state: 00000
221 [NO_PID]: ECPGget_desc_header: found 3 attributes
222 [NO_PID]: sqlca: code: 0, state: 00000
223 [NO_PID]: ECPGget_desc: reading items for tuple 3
224 [NO_PID]: sqlca: code: 0, state: 00000
225 [NO_PID]: ECPGget_desc: LENGTH = 20
226 [NO_PID]: sqlca: code: 0, state: 00000
227 [NO_PID]: ecpg_execute on line 173: query: fetch cur_desc; with 0 parameter(s) on connection con1
228 [NO_PID]: sqlca: code: 0, state: 00000
229 [NO_PID]: ecpg_execute on line 173: using PQexec
230 [NO_PID]: sqlca: code: 0, state: 00000
231 [NO_PID]: ecpg_process_output on line 173: correctly got 1 tuples with 3 fields
232 [NO_PID]: sqlca: code: 0, state: 00000
233 [NO_PID]: ecpg_process_output on line 173: putting result (1 tuples) into descriptor desc_for_fetch
234 [NO_PID]: sqlca: code: 0, state: 00000
235 [NO_PID]: ECPGget_desc: reading items for tuple 3
236 [NO_PID]: sqlca: code: 0, state: 00000
237 [NO_PID]: ecpg_get_data on line 175: RESULT: db on con1 offset: -1; array: no
238 [NO_PID]: sqlca: code: 0, state: 00000
239 [NO_PID]: ecpg_execute on line 178: query: close cur_desc; with 0 parameter(s) on connection con1
240 [NO_PID]: sqlca: code: 0, state: 00000
241 [NO_PID]: ecpg_execute on line 178: using PQexec
242 [NO_PID]: sqlca: code: 0, state: 00000
243 [NO_PID]: ecpg_process_output on line 178: OK: CLOSE CURSOR
244 [NO_PID]: sqlca: code: 0, state: 00000
245 [NO_PID]: deallocate_one on line 179: name stmt_desc
246 [NO_PID]: sqlca: code: 0, state: 00000
247 [NO_PID]: ecpg_execute on line 45: query: drop table if exists source; with 0 parameter(s) on connection con1
248 [NO_PID]: sqlca: code: 0, state: 00000
249 [NO_PID]: ecpg_execute on line 45: using PQexec
250 [NO_PID]: sqlca: code: 0, state: 00000
251 [NO_PID]: ecpg_process_output on line 45: OK: DROP TABLE
252 [NO_PID]: sqlca: code: 0, state: 00000
253 [NO_PID]: ecpg_execute on line 46: query: drop table if exists source; with 0 parameter(s) on connection con2
254 [NO_PID]: sqlca: code: 0, state: 00000
255 [NO_PID]: ecpg_execute on line 46: using PQexec
256 [NO_PID]: sqlca: code: 0, state: 00000
257 [NO_PID]: ecpg_process_output on line 46: OK: DROP TABLE
258 [NO_PID]: sqlca: code: 0, state: 00000
259 [NO_PID]: ECPGtrans on line 187: action "commit"; connection "con1"
260 [NO_PID]: sqlca: code: 0, state: 00000
261 [NO_PID]: ECPGtrans on line 188: action "commit"; connection "con2"
262 [NO_PID]: sqlca: code: 0, state: 00000
263 [NO_PID]: ecpg_finish: connection con2 closed
264 [NO_PID]: sqlca: code: 0, state: 00000
265 [NO_PID]: ecpg_finish: connection con1 closed
266 [NO_PID]: sqlca: code: 0, state: 00000