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]: ECPGsetcommit on line 55: action "on"; connection "ecpg1_regression"
6[NO_PID]: sqlca: code: 0, state: 00000
7[NO_PID]: ECPGtrans on line 57: action "begin work"; connection "ecpg1_regression"
8[NO_PID]: sqlca: code: 0, state: 00000
9[NO_PID]: ecpg_execute on line 59: query: create table test ( f float , i int , a int [ 10 ] , text char ( 10 ) , ts timestamp [ 10 ] , n numeric [ 10 ] , d date [ 10 ] , inter interval [ 10 ] ); with 0 parameter(s) on connection ecpg1_regression
10[NO_PID]: sqlca: code: 0, state: 00000
11[NO_PID]: ecpg_execute on line 59: using PQexec
12[NO_PID]: sqlca: code: 0, state: 00000
13[NO_PID]: ecpg_process_output on line 59: OK: CREATE TABLE
14[NO_PID]: sqlca: code: 0, state: 00000
15[NO_PID]: ecpg_execute on line 61: query: insert into test ( f , i , a , text , ts , n , d , inter ) values ( 404.90 , 3 , '{0,1,2,3,4,5,6,7,8,9}' , 'abcdefghij' , $1  , $2  , $3  , $4  ); with 4 parameter(s) on connection ecpg1_regression
16[NO_PID]: sqlca: code: 0, state: 00000
17[NO_PID]: ecpg_execute on line 61: using PQexecParams
18[NO_PID]: sqlca: code: 0, state: 00000
19[NO_PID]: ecpg_free_params on line 61: parameter 1 = {2000-01-01 00:00:00,2000-01-01 01:00:00,2000-01-01 02:00:00,2000-01-01 03:00:00,2000-01-01 04:00:00,2000-01-01 05:00:00,2000-01-01 06:00:00,2000-01-01 07:00:00,2000-01-01 08:00:00,2000-01-01 09:00:00}
20[NO_PID]: sqlca: code: 0, state: 00000
21[NO_PID]: ecpg_free_params on line 61: parameter 2 = {0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0}
22[NO_PID]: sqlca: code: 0, state: 00000
23[NO_PID]: ecpg_free_params on line 61: parameter 3 = {2000-01-10,2000-01-11,2000-01-12,2000-01-13,2000-01-14,2000-01-15,2000-01-16,2000-01-17,2000-01-18,2000-01-19}
24[NO_PID]: sqlca: code: 0, state: 00000
25[NO_PID]: ecpg_free_params on line 61: parameter 4 = {@ 10 hours,@ 11 hours,@ 12 hours,@ 13 hours,@ 14 hours,@ 15 hours,@ 16 hours,@ 17 hours,@ 18 hours,@ 19 hours}
26[NO_PID]: sqlca: code: 0, state: 00000
27[NO_PID]: ecpg_process_output on line 61: OK: INSERT 0 1
28[NO_PID]: sqlca: code: 0, state: 00000
29[NO_PID]: ecpg_execute on line 63: query: insert into test ( f , i , a , text , ts , n , d , inter ) values ( 140787.0 , 2 , $1  , $2  , $3  , $4  , $5  , $6  ); with 6 parameter(s) on connection ecpg1_regression
30[NO_PID]: sqlca: code: 0, state: 00000
31[NO_PID]: ecpg_execute on line 63: using PQexecParams
32[NO_PID]: sqlca: code: 0, state: 00000
33[NO_PID]: ecpg_free_params on line 63: parameter 1 = {9,8,7,6,5,4,3,2,1,0}
34[NO_PID]: sqlca: code: 0, state: 00000
35[NO_PID]: ecpg_free_params on line 63: parameter 2 = klmnopqrst
36[NO_PID]: sqlca: code: 0, state: 00000
37[NO_PID]: ecpg_free_params on line 63: parameter 3 = {2000-01-01 00:00:00,2000-01-01 01:00:00,2000-01-01 02:00:00,2000-01-01 03:00:00,2000-01-01 04:00:00,2000-01-01 05:00:00,2000-01-01 06:00:00,2000-01-01 07:00:00,2000-01-01 08:00:00,2000-01-01 09:00:00}
38[NO_PID]: sqlca: code: 0, state: 00000
39[NO_PID]: ecpg_free_params on line 63: parameter 4 = {0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0}
40[NO_PID]: sqlca: code: 0, state: 00000
41[NO_PID]: ecpg_free_params on line 63: parameter 5 = {2000-01-10,2000-01-11,2000-01-12,2000-01-13,2000-01-14,2000-01-15,2000-01-16,2000-01-17,2000-01-18,2000-01-19}
42[NO_PID]: sqlca: code: 0, state: 00000
43[NO_PID]: ecpg_free_params on line 63: parameter 6 = {@ 10 hours,@ 11 hours,@ 12 hours,@ 13 hours,@ 14 hours,@ 15 hours,@ 16 hours,@ 17 hours,@ 18 hours,@ 19 hours}
44[NO_PID]: sqlca: code: 0, state: 00000
45[NO_PID]: ecpg_process_output on line 63: OK: INSERT 0 1
46[NO_PID]: sqlca: code: 0, state: 00000
47[NO_PID]: ecpg_execute on line 65: query: insert into test ( f , i , a , text , ts , n , d , inter ) values ( 14.07 , $1  , $2  , $3  , $4  , $5  , $6  , $7  ); with 7 parameter(s) on connection ecpg1_regression
48[NO_PID]: sqlca: code: 0, state: 00000
49[NO_PID]: ecpg_execute on line 65: using PQexecParams
50[NO_PID]: sqlca: code: 0, state: 00000
51[NO_PID]: ecpg_free_params on line 65: parameter 1 = 1
52[NO_PID]: sqlca: code: 0, state: 00000
53[NO_PID]: ecpg_free_params on line 65: parameter 2 = {9,8,7,6,5,4,3,2,1,0}
54[NO_PID]: sqlca: code: 0, state: 00000
55[NO_PID]: ecpg_free_params on line 65: parameter 3 = 0123456789
56[NO_PID]: sqlca: code: 0, state: 00000
57[NO_PID]: ecpg_free_params on line 65: parameter 4 = {2000-01-01 00:00:00,2000-01-01 01:00:00,2000-01-01 02:00:00,2000-01-01 03:00:00,2000-01-01 04:00:00,2000-01-01 05:00:00,2000-01-01 06:00:00,2000-01-01 07:00:00,2000-01-01 08:00:00,2000-01-01 09:00:00}
58[NO_PID]: sqlca: code: 0, state: 00000
59[NO_PID]: ecpg_free_params on line 65: parameter 5 = {0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0}
60[NO_PID]: sqlca: code: 0, state: 00000
61[NO_PID]: ecpg_free_params on line 65: parameter 6 = {2000-01-10,2000-01-11,2000-01-12,2000-01-13,2000-01-14,2000-01-15,2000-01-16,2000-01-17,2000-01-18,2000-01-19}
62[NO_PID]: sqlca: code: 0, state: 00000
63[NO_PID]: ecpg_free_params on line 65: parameter 7 = {@ 10 hours,@ 11 hours,@ 12 hours,@ 13 hours,@ 14 hours,@ 15 hours,@ 16 hours,@ 17 hours,@ 18 hours,@ 19 hours}
64[NO_PID]: sqlca: code: 0, state: 00000
65[NO_PID]: ecpg_process_output on line 65: OK: INSERT 0 1
66[NO_PID]: sqlca: code: 0, state: 00000
67[NO_PID]: ECPGtrans on line 67: action "commit"; connection "ecpg1_regression"
68[NO_PID]: sqlca: code: 0, state: 00000
69[NO_PID]: ECPGtrans on line 75: action "begin work"; connection "ecpg1_regression"
70[NO_PID]: sqlca: code: 0, state: 00000
71[NO_PID]: ecpg_execute on line 77: query: select f , text from test where i = 1; with 0 parameter(s) on connection ecpg1_regression
72[NO_PID]: sqlca: code: 0, state: 00000
73[NO_PID]: ecpg_execute on line 77: using PQexec
74[NO_PID]: sqlca: code: 0, state: 00000
75[NO_PID]: ecpg_process_output on line 77: correctly got 1 tuples with 2 fields
76[NO_PID]: sqlca: code: 0, state: 00000
77[NO_PID]: ecpg_get_data on line 77: RESULT: 14.07 offset: -1; array: no
78[NO_PID]: sqlca: code: 0, state: 00000
79[NO_PID]: ecpg_get_data on line 77: RESULT: 0123456789 offset: -1; array: no
80[NO_PID]: sqlca: code: 0, state: 00000
81[NO_PID]: ecpg_execute on line 85: query: select a , text , ts , n , d , inter from test where f = $1 ; with 1 parameter(s) on connection ecpg1_regression
82[NO_PID]: sqlca: code: 0, state: 00000
83[NO_PID]: ecpg_execute on line 85: using PQexecParams
84[NO_PID]: sqlca: code: 0, state: 00000
85[NO_PID]: ecpg_free_params on line 85: parameter 1 = 140787
86[NO_PID]: sqlca: code: 0, state: 00000
87[NO_PID]: ecpg_process_output on line 85: correctly got 1 tuples with 6 fields
88[NO_PID]: sqlca: code: 0, state: 00000
89[NO_PID]: ecpg_is_type_an_array on line 85: type (1007); C (3); array (yes)
90[NO_PID]: sqlca: code: 0, state: 00000
91[NO_PID]: ecpg_get_data on line 85: RESULT: {9,8,7,6,5,4,3,2,1,0} offset: -1; array: yes
92[NO_PID]: sqlca: code: 0, state: 00000
93[NO_PID]: ecpg_get_data on line 85: RESULT: klmnopqrst offset: -1; array: no
94[NO_PID]: sqlca: code: 0, state: 00000
95[NO_PID]: ecpg_is_type_an_array on line 85: type (1115); C (19); array (yes)
96[NO_PID]: sqlca: code: 0, state: 00000
97[NO_PID]: ecpg_get_data on line 85: RESULT: {"Sat Jan 01 00:00:00 2000","Sat Jan 01 01:00:00 2000","Sat Jan 01 02:00:00 2000","Sat Jan 01 03:00:00 2000","Sat Jan 01 04:00:00 2000","Sat Jan 01 05:00:00 2000","Sat Jan 01 06:00:00 2000","Sat Jan 01 07:00:00 2000","Sat Jan 01 08:00:00 2000","Sat Jan 01 09:00:00 2000"} offset: -1; array: yes
98[NO_PID]: sqlca: code: 0, state: 00000
99[NO_PID]: ecpg_is_type_an_array on line 85: type (1231); C (16); array (yes)
100[NO_PID]: sqlca: code: 0, state: 00000
101[NO_PID]: ecpg_get_data on line 85: RESULT: {0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0} offset: -1; array: yes
102[NO_PID]: sqlca: code: 0, state: 00000
103[NO_PID]: ecpg_is_type_an_array on line 85: type (1182); C (18); array (yes)
104[NO_PID]: sqlca: code: 0, state: 00000
105[NO_PID]: ecpg_get_data on line 85: RESULT: {01-10-2000,01-11-2000,01-12-2000,01-13-2000,01-14-2000,01-15-2000,01-16-2000,01-17-2000,01-18-2000,01-19-2000} offset: -1; array: yes
106[NO_PID]: sqlca: code: 0, state: 00000
107[NO_PID]: ecpg_is_type_an_array on line 85: type (1187); C (20); array (yes)
108[NO_PID]: sqlca: code: 0, state: 00000
109[NO_PID]: ecpg_get_data on line 85: RESULT: {"@ 10 hours","@ 11 hours","@ 12 hours","@ 13 hours","@ 14 hours","@ 15 hours","@ 16 hours","@ 17 hours","@ 18 hours","@ 19 hours"} offset: -1; array: yes
110[NO_PID]: sqlca: code: 0, state: 00000
111[NO_PID]: ecpg_execute on line 95: query: select a from test where f = $1 ; with 1 parameter(s) on connection ecpg1_regression
112[NO_PID]: sqlca: code: 0, state: 00000
113[NO_PID]: ecpg_execute on line 95: using PQexecParams
114[NO_PID]: sqlca: code: 0, state: 00000
115[NO_PID]: ecpg_free_params on line 95: parameter 1 = 140787
116[NO_PID]: sqlca: code: 0, state: 00000
117[NO_PID]: ecpg_process_output on line 95: correctly got 1 tuples with 1 fields
118[NO_PID]: sqlca: code: 0, state: 00000
119[NO_PID]: ecpg_get_data on line 95: RESULT: {9,8,7,6,5,4,3,2,1,0} offset: -1; array: yes
120[NO_PID]: sqlca: code: 0, state: 00000
121[NO_PID]: ecpg_execute on line 102: query: drop table test; with 0 parameter(s) on connection ecpg1_regression
122[NO_PID]: sqlca: code: 0, state: 00000
123[NO_PID]: ecpg_execute on line 102: using PQexec
124[NO_PID]: sqlca: code: 0, state: 00000
125[NO_PID]: ecpg_process_output on line 102: OK: DROP TABLE
126[NO_PID]: sqlca: code: 0, state: 00000
127[NO_PID]: ECPGtrans on line 104: action "commit"; connection "ecpg1_regression"
128[NO_PID]: sqlca: code: 0, state: 00000
129[NO_PID]: ecpg_finish: connection ecpg1_regression closed
130[NO_PID]: sqlca: code: 0, state: 00000
131