Debian Codegraph @

mysql-test/suite/x/r/expect_field_exists.result

raw
1 #
2 ## Expectation block
3 ## open([+field_exists=1]) / close()
4 #
5 send Mysqlx.Expect.Open {
6 cond {
7 condition_key: 2
8 condition_value: "1"
9 }
10 }
11
12 RUN recvok
13 Got expected error (code 0)
14
15 send Mysqlx.Expect.Close {
16 }
17
18 RUN recvok
19 Got expected error (code 0)
20
21 #
22 ## Expectation block
23 ## open([+field_exists=1]) / query() / close()
24 #
25 send Mysqlx.Expect.Open {
26 cond {
27 condition_key: 2
28 condition_value: "1"
29 }
30 }
31
32 RUN recvok
33 Got expected error (code 0)
34
35 RUN select "Yes" as 'Is_ok';
36 Is_ok
37 Yes
38 0 rows affected
39 Got expected error (code 0)
40 send Mysqlx.Expect.Close {
41 }
42
43 RUN recvok
44 Got expected error (code 0)
45
46 #
47 ## Expectation block
48 ## open([+field_exists=1, +field_exists=2]) / query() / close()
49 #
50 send Mysqlx.Expect.Open {
51 cond {
52 condition_key: 2
53 condition_value: "1"
54 }
55 cond {
56 condition_key: 2
57 condition_value: "2"
58 }
59 }
60
61 RUN recvok
62 Got expected error (code 0)
63
64 RUN select "Yes" as 'Is_ok';
65 Is_ok
66 Yes
67 0 rows affected
68 Got expected error (code 0)
69 send Mysqlx.Expect.Close {
70 }
71
72 RUN recvok
73 Got expected error (code 0)
74
75 #
76 ## Expectation block
77 ## open([+field_exists=1, +field_exists=unknown]) / query() / close()
78 #
79 send Mysqlx.Expect.Open {
80 cond {
81 condition_key: 2
82 condition_value: "1"
83 }
84 cond {
85 condition_key: 2
86 condition_value: "1.1"
87 }
88 }
89
90 RUN recvok
91 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
92
93 RUN select "Yes" as 'Is_ok';
94 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
95 send Mysqlx.Expect.Close {
96 }
97
98 RUN recvok
99 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
100
101 #
102 ## Expectation block
103 ## open([+field_exists=1]) / query():NOK / query() / close()
104 #
105 send Mysqlx.Expect.Open {
106 cond {
107 condition_key: 2
108 condition_value: "1"
109 }
110 }
111
112 RUN recvok
113 Got expected error (code 0)
114
115 RUN select `invalid_column_name`;
116 Got expected error: Unknown column 'invalid_column_name' in 'field list' (code 1054)
117 RUN select "Yes" as 'Is_ok';
118 Is_ok
119 Yes
120 0 rows affected
121 Got expected error (code 0)
122 send Mysqlx.Expect.Close {
123 }
124
125 RUN recvok
126 Got expected error (code 0)
127
128 #
129 ## Expectation block
130 ## open([+field_exists=unknown]):NOK / query():NOK / close():NOK
131 #
132 send Mysqlx.Expect.Open {
133 cond {
134 condition_key: 2
135 condition_value: "1.1"
136 }
137 }
138
139 RUN recvok
140 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
141
142 RUN select "No" as 'Is_ok';
143 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
144 send Mysqlx.Expect.Close {
145 }
146
147 RUN recvok
148 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
149
150 #
151 ## Expectation block
152 ## open([+field_exists=unknown, +no_error]):NOK / query():NOK / close():NOK
153 #
154 send Mysqlx.Expect.Open {
155 cond {
156 condition_key: 2
157 condition_value: "1.1"
158 }
159 cond {
160 condition_key: 1
161 }
162 }
163
164 RUN recvok
165 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
166
167 RUN select "No" as 'Is_ok';
168 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
169 send Mysqlx.Expect.Close {
170 }
171
172 RUN recvok
173 Got expected error: Expectation failed: field_exists = '1.1' (code 5168)
174
175 #
176 ## Expectation block
177 ## open([+field_exists=2, +no_error]):OK/
178 ## query():OK / query(error):NOK / query():NOK
179 ## close():NOK
180 #
181 send Mysqlx.Expect.Open {
182 cond {
183 condition_key: 2
184 condition_value: "2"
185 }
186 cond {
187 condition_key: 1
188 }
189 }
190
191 RUN recvok
192 Got expected error (code 0)
193
194 RUN select "Yes" as 'Is_ok';
195 Is_ok
196 Yes
197 0 rows affected
198 Got expected error (code 0)
199 RUN select `invalid_column_name`;
200 Got expected error: Unknown column 'invalid_column_name' in 'field list' (code 1054)
201 RUN select "No" as 'Is_ok';
202 Got expected error: Expectation failed: no_error (code 5159)
203 send Mysqlx.Expect.Close {
204 }
205
206 RUN recvok
207 Got expected error: Expectation failed: no_error (code 5159)
208
209 #
210 ## Nested expectation block
211 ## open([+field_exists=2]):OK/
212 ## open([+no_error]):OK/
213 ## query():OK / query(error):NOK / query():NOK
214 ## close():NOK
215 ## query():OK
216 ## close():OK
217 #
218 send Mysqlx.Expect.Open {
219 cond {
220 condition_key: 2
221 condition_value: "2"
222 }
223 }
224
225 RUN recvok
226 Got expected error (code 0)
227
228 send Mysqlx.Expect.Open {
229 cond {
230 condition_key: 1
231 }
232 }
233
234 RUN recvok
235 Got expected error (code 0)
236
237 RUN select "Yes" as 'Is_ok';
238 Is_ok
239 Yes
240 0 rows affected
241 Got expected error (code 0)
242 RUN select `invalid_column_name`;
243 Got expected error: Unknown column 'invalid_column_name' in 'field list' (code 1054)
244 RUN select "No" as 'Is_ok';
245 Got expected error: Expectation failed: no_error (code 5159)
246 send Mysqlx.Expect.Close {
247 }
248
249 RUN recvok
250 Got expected error: Expectation failed: no_error (code 5159)
251
252 RUN select "Yes" as 'Is_ok';
253 Is_ok
254 Yes
255 0 rows affected
256 Got expected error (code 0)
257 send Mysqlx.Expect.Close {
258 }
259
260 RUN recvok
261 Got expected error (code 0)
262
263 #
264 ## Nested expectation block
265 ## open([+no_error]):OK/
266 ## open([+field_exists=2]):OK/
267 ## query(error):NOK
268 ## close():NOK
269 ## query():NOK
270 ## close():NOK
271 #
272 send Mysqlx.Expect.Open {
273 cond {
274 condition_key: 1
275 }
276 }
277
278 RUN recvok
279 Got expected error (code 0)
280
281 send Mysqlx.Expect.Open {
282 cond {
283 condition_key: 2
284 condition_value: "2"
285 }
286 }
287
288 RUN recvok
289 Got expected error (code 0)
290
291 RUN select `invalid_column_name`;
292 Got expected error: Unknown column 'invalid_column_name' in 'field list' (code 1054)
293 send Mysqlx.Expect.Close {
294 }
295
296 RUN recvok
297 Got expected error: Expectation failed: no_error (code 5159)
298
299 RUN select "No" as 'Is_ok';
300 Got expected error: Expectation failed: no_error (code 5159)
301 send Mysqlx.Expect.Close {
302 }
303
304 RUN recvok
305 Got expected error: Expectation failed: no_error (code 5159)
306
307 #
308 ## Nested expectation block
309 ## open([+no_error]):OK/
310 ## open([+field_exists=2], new_context):OK/
311 ## query():NOK
312 ## close():OK
313 ## query():OK
314 ## close():OK
315 #
316 send Mysqlx.Expect.Open {
317 cond {
318 condition_key: 1
319 }
320 }
321
322 RUN recvok
323 Got expected error (code 0)
324
325 send Mysqlx.Expect.Open {
326 op: EXPECT_CTX_EMPTY
327 cond {
328 condition_key: 2
329 condition_value: "2"
330 }
331 }
332
333 RUN recvok
334 Got expected error (code 0)
335
336 RUN select `invalid_column_name`;
337 Got expected error: Unknown column 'invalid_column_name' in 'field list' (code 1054)
338 send Mysqlx.Expect.Close {
339 }
340
341 RUN recvok
342 Got expected error (code 0)
343
344 RUN select "Yes" as 'Is_ok';
345 Is_ok
346 Yes
347 0 rows affected
348 Got expected error (code 0)
349 send Mysqlx.Expect.Close {
350 }
351
352 RUN recvok
353 Got expected error (code 0)
354
355 Mysqlx.Ok {
356 msg: "bye!"
357 }
358 ok