Debian Codegraph @

src/interfaces/ecpg/test/expected/sql-sqlda.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]: ecpg_execute on line 80: query: set datestyle to iso; with 0 parameter(s) on connection regress1
6 [NO_PID]: sqlca: code: 0, state: 00000
7 [NO_PID]: ecpg_execute on line 80: using PQexec
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_process_output on line 80: OK: SET
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: ecpg_execute on line 83: query: create table t1 ( id integer , t text , d1 numeric , d2 float8 , c char ( 10 ) , big bigint ); with 0 parameter(s) on connection regress1
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: ecpg_execute on line 83: using PQexec
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: ecpg_process_output on line 83: OK: CREATE TABLE
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: ecpg_execute on line 93: query: insert into t1 values ( 1 , 'a' , 1.0 , 1 , 'a' , 1111111111111111111 ) , ( 2 , null , null , null , null , null ) , ( 3 , 'c' , 0.0 , 3 , 'c' , 3333333333333333333 ) , ( 4 , 'd' , 'NaN' , 4 , 'd' , 4444444444444444444 ) , ( 5 , 'e' , 0.001234 , 5 , 'e' , 5555555555555555555 ); with 0 parameter(s) on connection regress1
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ecpg_execute on line 93: using PQexec
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_process_output on line 93: OK: INSERT 0 5
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ECPGtrans on line 101: action "commit"; connection "regress1"
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: prepare_common on line 108: name st_id1; query: "SELECT * FROM t1"
26 [NO_PID]: sqlca: code: 0, state: 00000
27 [NO_PID]: ecpg_execute on line 114: query: declare mycur1 cursor for SELECT * FROM t1; with 0 parameter(s) on connection regress1
28 [NO_PID]: sqlca: code: 0, state: 00000
29 [NO_PID]: ecpg_execute on line 114: using PQexec
30 [NO_PID]: sqlca: code: 0, state: 00000
31 [NO_PID]: ecpg_process_output on line 114: OK: DECLARE CURSOR
32 [NO_PID]: sqlca: code: 0, state: 00000
33 [NO_PID]: ecpg_execute on line 122: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1
34 [NO_PID]: sqlca: code: 0, state: 00000
35 [NO_PID]: ecpg_execute on line 122: using PQexec
36 [NO_PID]: sqlca: code: 0, state: 00000
37 [NO_PID]: ecpg_process_output on line 122: correctly got 1 tuples with 6 fields
38 [NO_PID]: sqlca: code: 0, state: 00000
39 [NO_PID]: ecpg_build_native_sqlda on line 122 sqld = 6
40 [NO_PID]: sqlca: code: 0, state: 00000
41 [NO_PID]: ecpg_process_output on line 122: new sqlda was built
42 [NO_PID]: sqlca: code: 0, state: 00000
43 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 0 IS NOT NULL
44 [NO_PID]: sqlca: code: 0, state: 00000
45 [NO_PID]: ecpg_get_data on line 122: RESULT: 1 offset: -1; array: no
46 [NO_PID]: sqlca: code: 0, state: 00000
47 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 1 IS NOT NULL
48 [NO_PID]: sqlca: code: 0, state: 00000
49 [NO_PID]: ecpg_get_data on line 122: RESULT: a offset: -1; array: no
50 [NO_PID]: sqlca: code: 0, state: 00000
51 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 2 IS NOT NULL
52 [NO_PID]: sqlca: code: 0, state: 00000
53 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 3 IS NOT NULL
54 [NO_PID]: sqlca: code: 0, state: 00000
55 [NO_PID]: ecpg_get_data on line 122: RESULT: 1 offset: -1; array: no
56 [NO_PID]: sqlca: code: 0, state: 00000
57 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 4 IS NOT NULL
58 [NO_PID]: sqlca: code: 0, state: 00000
59 [NO_PID]: ecpg_get_data on line 122: RESULT: a offset: -1; array: no
60 [NO_PID]: sqlca: code: 0, state: 00000
61 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 5 IS NOT NULL
62 [NO_PID]: sqlca: code: 0, state: 00000
63 [NO_PID]: ecpg_get_data on line 122: RESULT: 1111111111111111111 offset: -1; array: no
64 [NO_PID]: sqlca: code: 0, state: 00000
65 [NO_PID]: ecpg_process_output on line 122: putting result (1 tuple 6 fields) into sqlda descriptor
66 [NO_PID]: sqlca: code: 0, state: 00000
67 [NO_PID]: ecpg_execute on line 122: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1
68 [NO_PID]: sqlca: code: 0, state: 00000
69 [NO_PID]: ecpg_execute on line 122: using PQexec
70 [NO_PID]: sqlca: code: 0, state: 00000
71 [NO_PID]: ecpg_process_output on line 122: correctly got 1 tuples with 6 fields
72 [NO_PID]: sqlca: code: 0, state: 00000
73 [NO_PID]: ecpg_build_native_sqlda on line 122 sqld = 6
74 [NO_PID]: sqlca: code: 0, state: 00000
75 [NO_PID]: ecpg_process_output on line 122: new sqlda was built
76 [NO_PID]: sqlca: code: 0, state: 00000
77 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 0 IS NOT NULL
78 [NO_PID]: sqlca: code: 0, state: 00000
79 [NO_PID]: ecpg_get_data on line 122: RESULT: 2 offset: -1; array: no
80 [NO_PID]: sqlca: code: 0, state: 00000
81 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 1 IS NULL
82 [NO_PID]: sqlca: code: 0, state: 00000
83 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 2 IS NULL
84 [NO_PID]: sqlca: code: 0, state: 00000
85 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 3 IS NULL
86 [NO_PID]: sqlca: code: 0, state: 00000
87 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 4 IS NULL
88 [NO_PID]: sqlca: code: 0, state: 00000
89 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 5 IS NULL
90 [NO_PID]: sqlca: code: 0, state: 00000
91 [NO_PID]: ecpg_process_output on line 122: putting result (1 tuple 6 fields) into sqlda descriptor
92 [NO_PID]: sqlca: code: 0, state: 00000
93 [NO_PID]: ecpg_execute on line 122: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1
94 [NO_PID]: sqlca: code: 0, state: 00000
95 [NO_PID]: ecpg_execute on line 122: using PQexec
96 [NO_PID]: sqlca: code: 0, state: 00000
97 [NO_PID]: ecpg_process_output on line 122: correctly got 1 tuples with 6 fields
98 [NO_PID]: sqlca: code: 0, state: 00000
99 [NO_PID]: ecpg_build_native_sqlda on line 122 sqld = 6
100 [NO_PID]: sqlca: code: 0, state: 00000
101 [NO_PID]: ecpg_process_output on line 122: new sqlda was built
102 [NO_PID]: sqlca: code: 0, state: 00000
103 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 0 IS NOT NULL
104 [NO_PID]: sqlca: code: 0, state: 00000
105 [NO_PID]: ecpg_get_data on line 122: RESULT: 3 offset: -1; array: no
106 [NO_PID]: sqlca: code: 0, state: 00000
107 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 1 IS NOT NULL
108 [NO_PID]: sqlca: code: 0, state: 00000
109 [NO_PID]: ecpg_get_data on line 122: RESULT: c offset: -1; array: no
110 [NO_PID]: sqlca: code: 0, state: 00000
111 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 2 IS NOT NULL
112 [NO_PID]: sqlca: code: 0, state: 00000
113 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 3 IS NOT NULL
114 [NO_PID]: sqlca: code: 0, state: 00000
115 [NO_PID]: ecpg_get_data on line 122: RESULT: 3 offset: -1; array: no
116 [NO_PID]: sqlca: code: 0, state: 00000
117 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 4 IS NOT NULL
118 [NO_PID]: sqlca: code: 0, state: 00000
119 [NO_PID]: ecpg_get_data on line 122: RESULT: c offset: -1; array: no
120 [NO_PID]: sqlca: code: 0, state: 00000
121 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 5 IS NOT NULL
122 [NO_PID]: sqlca: code: 0, state: 00000
123 [NO_PID]: ecpg_get_data on line 122: RESULT: 3333333333333333333 offset: -1; array: no
124 [NO_PID]: sqlca: code: 0, state: 00000
125 [NO_PID]: ecpg_process_output on line 122: putting result (1 tuple 6 fields) into sqlda descriptor
126 [NO_PID]: sqlca: code: 0, state: 00000
127 [NO_PID]: ecpg_execute on line 122: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1
128 [NO_PID]: sqlca: code: 0, state: 00000
129 [NO_PID]: ecpg_execute on line 122: using PQexec
130 [NO_PID]: sqlca: code: 0, state: 00000
131 [NO_PID]: ecpg_process_output on line 122: correctly got 1 tuples with 6 fields
132 [NO_PID]: sqlca: code: 0, state: 00000
133 [NO_PID]: ecpg_build_native_sqlda on line 122 sqld = 6
134 [NO_PID]: sqlca: code: 0, state: 00000
135 [NO_PID]: ecpg_process_output on line 122: new sqlda was built
136 [NO_PID]: sqlca: code: 0, state: 00000
137 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 0 IS NOT NULL
138 [NO_PID]: sqlca: code: 0, state: 00000
139 [NO_PID]: ecpg_get_data on line 122: RESULT: 4 offset: -1; array: no
140 [NO_PID]: sqlca: code: 0, state: 00000
141 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 1 IS NOT NULL
142 [NO_PID]: sqlca: code: 0, state: 00000
143 [NO_PID]: ecpg_get_data on line 122: RESULT: d offset: -1; array: no
144 [NO_PID]: sqlca: code: 0, state: 00000
145 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 2 IS NOT NULL
146 [NO_PID]: sqlca: code: 0, state: 00000
147 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 3 IS NOT NULL
148 [NO_PID]: sqlca: code: 0, state: 00000
149 [NO_PID]: ecpg_get_data on line 122: RESULT: 4 offset: -1; array: no
150 [NO_PID]: sqlca: code: 0, state: 00000
151 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 4 IS NOT NULL
152 [NO_PID]: sqlca: code: 0, state: 00000
153 [NO_PID]: ecpg_get_data on line 122: RESULT: d offset: -1; array: no
154 [NO_PID]: sqlca: code: 0, state: 00000
155 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 5 IS NOT NULL
156 [NO_PID]: sqlca: code: 0, state: 00000
157 [NO_PID]: ecpg_get_data on line 122: RESULT: 4444444444444444444 offset: -1; array: no
158 [NO_PID]: sqlca: code: 0, state: 00000
159 [NO_PID]: ecpg_process_output on line 122: putting result (1 tuple 6 fields) into sqlda descriptor
160 [NO_PID]: sqlca: code: 0, state: 00000
161 [NO_PID]: ecpg_execute on line 122: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1
162 [NO_PID]: sqlca: code: 0, state: 00000
163 [NO_PID]: ecpg_execute on line 122: using PQexec
164 [NO_PID]: sqlca: code: 0, state: 00000
165 [NO_PID]: ecpg_process_output on line 122: correctly got 1 tuples with 6 fields
166 [NO_PID]: sqlca: code: 0, state: 00000
167 [NO_PID]: ecpg_build_native_sqlda on line 122 sqld = 6
168 [NO_PID]: sqlca: code: 0, state: 00000
169 [NO_PID]: ecpg_process_output on line 122: new sqlda was built
170 [NO_PID]: sqlca: code: 0, state: 00000
171 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 0 IS NOT NULL
172 [NO_PID]: sqlca: code: 0, state: 00000
173 [NO_PID]: ecpg_get_data on line 122: RESULT: 5 offset: -1; array: no
174 [NO_PID]: sqlca: code: 0, state: 00000
175 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 1 IS NOT NULL
176 [NO_PID]: sqlca: code: 0, state: 00000
177 [NO_PID]: ecpg_get_data on line 122: RESULT: e offset: -1; array: no
178 [NO_PID]: sqlca: code: 0, state: 00000
179 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 2 IS NOT NULL
180 [NO_PID]: sqlca: code: 0, state: 00000
181 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 3 IS NOT NULL
182 [NO_PID]: sqlca: code: 0, state: 00000
183 [NO_PID]: ecpg_get_data on line 122: RESULT: 5 offset: -1; array: no
184 [NO_PID]: sqlca: code: 0, state: 00000
185 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 4 IS NOT NULL
186 [NO_PID]: sqlca: code: 0, state: 00000
187 [NO_PID]: ecpg_get_data on line 122: RESULT: e offset: -1; array: no
188 [NO_PID]: sqlca: code: 0, state: 00000
189 [NO_PID]: ecpg_set_native_sqlda on line 122 row 0 col 5 IS NOT NULL
190 [NO_PID]: sqlca: code: 0, state: 00000
191 [NO_PID]: ecpg_get_data on line 122: RESULT: 5555555555555555555 offset: -1; array: no
192 [NO_PID]: sqlca: code: 0, state: 00000
193 [NO_PID]: ecpg_process_output on line 122: putting result (1 tuple 6 fields) into sqlda descriptor
194 [NO_PID]: sqlca: code: 0, state: 00000
195 [NO_PID]: ecpg_execute on line 122: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1
196 [NO_PID]: sqlca: code: 0, state: 00000
197 [NO_PID]: ecpg_execute on line 122: using PQexec
198 [NO_PID]: sqlca: code: 0, state: 00000
199 [NO_PID]: ecpg_process_output on line 122: correctly got 0 tuples with 6 fields
200 [NO_PID]: sqlca: code: 0, state: 00000
201 [NO_PID]: raising sqlcode 100 on line 122: no data found on line 122
202 [NO_PID]: sqlca: code: 100, state: 02000
203 [NO_PID]: ecpg_execute on line 131: query: close mycur1; with 0 parameter(s) on connection regress1
204 [NO_PID]: sqlca: code: 0, state: 00000
205 [NO_PID]: ecpg_execute on line 131: using PQexec
206 [NO_PID]: sqlca: code: 0, state: 00000
207 [NO_PID]: ecpg_process_output on line 131: OK: CLOSE CURSOR
208 [NO_PID]: sqlca: code: 0, state: 00000
209 [NO_PID]: deallocate_one on line 134: name st_id1
210 [NO_PID]: sqlca: code: 0, state: 00000
211 [NO_PID]: prepare_common on line 143: name st_id2; query: "SELECT * FROM t1"
212 [NO_PID]: sqlca: code: 0, state: 00000
213 [NO_PID]: ecpg_execute on line 149: query: declare mycur2 cursor for SELECT * FROM t1; with 0 parameter(s) on connection regress1
214 [NO_PID]: sqlca: code: 0, state: 00000
215 [NO_PID]: ecpg_execute on line 149: using PQexec
216 [NO_PID]: sqlca: code: 0, state: 00000
217 [NO_PID]: ecpg_process_output on line 149: OK: DECLARE CURSOR
218 [NO_PID]: sqlca: code: 0, state: 00000
219 [NO_PID]: ecpg_execute on line 152: query: fetch all from mycur2; with 0 parameter(s) on connection regress1
220 [NO_PID]: sqlca: code: 0, state: 00000
221 [NO_PID]: ecpg_execute on line 152: using PQexec
222 [NO_PID]: sqlca: code: 0, state: 00000
223 [NO_PID]: ecpg_process_output on line 152: correctly got 5 tuples with 6 fields
224 [NO_PID]: sqlca: code: 0, state: 00000
225 [NO_PID]: ecpg_build_native_sqlda on line 152 sqld = 6
226 [NO_PID]: sqlca: code: 0, state: 00000
227 [NO_PID]: ecpg_process_output on line 152: new sqlda was built
228 [NO_PID]: sqlca: code: 0, state: 00000
229 [NO_PID]: ecpg_set_native_sqlda on line 152 row 4 col 0 IS NOT NULL
230 [NO_PID]: sqlca: code: 0, state: 00000
231 [NO_PID]: ecpg_get_data on line 152: RESULT: 5 offset: -1; array: no
232 [NO_PID]: sqlca: code: 0, state: 00000
233 [NO_PID]: ecpg_set_native_sqlda on line 152 row 4 col 1 IS NOT NULL
234 [NO_PID]: sqlca: code: 0, state: 00000
235 [NO_PID]: ecpg_get_data on line 152: RESULT: e offset: -1; array: no
236 [NO_PID]: sqlca: code: 0, state: 00000
237 [NO_PID]: ecpg_set_native_sqlda on line 152 row 4 col 2 IS NOT NULL
238 [NO_PID]: sqlca: code: 0, state: 00000
239 [NO_PID]: ecpg_set_native_sqlda on line 152 row 4 col 3 IS NOT NULL
240 [NO_PID]: sqlca: code: 0, state: 00000
241 [NO_PID]: ecpg_get_data on line 152: RESULT: 5 offset: -1; array: no
242 [NO_PID]: sqlca: code: 0, state: 00000
243 [NO_PID]: ecpg_set_native_sqlda on line 152 row 4 col 4 IS NOT NULL
244 [NO_PID]: sqlca: code: 0, state: 00000
245 [NO_PID]: ecpg_get_data on line 152: RESULT: e offset: -1; array: no
246 [NO_PID]: sqlca: code: 0, state: 00000
247 [NO_PID]: ecpg_set_native_sqlda on line 152 row 4 col 5 IS NOT NULL
248 [NO_PID]: sqlca: code: 0, state: 00000
249 [NO_PID]: ecpg_get_data on line 152: RESULT: 5555555555555555555 offset: -1; array: no
250 [NO_PID]: sqlca: code: 0, state: 00000
251 [NO_PID]: ecpg_process_output on line 152: putting result (1 tuple 6 fields) into sqlda descriptor
252 [NO_PID]: sqlca: code: 0, state: 00000
253 [NO_PID]: ecpg_build_native_sqlda on line 152 sqld = 6
254 [NO_PID]: sqlca: code: 0, state: 00000
255 [NO_PID]: ecpg_process_output on line 152: new sqlda was built
256 [NO_PID]: sqlca: code: 0, state: 00000
257 [NO_PID]: ecpg_set_native_sqlda on line 152 row 3 col 0 IS NOT NULL
258 [NO_PID]: sqlca: code: 0, state: 00000
259 [NO_PID]: ecpg_get_data on line 152: RESULT: 4 offset: -1; array: no
260 [NO_PID]: sqlca: code: 0, state: 00000
261 [NO_PID]: ecpg_set_native_sqlda on line 152 row 3 col 1 IS NOT NULL
262 [NO_PID]: sqlca: code: 0, state: 00000
263 [NO_PID]: ecpg_get_data on line 152: RESULT: d offset: -1; array: no
264 [NO_PID]: sqlca: code: 0, state: 00000
265 [NO_PID]: ecpg_set_native_sqlda on line 152 row 3 col 2 IS NOT NULL
266 [NO_PID]: sqlca: code: 0, state: 00000
267 [NO_PID]: ecpg_set_native_sqlda on line 152 row 3 col 3 IS NOT NULL
268 [NO_PID]: sqlca: code: 0, state: 00000
269 [NO_PID]: ecpg_get_data on line 152: RESULT: 4 offset: -1; array: no
270 [NO_PID]: sqlca: code: 0, state: 00000
271 [NO_PID]: ecpg_set_native_sqlda on line 152 row 3 col 4 IS NOT NULL
272 [NO_PID]: sqlca: code: 0, state: 00000
273 [NO_PID]: ecpg_get_data on line 152: RESULT: d offset: -1; array: no
274 [NO_PID]: sqlca: code: 0, state: 00000
275 [NO_PID]: ecpg_set_native_sqlda on line 152 row 3 col 5 IS NOT NULL
276 [NO_PID]: sqlca: code: 0, state: 00000
277 [NO_PID]: ecpg_get_data on line 152: RESULT: 4444444444444444444 offset: -1; array: no
278 [NO_PID]: sqlca: code: 0, state: 00000
279 [NO_PID]: ecpg_process_output on line 152: putting result (1 tuple 6 fields) into sqlda descriptor
280 [NO_PID]: sqlca: code: 0, state: 00000
281 [NO_PID]: ecpg_build_native_sqlda on line 152 sqld = 6
282 [NO_PID]: sqlca: code: 0, state: 00000
283 [NO_PID]: ecpg_process_output on line 152: new sqlda was built
284 [NO_PID]: sqlca: code: 0, state: 00000
285 [NO_PID]: ecpg_set_native_sqlda on line 152 row 2 col 0 IS NOT NULL
286 [NO_PID]: sqlca: code: 0, state: 00000
287 [NO_PID]: ecpg_get_data on line 152: RESULT: 3 offset: -1; array: no
288 [NO_PID]: sqlca: code: 0, state: 00000
289 [NO_PID]: ecpg_set_native_sqlda on line 152 row 2 col 1 IS NOT NULL
290 [NO_PID]: sqlca: code: 0, state: 00000
291 [NO_PID]: ecpg_get_data on line 152: RESULT: c offset: -1; array: no
292 [NO_PID]: sqlca: code: 0, state: 00000
293 [NO_PID]: ecpg_set_native_sqlda on line 152 row 2 col 2 IS NOT NULL
294 [NO_PID]: sqlca: code: 0, state: 00000
295 [NO_PID]: ecpg_set_native_sqlda on line 152 row 2 col 3 IS NOT NULL
296 [NO_PID]: sqlca: code: 0, state: 00000
297 [NO_PID]: ecpg_get_data on line 152: RESULT: 3 offset: -1; array: no
298 [NO_PID]: sqlca: code: 0, state: 00000
299 [NO_PID]: ecpg_set_native_sqlda on line 152 row 2 col 4 IS NOT NULL
300 [NO_PID]: sqlca: code: 0, state: 00000
301 [NO_PID]: ecpg_get_data on line 152: RESULT: c offset: -1; array: no
302 [NO_PID]: sqlca: code: 0, state: 00000
303 [NO_PID]: ecpg_set_native_sqlda on line 152 row 2 col 5 IS NOT NULL
304 [NO_PID]: sqlca: code: 0, state: 00000
305 [NO_PID]: ecpg_get_data on line 152: RESULT: 3333333333333333333 offset: -1; array: no
306 [NO_PID]: sqlca: code: 0, state: 00000
307 [NO_PID]: ecpg_process_output on line 152: putting result (1 tuple 6 fields) into sqlda descriptor
308 [NO_PID]: sqlca: code: 0, state: 00000
309 [NO_PID]: ecpg_build_native_sqlda on line 152 sqld = 6
310 [NO_PID]: sqlca: code: 0, state: 00000
311 [NO_PID]: ecpg_process_output on line 152: new sqlda was built
312 [NO_PID]: sqlca: code: 0, state: 00000
313 [NO_PID]: ecpg_set_native_sqlda on line 152 row 1 col 0 IS NOT NULL
314 [NO_PID]: sqlca: code: 0, state: 00000
315 [NO_PID]: ecpg_get_data on line 152: RESULT: 2 offset: -1; array: no
316 [NO_PID]: sqlca: code: 0, state: 00000
317 [NO_PID]: ecpg_set_native_sqlda on line 152 row 1 col 1 IS NULL
318 [NO_PID]: sqlca: code: 0, state: 00000
319 [NO_PID]: ecpg_set_native_sqlda on line 152 row 1 col 2 IS NULL
320 [NO_PID]: sqlca: code: 0, state: 00000
321 [NO_PID]: ecpg_set_native_sqlda on line 152 row 1 col 3 IS NULL
322 [NO_PID]: sqlca: code: 0, state: 00000
323 [NO_PID]: ecpg_set_native_sqlda on line 152 row 1 col 4 IS NULL
324 [NO_PID]: sqlca: code: 0, state: 00000
325 [NO_PID]: ecpg_set_native_sqlda on line 152 row 1 col 5 IS NULL
326 [NO_PID]: sqlca: code: 0, state: 00000
327 [NO_PID]: ecpg_process_output on line 152: putting result (1 tuple 6 fields) into sqlda descriptor
328 [NO_PID]: sqlca: code: 0, state: 00000
329 [NO_PID]: ecpg_build_native_sqlda on line 152 sqld = 6
330 [NO_PID]: sqlca: code: 0, state: 00000
331 [NO_PID]: ecpg_process_output on line 152: new sqlda was built
332 [NO_PID]: sqlca: code: 0, state: 00000
333 [NO_PID]: ecpg_set_native_sqlda on line 152 row 0 col 0 IS NOT NULL
334 [NO_PID]: sqlca: code: 0, state: 00000
335 [NO_PID]: ecpg_get_data on line 152: RESULT: 1 offset: -1; array: no
336 [NO_PID]: sqlca: code: 0, state: 00000
337 [NO_PID]: ecpg_set_native_sqlda on line 152 row 0 col 1 IS NOT NULL
338 [NO_PID]: sqlca: code: 0, state: 00000
339 [NO_PID]: ecpg_get_data on line 152: RESULT: a offset: -1; array: no
340 [NO_PID]: sqlca: code: 0, state: 00000
341 [NO_PID]: ecpg_set_native_sqlda on line 152 row 0 col 2 IS NOT NULL
342 [NO_PID]: sqlca: code: 0, state: 00000
343 [NO_PID]: ecpg_set_native_sqlda on line 152 row 0 col 3 IS NOT NULL
344 [NO_PID]: sqlca: code: 0, state: 00000
345 [NO_PID]: ecpg_get_data on line 152: RESULT: 1 offset: -1; array: no
346 [NO_PID]: sqlca: code: 0, state: 00000
347 [NO_PID]: ecpg_set_native_sqlda on line 152 row 0 col 4 IS NOT NULL
348 [NO_PID]: sqlca: code: 0, state: 00000
349 [NO_PID]: ecpg_get_data on line 152: RESULT: a offset: -1; array: no
350 [NO_PID]: sqlca: code: 0, state: 00000
351 [NO_PID]: ecpg_set_native_sqlda on line 152 row 0 col 5 IS NOT NULL
352 [NO_PID]: sqlca: code: 0, state: 00000
353 [NO_PID]: ecpg_get_data on line 152: RESULT: 1111111111111111111 offset: -1; array: no
354 [NO_PID]: sqlca: code: 0, state: 00000
355 [NO_PID]: ecpg_process_output on line 152: putting result (1 tuple 6 fields) into sqlda descriptor
356 [NO_PID]: sqlca: code: 0, state: 00000
357 [NO_PID]: ecpg_execute on line 168: query: close mycur2; with 0 parameter(s) on connection regress1
358 [NO_PID]: sqlca: code: 0, state: 00000
359 [NO_PID]: ecpg_execute on line 168: using PQexec
360 [NO_PID]: sqlca: code: 0, state: 00000
361 [NO_PID]: ecpg_process_output on line 168: OK: CLOSE CURSOR
362 [NO_PID]: sqlca: code: 0, state: 00000
363 [NO_PID]: deallocate_one on line 171: name st_id2
364 [NO_PID]: sqlca: code: 0, state: 00000
365 [NO_PID]: prepare_common on line 193: name st_id3; query: "SELECT * FROM t1 WHERE id = $1"
366 [NO_PID]: sqlca: code: 0, state: 00000
367 [NO_PID]: ecpg_execute on line 196: query: SELECT * FROM t1 WHERE id = $1; with 1 parameter(s) on connection regress1
368 [NO_PID]: sqlca: code: 0, state: 00000
369 [NO_PID]: ecpg_execute on line 196: using PQexecPrepared for "SELECT * FROM t1 WHERE id = $1"
370 [NO_PID]: sqlca: code: 0, state: 00000
371 [NO_PID]: ecpg_free_params on line 196: parameter 1 = 4
372 [NO_PID]: sqlca: code: 0, state: 00000
373 [NO_PID]: ecpg_process_output on line 196: correctly got 1 tuples with 6 fields
374 [NO_PID]: sqlca: code: 0, state: 00000
375 [NO_PID]: ecpg_build_native_sqlda on line 196 sqld = 6
376 [NO_PID]: sqlca: code: 0, state: 00000
377 [NO_PID]: ecpg_process_output on line 196: new sqlda was built
378 [NO_PID]: sqlca: code: 0, state: 00000
379 [NO_PID]: ecpg_set_native_sqlda on line 196 row 0 col 0 IS NOT NULL
380 [NO_PID]: sqlca: code: 0, state: 00000
381 [NO_PID]: ecpg_get_data on line 196: RESULT: 4 offset: -1; array: no
382 [NO_PID]: sqlca: code: 0, state: 00000
383 [NO_PID]: ecpg_set_native_sqlda on line 196 row 0 col 1 IS NOT NULL
384 [NO_PID]: sqlca: code: 0, state: 00000
385 [NO_PID]: ecpg_get_data on line 196: RESULT: d offset: -1; array: no
386 [NO_PID]: sqlca: code: 0, state: 00000
387 [NO_PID]: ecpg_set_native_sqlda on line 196 row 0 col 2 IS NOT NULL
388 [NO_PID]: sqlca: code: 0, state: 00000
389 [NO_PID]: ecpg_set_native_sqlda on line 196 row 0 col 3 IS NOT NULL
390 [NO_PID]: sqlca: code: 0, state: 00000
391 [NO_PID]: ecpg_get_data on line 196: RESULT: 4 offset: -1; array: no
392 [NO_PID]: sqlca: code: 0, state: 00000
393 [NO_PID]: ecpg_set_native_sqlda on line 196 row 0 col 4 IS NOT NULL
394 [NO_PID]: sqlca: code: 0, state: 00000
395 [NO_PID]: ecpg_get_data on line 196: RESULT: d offset: -1; array: no
396 [NO_PID]: sqlca: code: 0, state: 00000
397 [NO_PID]: ecpg_set_native_sqlda on line 196 row 0 col 5 IS NOT NULL
398 [NO_PID]: sqlca: code: 0, state: 00000
399 [NO_PID]: ecpg_get_data on line 196: RESULT: 4444444444444444444 offset: -1; array: no
400 [NO_PID]: sqlca: code: 0, state: 00000
401 [NO_PID]: ecpg_process_output on line 196: putting result (1 tuple 6 fields) into sqlda descriptor
402 [NO_PID]: sqlca: code: 0, state: 00000
403 [NO_PID]: deallocate_one on line 201: name st_id3
404 [NO_PID]: sqlca: code: 0, state: 00000
405 [NO_PID]: ECPGconnect: opening database ecpg1_regression on <DEFAULT> port <DEFAULT>
406 [NO_PID]: sqlca: code: 0, state: 00000
407 [NO_PID]: prepare_common on line 230: name st_id4; query: "SELECT * FROM t1 WHERE id = $1"
408 [NO_PID]: sqlca: code: 0, state: 00000
409 [NO_PID]: ecpg_execute on line 233: query: SELECT * FROM t1 WHERE id = $1; with 1 parameter(s) on connection con2
410 [NO_PID]: sqlca: code: 0, state: 00000
411 [NO_PID]: ecpg_execute on line 233: using PQexecPrepared for "SELECT * FROM t1 WHERE id = $1"
412 [NO_PID]: sqlca: code: 0, state: 00000
413 [NO_PID]: ecpg_free_params on line 233: parameter 1 = 4
414 [NO_PID]: sqlca: code: 0, state: 00000
415 [NO_PID]: ecpg_process_output on line 233: correctly got 1 tuples with 6 fields
416 [NO_PID]: sqlca: code: 0, state: 00000
417 [NO_PID]: ecpg_build_native_sqlda on line 233 sqld = 6
418 [NO_PID]: sqlca: code: 0, state: 00000
419 [NO_PID]: ecpg_process_output on line 233: new sqlda was built
420 [NO_PID]: sqlca: code: 0, state: 00000
421 [NO_PID]: ecpg_set_native_sqlda on line 233 row 0 col 0 IS NOT NULL
422 [NO_PID]: sqlca: code: 0, state: 00000
423 [NO_PID]: ecpg_get_data on line 233: RESULT: 4 offset: -1; array: no
424 [NO_PID]: sqlca: code: 0, state: 00000
425 [NO_PID]: ecpg_set_native_sqlda on line 233 row 0 col 1 IS NOT NULL
426 [NO_PID]: sqlca: code: 0, state: 00000
427 [NO_PID]: ecpg_get_data on line 233: RESULT: d offset: -1; array: no
428 [NO_PID]: sqlca: code: 0, state: 00000
429 [NO_PID]: ecpg_set_native_sqlda on line 233 row 0 col 2 IS NOT NULL
430 [NO_PID]: sqlca: code: 0, state: 00000
431 [NO_PID]: ecpg_set_native_sqlda on line 233 row 0 col 3 IS NOT NULL
432 [NO_PID]: sqlca: code: 0, state: 00000
433 [NO_PID]: ecpg_get_data on line 233: RESULT: 4 offset: -1; array: no
434 [NO_PID]: sqlca: code: 0, state: 00000
435 [NO_PID]: ecpg_set_native_sqlda on line 233 row 0 col 4 IS NOT NULL
436 [NO_PID]: sqlca: code: 0, state: 00000
437 [NO_PID]: ecpg_get_data on line 233: RESULT: d offset: -1; array: no
438 [NO_PID]: sqlca: code: 0, state: 00000
439 [NO_PID]: ecpg_set_native_sqlda on line 233 row 0 col 5 IS NOT NULL
440 [NO_PID]: sqlca: code: 0, state: 00000
441 [NO_PID]: ecpg_get_data on line 233: RESULT: 4444444444444444444 offset: -1; array: no
442 [NO_PID]: sqlca: code: 0, state: 00000
443 [NO_PID]: ecpg_process_output on line 233: putting result (1 tuple 6 fields) into sqlda descriptor
444 [NO_PID]: sqlca: code: 0, state: 00000
445 [NO_PID]: ECPGtrans on line 238: action "commit"; connection "con2"
446 [NO_PID]: sqlca: code: 0, state: 00000
447 [NO_PID]: deallocate_one on line 241: name st_id4
448 [NO_PID]: sqlca: code: 0, state: 00000
449 [NO_PID]: ecpg_finish: connection con2 closed
450 [NO_PID]: sqlca: code: 0, state: 00000
451 [NO_PID]: ecpg_execute on line 252: query: drop table t1; with 0 parameter(s) on connection regress1
452 [NO_PID]: sqlca: code: 0, state: 00000
453 [NO_PID]: ecpg_execute on line 252: using PQexec
454 [NO_PID]: sqlca: code: 0, state: 00000
455 [NO_PID]: ecpg_process_output on line 252: OK: DROP TABLE
456 [NO_PID]: sqlca: code: 0, state: 00000
457 [NO_PID]: ECPGtrans on line 255: action "commit"; connection "regress1"
458 [NO_PID]: sqlca: code: 0, state: 00000
459 [NO_PID]: ecpg_finish: connection regress1 closed
460 [NO_PID]: sqlca: code: 0, state: 00000