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 30: query: create table test1 ( a int , b text ); with 0 parameter(s) on connection ecpg1_regression 6[NO_PID]: sqlca: code: 0, state: 00000 7[NO_PID]: ecpg_execute on line 30: using PQexec 8[NO_PID]: sqlca: code: 0, state: 00000 9[NO_PID]: ecpg_process_output on line 30: OK: CREATE TABLE 10[NO_PID]: sqlca: code: 0, state: 00000 11[NO_PID]: prepare_common on line 31: name foo1; query: "INSERT INTO test1 VALUES ($1, $2)" 12[NO_PID]: sqlca: code: 0, state: 00000 13[NO_PID]: prepare_common on line 32: name Foo-1; query: "INSERT INTO test1 VALUES ($1, $2)" 14[NO_PID]: sqlca: code: 0, state: 00000 15[NO_PID]: prepare_common on line 33: name foo2; query: "SELECT * from test1 where a = $1 and b = $2" 16[NO_PID]: sqlca: code: 0, state: 00000 17[NO_PID]: prepare_common on line 34: name foo3; query: "SELECT * from test1 where $1 = a" 18[NO_PID]: sqlca: code: 0, state: 00000 19[NO_PID]: ecpg_execute on line 36: query: INSERT INTO test1 VALUES ($1, $2); with 2 parameter(s) on connection ecpg1_regression 20[NO_PID]: sqlca: code: 0, state: 00000 21[NO_PID]: ecpg_execute on line 36: using PQexecPrepared for "INSERT INTO test1 VALUES ($1, $2)" 22[NO_PID]: sqlca: code: 0, state: 00000 23[NO_PID]: ecpg_free_params on line 36: parameter 1 = 1 24[NO_PID]: sqlca: code: 0, state: 00000 25[NO_PID]: ecpg_free_params on line 36: parameter 2 = one 26[NO_PID]: sqlca: code: 0, state: 00000 27[NO_PID]: ecpg_process_output on line 36: OK: INSERT 0 1 28[NO_PID]: sqlca: code: 0, state: 00000 29[NO_PID]: ecpg_execute on line 41: query: INSERT INTO test1 VALUES ($1, $2); with 2 parameter(s) on connection ecpg1_regression 30[NO_PID]: sqlca: code: 0, state: 00000 31[NO_PID]: ecpg_execute on line 41: using PQexecPrepared for "INSERT INTO test1 VALUES ($1, $2)" 32[NO_PID]: sqlca: code: 0, state: 00000 33[NO_PID]: ecpg_free_params on line 41: parameter 1 = 2 34[NO_PID]: sqlca: code: 0, state: 00000 35[NO_PID]: ecpg_free_params on line 41: parameter 2 = null 36[NO_PID]: sqlca: code: 0, state: 00000 37[NO_PID]: ecpg_process_output on line 41: OK: INSERT 0 1 38[NO_PID]: sqlca: code: 0, state: 00000 39[NO_PID]: ecpg_execute on line 46: query: INSERT INTO test1 VALUES ($1, $2); with 2 parameter(s) on connection ecpg1_regression 40[NO_PID]: sqlca: code: 0, state: 00000 41[NO_PID]: ecpg_execute on line 46: using PQexecPrepared for "INSERT INTO test1 VALUES ($1, $2)" 42[NO_PID]: sqlca: code: 0, state: 00000 43[NO_PID]: ecpg_free_params on line 46: parameter 1 = 3 44[NO_PID]: sqlca: code: 0, state: 00000 45[NO_PID]: ecpg_free_params on line 46: parameter 2 = this is a long test 46[NO_PID]: sqlca: code: 0, state: 00000 47[NO_PID]: ecpg_process_output on line 46: OK: INSERT 0 1 48[NO_PID]: sqlca: code: 0, state: 00000 49[NO_PID]: deallocate_one on line 48: name Foo-1 50[NO_PID]: sqlca: code: 0, state: 00000 51[NO_PID]: ecpg_execute on line 53: query: SELECT * from test1 where a = $1 and b = $2; with 2 parameter(s) on connection ecpg1_regression 52[NO_PID]: sqlca: code: 0, state: 00000 53[NO_PID]: ecpg_execute on line 53: using PQexecPrepared for "SELECT * from test1 where a = $1 and b = $2" 54[NO_PID]: sqlca: code: 0, state: 00000 55[NO_PID]: ecpg_free_params on line 53: parameter 1 = 1 56[NO_PID]: sqlca: code: 0, state: 00000 57[NO_PID]: ecpg_free_params on line 53: parameter 2 = one 58[NO_PID]: sqlca: code: 0, state: 00000 59[NO_PID]: ecpg_process_output on line 53: correctly got 1 tuples with 2 fields 60[NO_PID]: sqlca: code: 0, state: 00000 61[NO_PID]: ecpg_process_output on line 53: putting result (1 tuples) into descriptor outdesc 62[NO_PID]: sqlca: code: 0, state: 00000 63[NO_PID]: ECPGget_desc: reading items for tuple 1 64[NO_PID]: sqlca: code: 0, state: 00000 65[NO_PID]: ecpg_get_data on line 55: RESULT: 1 offset: -1; array: no 66[NO_PID]: sqlca: code: 0, state: 00000 67[NO_PID]: ecpg_execute on line 59: query: declare c1 cursor for SELECT * from test1 where a = $1 and b = $2; with 2 parameter(s) on connection ecpg1_regression 68[NO_PID]: sqlca: code: 0, state: 00000 69[NO_PID]: ecpg_execute on line 59: using PQexecParams 70[NO_PID]: sqlca: code: 0, state: 00000 71[NO_PID]: ecpg_free_params on line 59: parameter 1 = 1 72[NO_PID]: sqlca: code: 0, state: 00000 73[NO_PID]: ecpg_free_params on line 59: parameter 2 = one 74[NO_PID]: sqlca: code: 0, state: 00000 75[NO_PID]: ecpg_process_output on line 59: OK: DECLARE CURSOR 76[NO_PID]: sqlca: code: 0, state: 00000 77[NO_PID]: ecpg_execute on line 61: query: fetch next from c1; with 0 parameter(s) on connection ecpg1_regression 78[NO_PID]: sqlca: code: 0, state: 00000 79[NO_PID]: ecpg_execute on line 61: using PQexec 80[NO_PID]: sqlca: code: 0, state: 00000 81[NO_PID]: ecpg_process_output on line 61: correctly got 1 tuples with 2 fields 82[NO_PID]: sqlca: code: 0, state: 00000 83[NO_PID]: ecpg_get_data on line 61: RESULT: 1 offset: -1; array: no 84[NO_PID]: sqlca: code: 0, state: 00000 85[NO_PID]: ecpg_get_data on line 61: RESULT: one offset: -1; array: no 86[NO_PID]: sqlca: code: 0, state: 00000 87[NO_PID]: ecpg_execute on line 65: query: close c1; with 0 parameter(s) on connection ecpg1_regression 88[NO_PID]: sqlca: code: 0, state: 00000 89[NO_PID]: ecpg_execute on line 65: using PQexec 90[NO_PID]: sqlca: code: 0, state: 00000 91[NO_PID]: ecpg_process_output on line 65: OK: CLOSE CURSOR 92[NO_PID]: sqlca: code: 0, state: 00000 93[NO_PID]: ecpg_execute on line 71: query: declare c2 cursor for SELECT * from test1 where $1 = a; with 1 parameter(s) on connection ecpg1_regression 94[NO_PID]: sqlca: code: 0, state: 00000 95[NO_PID]: ecpg_execute on line 71: using PQexecParams 96[NO_PID]: sqlca: code: 0, state: 00000 97[NO_PID]: ecpg_free_params on line 71: parameter 1 = 2 98[NO_PID]: sqlca: code: 0, state: 00000 99[NO_PID]: ecpg_process_output on line 71: OK: DECLARE CURSOR 100[NO_PID]: sqlca: code: 0, state: 00000 101[NO_PID]: ecpg_execute on line 73: query: fetch next from c2; with 0 parameter(s) on connection ecpg1_regression 102[NO_PID]: sqlca: code: 0, state: 00000 103[NO_PID]: ecpg_execute on line 73: using PQexec 104[NO_PID]: sqlca: code: 0, state: 00000 105[NO_PID]: ecpg_process_output on line 73: correctly got 1 tuples with 2 fields 106[NO_PID]: sqlca: code: 0, state: 00000 107[NO_PID]: ecpg_get_data on line 73: RESULT: 2 offset: -1; array: no 108[NO_PID]: sqlca: code: 0, state: 00000 109[NO_PID]: ecpg_get_data on line 73: RESULT: offset: -1; array: no 110[NO_PID]: sqlca: code: 0, state: 00000 111[NO_PID]: ecpg_execute on line 76: query: close c2; with 0 parameter(s) on connection ecpg1_regression 112[NO_PID]: sqlca: code: 0, state: 00000 113[NO_PID]: ecpg_execute on line 76: using PQexec 114[NO_PID]: sqlca: code: 0, state: 00000 115[NO_PID]: ecpg_process_output on line 76: OK: CLOSE CURSOR 116[NO_PID]: sqlca: code: 0, state: 00000 117[NO_PID]: ecpg_execute on line 78: query: select * from test1 where a = 3; with 0 parameter(s) on connection ecpg1_regression 118[NO_PID]: sqlca: code: 0, state: 00000 119[NO_PID]: ecpg_execute on line 78: using PQexec 120[NO_PID]: sqlca: code: 0, state: 00000 121[NO_PID]: ecpg_process_output on line 78: correctly got 1 tuples with 2 fields 122[NO_PID]: sqlca: code: 0, state: 00000 123[NO_PID]: ecpg_get_data on line 78: RESULT: 3 offset: -1; array: no 124[NO_PID]: sqlca: code: 0, state: 00000 125[NO_PID]: ecpg_get_data on line 78: RESULT: this is a long test offset: -1; array: no 126[NO_PID]: sqlca: code: 0, state: 00000 127[NO_PID]: ecpg_execute on line 81: query: drop table test1; with 0 parameter(s) on connection ecpg1_regression 128[NO_PID]: sqlca: code: 0, state: 00000 129[NO_PID]: ecpg_execute on line 81: using PQexec 130[NO_PID]: sqlca: code: 0, state: 00000 131[NO_PID]: ecpg_process_output on line 81: OK: DROP TABLE 132[NO_PID]: sqlca: code: 0, state: 00000 133[NO_PID]: deallocate_one on line 82: name foo3 134[NO_PID]: sqlca: code: 0, state: 00000 135[NO_PID]: deallocate_one on line 82: name foo2 136[NO_PID]: sqlca: code: 0, state: 00000 137[NO_PID]: deallocate_one on line 82: name foo1 138[NO_PID]: sqlca: code: 0, state: 00000 139[NO_PID]: ecpg_finish: connection ecpg1_regression closed 140[NO_PID]: sqlca: code: 0, state: 00000 141