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