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