| 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 |