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 24: query: create table test ( i int primary key , j int , c text ); with 0 parameter(s) on connection ecpg1_regression
6[NO_PID]: sqlca: code: 0, state: 00000
7[NO_PID]: ecpg_execute on line 24: using PQexec
8[NO_PID]: sqlca: code: 0, state: 00000
9[NO_PID]: ecpg_process_output on line 24: OK: CREATE TABLE
10[NO_PID]: sqlca: code: 0, state: 00000
11[NO_PID]: ecpg_execute on line 28: query: insert into test ( i , j , c ) values ( 7 , $1  , 'test   ' ); with 1 parameter(s) on connection ecpg1_regression
12[NO_PID]: sqlca: code: 0, state: 00000
13[NO_PID]: ecpg_execute on line 28: using PQexecParams
14[NO_PID]: sqlca: code: 0, state: 00000
15[NO_PID]: ecpg_free_params on line 28: parameter 1 = 0
16[NO_PID]: sqlca: code: 0, state: 00000
17[NO_PID]: ecpg_process_output on line 28: OK: INSERT 0 1
18[NO_PID]: sqlca: code: 0, state: 00000
19[NO_PID]: ECPGtrans on line 29: action "commit"; connection "ecpg1_regression"
20[NO_PID]: sqlca: code: 0, state: 00000
21[NO_PID]: ecpg_execute on line 32: query: insert into test ( i , j , c ) values ( 7 , 12 , 'a' ); with 0 parameter(s) on connection ecpg1_regression
22[NO_PID]: sqlca: code: 0, state: 00000
23[NO_PID]: ecpg_execute on line 32: using PQexec
24[NO_PID]: sqlca: code: 0, state: 00000
25[NO_PID]: ecpg_check_PQresult on line 32: bad response - ERROR:  duplicate key value violates unique constraint "test_pkey"
26DETAIL:  Key (i)=(7) already exists.
27[NO_PID]: sqlca: code: 0, state: 00000
28[NO_PID]: raising sqlstate 23505 (sqlcode -239): duplicate key value violates unique constraint "test_pkey" on line 32
29[NO_PID]: sqlca: code: -239, state: 23505
30[NO_PID]: ECPGtrans on line 34: action "rollback"; connection "ecpg1_regression"
31[NO_PID]: sqlca: code: 0, state: 00000
32[NO_PID]: ecpg_execute on line 36: query: insert into test ( i , j , c ) values ( $1  , 1 , 'a      ' ); with 1 parameter(s) on connection ecpg1_regression
33[NO_PID]: sqlca: code: 0, state: 00000
34[NO_PID]: ecpg_execute on line 36: using PQexecParams
35[NO_PID]: sqlca: code: 0, state: 00000
36[NO_PID]: ecpg_free_params on line 36: parameter 1 = 14
37[NO_PID]: sqlca: code: 0, state: 00000
38[NO_PID]: ecpg_process_output on line 36: OK: INSERT 0 1
39[NO_PID]: sqlca: code: 0, state: 00000
40[NO_PID]: ECPGtrans on line 37: action "commit"; connection "ecpg1_regression"
41[NO_PID]: sqlca: code: 0, state: 00000
42[NO_PID]: ecpg_execute on line 40: query: select i from test where j = ( select j from test ); with 0 parameter(s) on connection ecpg1_regression
43[NO_PID]: sqlca: code: 0, state: 00000
44[NO_PID]: ecpg_execute on line 40: using PQexec
45[NO_PID]: sqlca: code: 0, state: 00000
46[NO_PID]: ecpg_check_PQresult on line 40: bad response - ERROR:  more than one row returned by a subquery used as an expression
47[NO_PID]: sqlca: code: 0, state: 00000
48[NO_PID]: raising sqlstate 21000 (sqlcode -284): more than one row returned by a subquery used as an expression on line 40
49[NO_PID]: sqlca: code: -284, state: 21000
50[NO_PID]: ECPGtrans on line 41: action "rollback"; connection "ecpg1_regression"
51[NO_PID]: sqlca: code: 0, state: 00000
52[NO_PID]: ecpg_execute on line 44: query: select i from test where j = ( select j from test order by i limit 1 ); with 0 parameter(s) on connection ecpg1_regression
53[NO_PID]: sqlca: code: 0, state: 00000
54[NO_PID]: ecpg_execute on line 44: using PQexec
55[NO_PID]: sqlca: code: 0, state: 00000
56[NO_PID]: ecpg_process_output on line 44: correctly got 1 tuples with 1 fields
57[NO_PID]: sqlca: code: 0, state: 00000
58[NO_PID]: ecpg_execute on line 94: query: declare c cursor for select * from test where i <= $1 ; with 1 parameter(s) on connection ecpg1_regression
59[NO_PID]: sqlca: code: 0, state: 00000
60[NO_PID]: ecpg_execute on line 94: using PQexecParams
61[NO_PID]: sqlca: code: 0, state: 00000
62[NO_PID]: ecpg_free_params on line 94: parameter 1 = 14
63[NO_PID]: sqlca: code: 0, state: 00000
64[NO_PID]: ecpg_process_output on line 94: OK: DECLARE CURSOR
65[NO_PID]: sqlca: code: 0, state: 00000
66[NO_PID]: ecpg_execute on line 57: query: fetch forward c; with 0 parameter(s) on connection ecpg1_regression
67[NO_PID]: sqlca: code: 0, state: 00000
68[NO_PID]: ecpg_execute on line 57: using PQexec
69[NO_PID]: sqlca: code: 0, state: 00000
70[NO_PID]: ecpg_process_output on line 57: correctly got 1 tuples with 3 fields
71[NO_PID]: sqlca: code: 0, state: 00000
72[NO_PID]: ecpg_get_data on line 57: RESULT: 7 offset: -1; array: no
73[NO_PID]: sqlca: code: 0, state: 00000
74[NO_PID]: ecpg_get_data on line 57: RESULT: 0 offset: -1; array: no
75[NO_PID]: sqlca: code: 0, state: 00000
76[NO_PID]: ecpg_get_data on line 57: RESULT: test    offset: -1; array: no
77[NO_PID]: sqlca: code: 0, state: 00000
78[NO_PID]: ecpg_execute on line 57: query: fetch forward c; with 0 parameter(s) on connection ecpg1_regression
79[NO_PID]: sqlca: code: 0, state: 00000
80[NO_PID]: ecpg_execute on line 57: using PQexec
81[NO_PID]: sqlca: code: 0, state: 00000
82[NO_PID]: ecpg_process_output on line 57: correctly got 1 tuples with 3 fields
83[NO_PID]: sqlca: code: 0, state: 00000
84[NO_PID]: ecpg_get_data on line 57: RESULT: 14 offset: -1; array: no
85[NO_PID]: sqlca: code: 0, state: 00000
86[NO_PID]: ecpg_get_data on line 57: RESULT: 1 offset: -1; array: no
87[NO_PID]: sqlca: code: 0, state: 00000
88[NO_PID]: ecpg_get_data on line 57: RESULT: a       offset: -1; array: no
89[NO_PID]: sqlca: code: 0, state: 00000
90[NO_PID]: ecpg_execute on line 57: query: fetch forward c; with 0 parameter(s) on connection ecpg1_regression
91[NO_PID]: sqlca: code: 0, state: 00000
92[NO_PID]: ecpg_execute on line 57: using PQexec
93[NO_PID]: sqlca: code: 0, state: 00000
94[NO_PID]: ecpg_process_output on line 57: correctly got 0 tuples with 3 fields
95[NO_PID]: sqlca: code: 0, state: 00000
96[NO_PID]: raising sqlcode 100 on line 57: no data found on line 57
97[NO_PID]: sqlca: code: 100, state: 02000
98[NO_PID]: ecpg_execute on line 74: query: delete from test where i = $1  :: decimal; with 1 parameter(s) on connection ecpg1_regression
99[NO_PID]: sqlca: code: 0, state: 00000
100[NO_PID]: ecpg_execute on line 74: using PQexecParams
101[NO_PID]: sqlca: code: 0, state: 00000
102[NO_PID]: ecpg_free_params on line 74: parameter 1 = 21.0
103[NO_PID]: sqlca: code: 0, state: 00000
104[NO_PID]: ecpg_process_output on line 74: OK: DELETE 0
105[NO_PID]: sqlca: code: 0, state: 00000
106[NO_PID]: raising sqlcode 100 on line 74: no data found on line 74
107[NO_PID]: sqlca: code: 100, state: 02000
108[NO_PID]: ecpg_execute on line 77: query: select 1 from test where i = 14; with 0 parameter(s) on connection ecpg1_regression
109[NO_PID]: sqlca: code: 0, state: 00000
110[NO_PID]: ecpg_execute on line 77: using PQexec
111[NO_PID]: sqlca: code: 0, state: 00000
112[NO_PID]: ecpg_process_output on line 77: correctly got 1 tuples with 1 fields
113[NO_PID]: sqlca: code: 0, state: 00000
114[NO_PID]: ecpg_execute on line 80: query: select 1 from test where i = 147; with 0 parameter(s) on connection ecpg1_regression
115[NO_PID]: sqlca: code: 0, state: 00000
116[NO_PID]: ecpg_execute on line 80: using PQexec
117[NO_PID]: sqlca: code: 0, state: 00000
118[NO_PID]: ecpg_process_output on line 80: correctly got 0 tuples with 1 fields
119[NO_PID]: sqlca: code: 0, state: 00000
120[NO_PID]: raising sqlcode 100 on line 80: no data found on line 80
121[NO_PID]: sqlca: code: 100, state: 02000
122[NO_PID]: ECPGtrans on line 83: action "commit"; connection "ecpg1_regression"
123[NO_PID]: sqlca: code: 0, state: 00000
124[NO_PID]: ecpg_execute on line 84: query: drop table test; with 0 parameter(s) on connection ecpg1_regression
125[NO_PID]: sqlca: code: 0, state: 00000
126[NO_PID]: ecpg_execute on line 84: using PQexec
127[NO_PID]: sqlca: code: 0, state: 00000
128[NO_PID]: ecpg_process_output on line 84: OK: DROP TABLE
129[NO_PID]: sqlca: code: 0, state: 00000
130[NO_PID]: ECPGtrans on line 85: action "commit"; connection "ecpg1_regression"
131[NO_PID]: sqlca: code: 0, state: 00000
132[NO_PID]: ecpg_finish: connection ecpg1_regression closed
133[NO_PID]: sqlca: code: 0, state: 00000
134