Debian Codegraph @

src/interfaces/ecpg/test/expected/compat_oracle-char_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]: ecpg_execute on line 39: query: create table strdbase ( strval varchar ( 10 ) ); with 0 parameter(s) on connection ecpg1_regression
6 [NO_PID]: sqlca: code: 0, state: 00000
7 [NO_PID]: ecpg_execute on line 39: using PQexec
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_process_output on line 39: OK: CREATE TABLE
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: ecpg_execute on line 40: query: insert into strdbase values ( '' ); with 0 parameter(s) on connection ecpg1_regression
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: ecpg_execute on line 40: using PQexec
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: ecpg_process_output on line 40: OK: INSERT 0 1
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: ecpg_execute on line 41: query: insert into strdbase values ( 'AB' ); with 0 parameter(s) on connection ecpg1_regression
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ecpg_execute on line 41: using PQexec
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_process_output on line 41: OK: INSERT 0 1
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ecpg_execute on line 42: query: insert into strdbase values ( 'ABCD' ); with 0 parameter(s) on connection ecpg1_regression
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: ecpg_execute on line 42: using PQexec
26 [NO_PID]: sqlca: code: 0, state: 00000
27 [NO_PID]: ecpg_process_output on line 42: OK: INSERT 0 1
28 [NO_PID]: sqlca: code: 0, state: 00000
29 [NO_PID]: ecpg_execute on line 43: query: insert into strdbase values ( 'ABCDE' ); with 0 parameter(s) on connection ecpg1_regression
30 [NO_PID]: sqlca: code: 0, state: 00000
31 [NO_PID]: ecpg_execute on line 43: using PQexec
32 [NO_PID]: sqlca: code: 0, state: 00000
33 [NO_PID]: ecpg_process_output on line 43: OK: INSERT 0 1
34 [NO_PID]: sqlca: code: 0, state: 00000
35 [NO_PID]: ecpg_execute on line 44: query: insert into strdbase values ( 'ABCDEF' ); with 0 parameter(s) on connection ecpg1_regression
36 [NO_PID]: sqlca: code: 0, state: 00000
37 [NO_PID]: ecpg_execute on line 44: using PQexec
38 [NO_PID]: sqlca: code: 0, state: 00000
39 [NO_PID]: ecpg_process_output on line 44: OK: INSERT 0 1
40 [NO_PID]: sqlca: code: 0, state: 00000
41 [NO_PID]: ecpg_execute on line 45: query: insert into strdbase values ( 'ABCDEFGHIJ' ); with 0 parameter(s) on connection ecpg1_regression
42 [NO_PID]: sqlca: code: 0, state: 00000
43 [NO_PID]: ecpg_execute on line 45: using PQexec
44 [NO_PID]: sqlca: code: 0, state: 00000
45 [NO_PID]: ecpg_process_output on line 45: OK: INSERT 0 1
46 [NO_PID]: sqlca: code: 0, state: 00000
47 [NO_PID]: ecpg_execute on line 48: query: declare C cursor for select strval , strval from strdbase; with 0 parameter(s) on connection ecpg1_regression
48 [NO_PID]: sqlca: code: 0, state: 00000
49 [NO_PID]: ecpg_execute on line 48: using PQexec
50 [NO_PID]: sqlca: code: 0, state: 00000
51 [NO_PID]: ecpg_process_output on line 48: OK: DECLARE CURSOR
52 [NO_PID]: sqlca: code: 0, state: 00000
53 [NO_PID]: ecpg_execute on line 56: query: fetch C; with 0 parameter(s) on connection ecpg1_regression
54 [NO_PID]: sqlca: code: 0, state: 00000
55 [NO_PID]: ecpg_execute on line 56: using PQexec
56 [NO_PID]: sqlca: code: 0, state: 00000
57 [NO_PID]: ecpg_process_output on line 56: correctly got 1 tuples with 2 fields
58 [NO_PID]: sqlca: code: 0, state: 00000
59 [NO_PID]: ecpg_get_data on line 56: RESULT: offset: -1; array: no
60 [NO_PID]: sqlca: code: 0, state: 00000
61 [NO_PID]: ecpg_get_data on line 56: RESULT: offset: -1; array: no
62 [NO_PID]: sqlca: code: 0, state: 00000
63 [NO_PID]: ecpg_execute on line 56: query: fetch C; with 0 parameter(s) on connection ecpg1_regression
64 [NO_PID]: sqlca: code: 0, state: 00000
65 [NO_PID]: ecpg_execute on line 56: using PQexec
66 [NO_PID]: sqlca: code: 0, state: 00000
67 [NO_PID]: ecpg_process_output on line 56: correctly got 1 tuples with 2 fields
68 [NO_PID]: sqlca: code: 0, state: 00000
69 [NO_PID]: ecpg_get_data on line 56: RESULT: AB offset: -1; array: no
70 [NO_PID]: sqlca: code: 0, state: 00000
71 [NO_PID]: ecpg_get_data on line 56: RESULT: AB offset: -1; array: no
72 [NO_PID]: sqlca: code: 0, state: 00000
73 [NO_PID]: ecpg_execute on line 56: query: fetch C; with 0 parameter(s) on connection ecpg1_regression
74 [NO_PID]: sqlca: code: 0, state: 00000
75 [NO_PID]: ecpg_execute on line 56: using PQexec
76 [NO_PID]: sqlca: code: 0, state: 00000
77 [NO_PID]: ecpg_process_output on line 56: correctly got 1 tuples with 2 fields
78 [NO_PID]: sqlca: code: 0, state: 00000
79 [NO_PID]: ecpg_get_data on line 56: RESULT: ABCD offset: -1; array: no
80 [NO_PID]: sqlca: code: 0, state: 00000
81 [NO_PID]: ecpg_get_data on line 56: RESULT: ABCD offset: -1; array: no
82 [NO_PID]: sqlca: code: 0, state: 00000
83 [NO_PID]: ecpg_execute on line 56: query: fetch C; with 0 parameter(s) on connection ecpg1_regression
84 [NO_PID]: sqlca: code: 0, state: 00000
85 [NO_PID]: ecpg_execute on line 56: using PQexec
86 [NO_PID]: sqlca: code: 0, state: 00000
87 [NO_PID]: ecpg_process_output on line 56: correctly got 1 tuples with 2 fields
88 [NO_PID]: sqlca: code: 0, state: 00000
89 [NO_PID]: ecpg_get_data on line 56: RESULT: ABCDE offset: -1; array: no
90 [NO_PID]: sqlca: code: 0, state: 00000
91 [NO_PID]: ecpg_get_data on line 56: RESULT: ABCDE offset: -1; array: no
92 [NO_PID]: sqlca: code: 0, state: 00000
93 Warning: At least one column was truncated
94 [NO_PID]: ecpg_execute on line 56: query: fetch C; with 0 parameter(s) on connection ecpg1_regression
95 [NO_PID]: sqlca: code: 0, state: 00000
96 [NO_PID]: ecpg_execute on line 56: using PQexec
97 [NO_PID]: sqlca: code: 0, state: 00000
98 [NO_PID]: ecpg_process_output on line 56: correctly got 1 tuples with 2 fields
99 [NO_PID]: sqlca: code: 0, state: 00000
100 [NO_PID]: ecpg_get_data on line 56: RESULT: ABCDEF offset: -1; array: no
101 [NO_PID]: sqlca: code: 0, state: 00000
102 [NO_PID]: ecpg_get_data on line 56: RESULT: ABCDEF offset: -1; array: no
103 [NO_PID]: sqlca: code: 0, state: 00000
104 Warning: At least one column was truncated
105 [NO_PID]: ecpg_execute on line 56: query: fetch C; with 0 parameter(s) on connection ecpg1_regression
106 [NO_PID]: sqlca: code: 0, state: 00000
107 [NO_PID]: ecpg_execute on line 56: using PQexec
108 [NO_PID]: sqlca: code: 0, state: 00000
109 [NO_PID]: ecpg_process_output on line 56: correctly got 1 tuples with 2 fields
110 [NO_PID]: sqlca: code: 0, state: 00000
111 [NO_PID]: ecpg_get_data on line 56: RESULT: ABCDEFGHIJ offset: -1; array: no
112 [NO_PID]: sqlca: code: 0, state: 00000
113 [NO_PID]: ecpg_get_data on line 56: RESULT: ABCDEFGHIJ offset: -1; array: no
114 [NO_PID]: sqlca: code: 0, state: 00000
115 Warning: At least one column was truncated
116 [NO_PID]: ecpg_execute on line 56: query: fetch C; with 0 parameter(s) on connection ecpg1_regression
117 [NO_PID]: sqlca: code: 0, state: 00000
118 [NO_PID]: ecpg_execute on line 56: using PQexec
119 [NO_PID]: sqlca: code: 0, state: 00000
120 [NO_PID]: ecpg_process_output on line 56: correctly got 0 tuples with 2 fields
121 [NO_PID]: sqlca: code: 0, state: 00000
122 [NO_PID]: raising sqlcode 100 on line 56: no data found on line 56
123 [NO_PID]: sqlca: code: 100, state: 02000
124 [NO_PID]: ecpg_execute on line 60: query: close C; with 0 parameter(s) on connection ecpg1_regression
125 [NO_PID]: sqlca: code: 0, state: 00000
126 [NO_PID]: ecpg_execute on line 60: using PQexec
127 [NO_PID]: sqlca: code: 0, state: 00000
128 [NO_PID]: ecpg_process_output on line 60: OK: CLOSE CURSOR
129 [NO_PID]: sqlca: code: 0, state: 00000
130 [NO_PID]: ecpg_execute on line 61: query: drop table strdbase; with 0 parameter(s) on connection ecpg1_regression
131 [NO_PID]: sqlca: code: 0, state: 00000
132 [NO_PID]: ecpg_execute on line 61: using PQexec
133 [NO_PID]: sqlca: code: 0, state: 00000
134 [NO_PID]: ecpg_process_output on line 61: OK: DROP TABLE
135 [NO_PID]: sqlca: code: 0, state: 00000
136 [NO_PID]: ECPGtrans on line 62: action "commit work"; connection "ecpg1_regression"
137 [NO_PID]: sqlca: code: 0, state: 00000
138 [NO_PID]: prepare_common on line 67: name stmt1; query: "SELECT 123::numeric(3,0), 't'::varchar(2)"
139 [NO_PID]: sqlca: code: 0, state: 00000
140 [NO_PID]: ecpg_execute on line 69: query: declare cur1 cursor for SELECT 123::numeric(3,0), 't'::varchar(2); with 0 parameter(s) on connection ecpg1_regression
141 [NO_PID]: sqlca: code: 0, state: 00000
142 [NO_PID]: ecpg_execute on line 69: using PQexec
143 [NO_PID]: sqlca: code: 0, state: 00000
144 [NO_PID]: ecpg_process_output on line 69: OK: DECLARE CURSOR
145 [NO_PID]: sqlca: code: 0, state: 00000
146 [NO_PID]: ecpg_execute on line 70: query: fetch next from cur1; with 0 parameter(s) on connection ecpg1_regression
147 [NO_PID]: sqlca: code: 0, state: 00000
148 [NO_PID]: ecpg_execute on line 70: using PQexec
149 [NO_PID]: sqlca: code: 0, state: 00000
150 [NO_PID]: ecpg_process_output on line 70: correctly got 1 tuples with 2 fields
151 [NO_PID]: sqlca: code: 0, state: 00000
152 [NO_PID]: ecpg_build_native_sqlda on line 70 sqld = 2
153 [NO_PID]: sqlca: code: 0, state: 00000
154 [NO_PID]: ecpg_process_output on line 70: new sqlda was built
155 [NO_PID]: sqlca: code: 0, state: 00000
156 [NO_PID]: ecpg_set_native_sqlda on line 70 row 0 col 0 IS NOT NULL
157 [NO_PID]: sqlca: code: 0, state: 00000
158 [NO_PID]: ecpg_set_native_sqlda on line 70 row 0 col 1 IS NOT NULL
159 [NO_PID]: sqlca: code: 0, state: 00000
160 [NO_PID]: ecpg_get_data on line 70: RESULT: t offset: -1; array: no
161 [NO_PID]: sqlca: code: 0, state: 00000
162 [NO_PID]: ecpg_process_output on line 70: putting result (1 tuple 2 fields) into sqlda descriptor
163 [NO_PID]: sqlca: code: 0, state: 00000
164 [NO_PID]: ecpg_execute on line 85: query: close cur1; with 0 parameter(s) on connection ecpg1_regression
165 [NO_PID]: sqlca: code: 0, state: 00000
166 [NO_PID]: ecpg_execute on line 85: using PQexec
167 [NO_PID]: sqlca: code: 0, state: 00000
168 [NO_PID]: ecpg_process_output on line 85: OK: CLOSE CURSOR
169 [NO_PID]: sqlca: code: 0, state: 00000
170 [NO_PID]: ECPGtrans on line 86: action "commit work"; connection "ecpg1_regression"
171 [NO_PID]: sqlca: code: 0, state: 00000
172 [NO_PID]: deallocate_one on line 0: name stmt1
173 [NO_PID]: sqlca: code: 0, state: 00000
174 [NO_PID]: ecpg_finish: connection ecpg1_regression closed
175 [NO_PID]: sqlca: code: 0, state: 00000