Debian Codegraph @

src/interfaces/ecpg/test/expected/sql-sqljson.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 19: action "on"; connection "ecpg1_regression"
6 [NO_PID]: sqlca: code: 0, state: 00000
7 [NO_PID]: ecpg_execute on line 21: query: select json_object ( returning text ); with 0 parameter(s) on connection ecpg1_regression
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_execute on line 21: using PQexec
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: ecpg_process_output on line 21: correctly got 1 tuples with 1 fields
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: ecpg_get_data on line 21: RESULT: {} offset: -1; array: no
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: ecpg_execute on line 24: query: select json_object ( returning text format json ); with 0 parameter(s) on connection ecpg1_regression
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: ecpg_execute on line 24: using PQexec
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ecpg_process_output on line 24: correctly got 1 tuples with 1 fields
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_get_data on line 24: RESULT: {} offset: -1; array: no
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ecpg_execute on line 27: query: select json_array ( returning jsonb ); with 0 parameter(s) on connection ecpg1_regression
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: ecpg_execute on line 27: using PQexec
26 [NO_PID]: sqlca: code: 0, state: 00000
27 [NO_PID]: ecpg_process_output on line 27: correctly got 1 tuples with 1 fields
28 [NO_PID]: sqlca: code: 0, state: 00000
29 [NO_PID]: ecpg_is_type_an_array on line 27: type (3802); C (1); array (no)
30 [NO_PID]: sqlca: code: 0, state: 00000
31 [NO_PID]: ecpg_get_data on line 27: RESULT: [] offset: -1; array: no
32 [NO_PID]: sqlca: code: 0, state: 00000
33 [NO_PID]: ecpg_execute on line 30: query: select json_array ( returning jsonb format json ); with 0 parameter(s) on connection ecpg1_regression
34 [NO_PID]: sqlca: code: 0, state: 00000
35 [NO_PID]: ecpg_execute on line 30: using PQexec
36 [NO_PID]: sqlca: code: 0, state: 00000
37 [NO_PID]: ecpg_process_output on line 30: correctly got 1 tuples with 1 fields
38 [NO_PID]: sqlca: code: 0, state: 00000
39 [NO_PID]: ecpg_get_data on line 30: RESULT: [] offset: -1; array: no
40 [NO_PID]: sqlca: code: 0, state: 00000
41 [NO_PID]: ecpg_execute on line 33: query: select json_object ( 1 : 1 , '1' : null with unique ); with 0 parameter(s) on connection ecpg1_regression
42 [NO_PID]: sqlca: code: 0, state: 00000
43 [NO_PID]: ecpg_execute on line 33: using PQexec
44 [NO_PID]: sqlca: code: 0, state: 00000
45 [NO_PID]: ecpg_check_PQresult on line 33: bad response - ERROR: duplicate JSON object key value: "1"
46 [NO_PID]: sqlca: code: 0, state: 00000
47 [NO_PID]: raising sqlstate 22030 (sqlcode -400): duplicate JSON object key value: "1" on line 33
48 [NO_PID]: sqlca: code: -400, state: 22030
49 SQL error: duplicate JSON object key value: "1" on line 33
50 [NO_PID]: ecpg_execute on line 36: query: select json_object ( 1 : 1 , '2' : null , 1 : '2' absent on null without unique keys ); with 0 parameter(s) on connection ecpg1_regression
51 [NO_PID]: sqlca: code: 0, state: 00000
52 [NO_PID]: ecpg_execute on line 36: using PQexec
53 [NO_PID]: sqlca: code: 0, state: 00000
54 [NO_PID]: ecpg_process_output on line 36: correctly got 1 tuples with 1 fields
55 [NO_PID]: sqlca: code: 0, state: 00000
56 [NO_PID]: ecpg_is_type_an_array on line 36: type (114); C (1); array (no)
57 [NO_PID]: sqlca: code: 0, state: 00000
58 [NO_PID]: ecpg_get_data on line 36: RESULT: {"1" : 1, "1" : "2"} offset: -1; array: no
59 [NO_PID]: sqlca: code: 0, state: 00000
60 [NO_PID]: ecpg_execute on line 39: query: select json_object ( 1 : 1 , '2' : null absent on null without unique returning jsonb ); with 0 parameter(s) on connection ecpg1_regression
61 [NO_PID]: sqlca: code: 0, state: 00000
62 [NO_PID]: ecpg_execute on line 39: using PQexec
63 [NO_PID]: sqlca: code: 0, state: 00000
64 [NO_PID]: ecpg_process_output on line 39: correctly got 1 tuples with 1 fields
65 [NO_PID]: sqlca: code: 0, state: 00000
66 [NO_PID]: ecpg_get_data on line 39: RESULT: {"1": 1} offset: -1; array: no
67 [NO_PID]: sqlca: code: 0, state: 00000
68 [NO_PID]: ecpg_execute on line 42: query: select json ( null ); with 0 parameter(s) on connection ecpg1_regression
69 [NO_PID]: sqlca: code: 0, state: 00000
70 [NO_PID]: ecpg_execute on line 42: using PQexec
71 [NO_PID]: sqlca: code: 0, state: 00000
72 [NO_PID]: ecpg_process_output on line 42: correctly got 1 tuples with 1 fields
73 [NO_PID]: sqlca: code: 0, state: 00000
74 [NO_PID]: ecpg_get_data on line 42: RESULT: offset: -1; array: no
75 [NO_PID]: sqlca: code: 0, state: 00000
76 [NO_PID]: raising sqlcode -213 on line 42: null value without indicator on line 42
77 [NO_PID]: sqlca: code: -213, state: 22002
78 SQL error: null value without indicator on line 42
79 [NO_PID]: ecpg_execute on line 45: query: select json ( '{ "a" : 1 } ' format json ); with 0 parameter(s) on connection ecpg1_regression
80 [NO_PID]: sqlca: code: 0, state: 00000
81 [NO_PID]: ecpg_execute on line 45: using PQexec
82 [NO_PID]: sqlca: code: 0, state: 00000
83 [NO_PID]: ecpg_process_output on line 45: correctly got 1 tuples with 1 fields
84 [NO_PID]: sqlca: code: 0, state: 00000
85 [NO_PID]: ecpg_get_data on line 45: RESULT: { "a" : 1 } offset: -1; array: no
86 [NO_PID]: sqlca: code: 0, state: 00000
87 [NO_PID]: ecpg_execute on line 48: query: select json ( '{ "a" : 1 } ' format json encoding UTF8 ); with 0 parameter(s) on connection ecpg1_regression
88 [NO_PID]: sqlca: code: 0, state: 00000
89 [NO_PID]: ecpg_execute on line 48: using PQexec
90 [NO_PID]: sqlca: code: 0, state: 00000
91 [NO_PID]: ecpg_check_PQresult on line 48: bad response - ERROR: JSON ENCODING clause is only allowed for bytea input type
92 LINE 1: select json ( '{ "a" : 1 } ' format json encoding UTF8 )
93 ^
94 [NO_PID]: sqlca: code: 0, state: 00000
95 [NO_PID]: raising sqlstate 42804 (sqlcode -400): JSON ENCODING clause is only allowed for bytea input type on line 48
96 [NO_PID]: sqlca: code: -400, state: 42804
97 SQL error: JSON ENCODING clause is only allowed for bytea input type on line 48
98 [NO_PID]: ecpg_execute on line 51: query: select json ( ' 1 ' :: jsonb ); with 0 parameter(s) on connection ecpg1_regression
99 [NO_PID]: sqlca: code: 0, state: 00000
100 [NO_PID]: ecpg_execute on line 51: using PQexec
101 [NO_PID]: sqlca: code: 0, state: 00000
102 [NO_PID]: ecpg_process_output on line 51: correctly got 1 tuples with 1 fields
103 [NO_PID]: sqlca: code: 0, state: 00000
104 [NO_PID]: ecpg_get_data on line 51: RESULT: 1 offset: -1; array: no
105 [NO_PID]: sqlca: code: 0, state: 00000
106 [NO_PID]: ecpg_execute on line 54: query: select json ( ' 1 ' :: json with unique keys ) into json; with 0 parameter(s) on connection ecpg1_regression
107 [NO_PID]: sqlca: code: 0, state: 00000
108 [NO_PID]: ecpg_execute on line 54: using PQexec
109 [NO_PID]: sqlca: code: 0, state: 00000
110 [NO_PID]: ecpg_check_PQresult on line 54: bad response - ERROR: cannot use non-string types with WITH UNIQUE KEYS clause
111 LINE 1: select json ( ' 1 ' :: json with unique keys ) into json
112 ^
113 [NO_PID]: sqlca: code: 0, state: 00000
114 [NO_PID]: raising sqlstate 42804 (sqlcode -400): cannot use non-string types with WITH UNIQUE KEYS clause on line 54
115 [NO_PID]: sqlca: code: -400, state: 42804
116 SQL error: cannot use non-string types with WITH UNIQUE KEYS clause on line 54
117 [NO_PID]: ecpg_execute on line 57: query: select json ( '{"a": 1, "a": 2}' ); with 0 parameter(s) on connection ecpg1_regression
118 [NO_PID]: sqlca: code: 0, state: 00000
119 [NO_PID]: ecpg_execute on line 57: using PQexec
120 [NO_PID]: sqlca: code: 0, state: 00000
121 [NO_PID]: ecpg_process_output on line 57: correctly got 1 tuples with 1 fields
122 [NO_PID]: sqlca: code: 0, state: 00000
123 [NO_PID]: ecpg_get_data on line 57: RESULT: {"a": 1, "a": 2} offset: -1; array: no
124 [NO_PID]: sqlca: code: 0, state: 00000
125 [NO_PID]: ecpg_execute on line 60: query: select json ( '{"a": 1, "a": 2}' with unique keys ); with 0 parameter(s) on connection ecpg1_regression
126 [NO_PID]: sqlca: code: 0, state: 00000
127 [NO_PID]: ecpg_execute on line 60: using PQexec
128 [NO_PID]: sqlca: code: 0, state: 00000
129 [NO_PID]: ecpg_check_PQresult on line 60: bad response - ERROR: duplicate JSON object key value
130 [NO_PID]: sqlca: code: 0, state: 00000
131 [NO_PID]: raising sqlstate 22030 (sqlcode -400): duplicate JSON object key value on line 60
132 [NO_PID]: sqlca: code: -400, state: 22030
133 SQL error: duplicate JSON object key value on line 60
134 [NO_PID]: ecpg_execute on line 63: query: select json_scalar ( null ); with 0 parameter(s) on connection ecpg1_regression
135 [NO_PID]: sqlca: code: 0, state: 00000
136 [NO_PID]: ecpg_execute on line 63: using PQexec
137 [NO_PID]: sqlca: code: 0, state: 00000
138 [NO_PID]: ecpg_process_output on line 63: correctly got 1 tuples with 1 fields
139 [NO_PID]: sqlca: code: 0, state: 00000
140 [NO_PID]: ecpg_get_data on line 63: RESULT: offset: -1; array: no
141 [NO_PID]: sqlca: code: 0, state: 00000
142 [NO_PID]: raising sqlcode -213 on line 63: null value without indicator on line 63
143 [NO_PID]: sqlca: code: -213, state: 22002
144 SQL error: null value without indicator on line 63
145 [NO_PID]: ecpg_execute on line 66: query: select json_scalar ( null :: int ); with 0 parameter(s) on connection ecpg1_regression
146 [NO_PID]: sqlca: code: 0, state: 00000
147 [NO_PID]: ecpg_execute on line 66: using PQexec
148 [NO_PID]: sqlca: code: 0, state: 00000
149 [NO_PID]: ecpg_process_output on line 66: correctly got 1 tuples with 1 fields
150 [NO_PID]: sqlca: code: 0, state: 00000
151 [NO_PID]: ecpg_get_data on line 66: RESULT: offset: -1; array: no
152 [NO_PID]: sqlca: code: 0, state: 00000
153 [NO_PID]: raising sqlcode -213 on line 66: null value without indicator on line 66
154 [NO_PID]: sqlca: code: -213, state: 22002
155 SQL error: null value without indicator on line 66
156 [NO_PID]: ecpg_execute on line 69: query: select json_scalar ( 123.45 ); with 0 parameter(s) on connection ecpg1_regression
157 [NO_PID]: sqlca: code: 0, state: 00000
158 [NO_PID]: ecpg_execute on line 69: using PQexec
159 [NO_PID]: sqlca: code: 0, state: 00000
160 [NO_PID]: ecpg_process_output on line 69: correctly got 1 tuples with 1 fields
161 [NO_PID]: sqlca: code: 0, state: 00000
162 [NO_PID]: ecpg_get_data on line 69: RESULT: 123.45 offset: -1; array: no
163 [NO_PID]: sqlca: code: 0, state: 00000
164 [NO_PID]: ecpg_execute on line 72: query: select json_scalar ( true ); with 0 parameter(s) on connection ecpg1_regression
165 [NO_PID]: sqlca: code: 0, state: 00000
166 [NO_PID]: ecpg_execute on line 72: using PQexec
167 [NO_PID]: sqlca: code: 0, state: 00000
168 [NO_PID]: ecpg_process_output on line 72: correctly got 1 tuples with 1 fields
169 [NO_PID]: sqlca: code: 0, state: 00000
170 [NO_PID]: ecpg_get_data on line 72: RESULT: true offset: -1; array: no
171 [NO_PID]: sqlca: code: 0, state: 00000
172 [NO_PID]: ecpg_execute on line 75: query: select json_scalar ( ' 123.45' ); with 0 parameter(s) on connection ecpg1_regression
173 [NO_PID]: sqlca: code: 0, state: 00000
174 [NO_PID]: ecpg_execute on line 75: using PQexec
175 [NO_PID]: sqlca: code: 0, state: 00000
176 [NO_PID]: ecpg_process_output on line 75: correctly got 1 tuples with 1 fields
177 [NO_PID]: sqlca: code: 0, state: 00000
178 [NO_PID]: ecpg_get_data on line 75: RESULT: " 123.45" offset: -1; array: no
179 [NO_PID]: sqlca: code: 0, state: 00000
180 [NO_PID]: ecpg_execute on line 78: query: select json_scalar ( '2020-06-07 01:02:03' :: timestamp ); with 0 parameter(s) on connection ecpg1_regression
181 [NO_PID]: sqlca: code: 0, state: 00000
182 [NO_PID]: ecpg_execute on line 78: using PQexec
183 [NO_PID]: sqlca: code: 0, state: 00000
184 [NO_PID]: ecpg_process_output on line 78: correctly got 1 tuples with 1 fields
185 [NO_PID]: sqlca: code: 0, state: 00000
186 [NO_PID]: ecpg_get_data on line 78: RESULT: "2020-06-07T01:02:03" offset: -1; array: no
187 [NO_PID]: sqlca: code: 0, state: 00000
188 [NO_PID]: ecpg_execute on line 81: query: select json_scalar ( '{}' :: jsonb ); with 0 parameter(s) on connection ecpg1_regression
189 [NO_PID]: sqlca: code: 0, state: 00000
190 [NO_PID]: ecpg_execute on line 81: using PQexec
191 [NO_PID]: sqlca: code: 0, state: 00000
192 [NO_PID]: ecpg_process_output on line 81: correctly got 1 tuples with 1 fields
193 [NO_PID]: sqlca: code: 0, state: 00000
194 [NO_PID]: ecpg_get_data on line 81: RESULT: {} offset: -1; array: no
195 [NO_PID]: sqlca: code: 0, state: 00000
196 [NO_PID]: ecpg_execute on line 84: query: select json_serialize ( null ); with 0 parameter(s) on connection ecpg1_regression
197 [NO_PID]: sqlca: code: 0, state: 00000
198 [NO_PID]: ecpg_execute on line 84: using PQexec
199 [NO_PID]: sqlca: code: 0, state: 00000
200 [NO_PID]: ecpg_process_output on line 84: correctly got 1 tuples with 1 fields
201 [NO_PID]: sqlca: code: 0, state: 00000
202 [NO_PID]: ecpg_get_data on line 84: RESULT: offset: -1; array: no
203 [NO_PID]: sqlca: code: 0, state: 00000
204 [NO_PID]: raising sqlcode -213 on line 84: null value without indicator on line 84
205 [NO_PID]: sqlca: code: -213, state: 22002
206 SQL error: null value without indicator on line 84
207 [NO_PID]: ecpg_execute on line 87: query: select json_serialize ( json ( '{ "a" : 1 } ' ) ); with 0 parameter(s) on connection ecpg1_regression
208 [NO_PID]: sqlca: code: 0, state: 00000
209 [NO_PID]: ecpg_execute on line 87: using PQexec
210 [NO_PID]: sqlca: code: 0, state: 00000
211 [NO_PID]: ecpg_process_output on line 87: correctly got 1 tuples with 1 fields
212 [NO_PID]: sqlca: code: 0, state: 00000
213 [NO_PID]: ecpg_get_data on line 87: RESULT: { "a" : 1 } offset: -1; array: no
214 [NO_PID]: sqlca: code: 0, state: 00000
215 [NO_PID]: ecpg_execute on line 90: query: select json_serialize ( '{ "a" : 1 } ' ); with 0 parameter(s) on connection ecpg1_regression
216 [NO_PID]: sqlca: code: 0, state: 00000
217 [NO_PID]: ecpg_execute on line 90: using PQexec
218 [NO_PID]: sqlca: code: 0, state: 00000
219 [NO_PID]: ecpg_process_output on line 90: correctly got 1 tuples with 1 fields
220 [NO_PID]: sqlca: code: 0, state: 00000
221 [NO_PID]: ecpg_get_data on line 90: RESULT: { "a" : 1 } offset: -1; array: no
222 [NO_PID]: sqlca: code: 0, state: 00000
223 [NO_PID]: ecpg_execute on line 93: query: select json_serialize ( '1' format json ); with 0 parameter(s) on connection ecpg1_regression
224 [NO_PID]: sqlca: code: 0, state: 00000
225 [NO_PID]: ecpg_execute on line 93: using PQexec
226 [NO_PID]: sqlca: code: 0, state: 00000
227 [NO_PID]: ecpg_process_output on line 93: correctly got 1 tuples with 1 fields
228 [NO_PID]: sqlca: code: 0, state: 00000
229 [NO_PID]: ecpg_get_data on line 93: RESULT: 1 offset: -1; array: no
230 [NO_PID]: sqlca: code: 0, state: 00000
231 [NO_PID]: ecpg_execute on line 96: query: select json_serialize ( '{ "a" : 1 } ' returning varchar ); with 0 parameter(s) on connection ecpg1_regression
232 [NO_PID]: sqlca: code: 0, state: 00000
233 [NO_PID]: ecpg_execute on line 96: using PQexec
234 [NO_PID]: sqlca: code: 0, state: 00000
235 [NO_PID]: ecpg_process_output on line 96: correctly got 1 tuples with 1 fields
236 [NO_PID]: sqlca: code: 0, state: 00000
237 [NO_PID]: ecpg_get_data on line 96: RESULT: { "a" : 1 } offset: -1; array: no
238 [NO_PID]: sqlca: code: 0, state: 00000
239 [NO_PID]: ecpg_execute on line 99: query: select json_serialize ( '{ "a" : 1 } ' returning jsonb ); with 0 parameter(s) on connection ecpg1_regression
240 [NO_PID]: sqlca: code: 0, state: 00000
241 [NO_PID]: ecpg_execute on line 99: using PQexec
242 [NO_PID]: sqlca: code: 0, state: 00000
243 [NO_PID]: ecpg_check_PQresult on line 99: bad response - ERROR: cannot use type jsonb in RETURNING clause of JSON_SERIALIZE()
244 HINT: Try returning a string type or bytea.
245 [NO_PID]: sqlca: code: 0, state: 00000
246 [NO_PID]: raising sqlstate 42804 (sqlcode -400): cannot use type jsonb in RETURNING clause of JSON_SERIALIZE() on line 99
247 [NO_PID]: sqlca: code: -400, state: 42804
248 SQL error: cannot use type jsonb in RETURNING clause of JSON_SERIALIZE() on line 99
249 [NO_PID]: ecpg_execute on line 102: query: with val ( js ) as ( values ( '{ "a": 1, "b": [{ "a": 1, "b": 0, "a": 2 }] }' ) ) select js is json "IS JSON" , js is not json "IS NOT JSON" , js is json value "IS VALUE" , js is json object "IS OBJECT" , js is json array "IS ARRAY" , js is json scalar "IS SCALAR" , js is json without unique keys "WITHOUT UNIQUE" , js is json with unique keys "WITH UNIQUE" from val; with 0 parameter(s) on connection ecpg1_regression
250 [NO_PID]: sqlca: code: 0, state: 00000
251 [NO_PID]: ecpg_execute on line 102: using PQexec
252 [NO_PID]: sqlca: code: 0, state: 00000
253 [NO_PID]: ecpg_process_output on line 102: correctly got 1 tuples with 8 fields
254 [NO_PID]: sqlca: code: 0, state: 00000
255 [NO_PID]: ecpg_get_data on line 102: RESULT: t offset: -1; array: no
256 [NO_PID]: sqlca: code: 0, state: 00000
257 [NO_PID]: ecpg_get_data on line 102: RESULT: f offset: -1; array: no
258 [NO_PID]: sqlca: code: 0, state: 00000
259 [NO_PID]: ecpg_get_data on line 102: RESULT: t offset: -1; array: no
260 [NO_PID]: sqlca: code: 0, state: 00000
261 [NO_PID]: ecpg_get_data on line 102: RESULT: t offset: -1; array: no
262 [NO_PID]: sqlca: code: 0, state: 00000
263 [NO_PID]: ecpg_get_data on line 102: RESULT: f offset: -1; array: no
264 [NO_PID]: sqlca: code: 0, state: 00000
265 [NO_PID]: ecpg_get_data on line 102: RESULT: f offset: -1; array: no
266 [NO_PID]: sqlca: code: 0, state: 00000
267 [NO_PID]: ecpg_get_data on line 102: RESULT: t offset: -1; array: no
268 [NO_PID]: sqlca: code: 0, state: 00000
269 [NO_PID]: ecpg_get_data on line 102: RESULT: f offset: -1; array: no
270 [NO_PID]: sqlca: code: 0, state: 00000
271 [NO_PID]: ecpg_finish: connection ecpg1_regression closed
272 [NO_PID]: sqlca: code: 0, state: 00000