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