Debian Codegraph @

src/interfaces/ecpg/test/expected/sql-array.stderr

raw
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