Debian Codegraph @

mysql-test/suite/x/t/crud_overlaps_expr.test

raw
1 ## Varius tests related to overlaps operator
2
3 ## 1. Using 'overlaps' operator with literals
4 ## 1.1 with literal array
5 ## 1.2 with literal object
6 ## 2. Using 'overlaps' operator with idetifiers
7 ## 2.1 with document member array
8 ## 2.1 with document member object
9 ## 3. Using 'overlaps' operator with operators
10 ## 4. Using 'overlaps' operator with function calls
11 ## 5. Validating number of 'overlaps' arguments
12
13
14 ## Preamble
15 --source include/xplugin_preamble.inc
16 --source include/xplugin_create_user.inc
17
18
19 ## Test starts here
20 --let $xtest_file= $MYSQL_TMP_DIR/crud_overlaps_expr.xpl
21 --write_file $xtest_file
22 -->quiet
23
24
25 -->macro Error_on_overlaps %PARAM0% %PARAM1% %ERROR%
26 Mysqlx.Crud.Find {
27 collection { name: "xtable" schema: "xtest" }
28 data_model: TABLE
29 projection {
30 alias: "overlaps"
31 source {
32 type: OPERATOR operator {
33 name: "overlaps"
34 param { %PARAM0% }
35 param { %PARAM1% }
36 }
37 }
38 }
39 }
40 -->expecterror %ERROR%
41 -->recvresult
42 -->endmacro
43
44 -->macro Assert_overlaps %OPERATOR% %PARAM0% %PARAM1% %EXPECT%
45 Mysqlx.Crud.Find {
46 collection { name: "xtable" schema: "xtest" }
47 data_model: TABLE
48 projection {
49 alias: "%OPERATOR%"
50 source {
51 type: OPERATOR operator {
52 name: "%OPERATOR%"
53 param { %PARAM0% }
54 param { %PARAM1% }
55 }
56 }
57 }
58 }
59 -->recvtovar %OPERATOR_RESULT% %OPERATOR%
60 -->echo Verify [Operator "%OPERATOR%" returns value %EXPECT%]
61 -->assert_eq %EXPECT% %OPERATOR_RESULT%
62 -->endmacro
63
64
65 -->macro Overlaps_positive %POSITIVE% %WHERE%
66 -->callmacro Assert_overlaps overlaps %POSITIVE% %WHERE% 1
67 -->callmacro Assert_overlaps not_overlaps %POSITIVE% %WHERE% 0
68 -->endmacro
69
70 -->macro Overlaps_negative %NEGATIVE% %WHERE%
71 -->callmacro Assert_overlaps overlaps %NEGATIVE% %WHERE% 0
72 -->callmacro Assert_overlaps not_overlaps %NEGATIVE% %WHERE% 1
73 -->endmacro
74
75
76 -->varlet %LITERAL% type: LITERAL literal
77 -->varlet %V_SINT% type: V_SINT v_signed_int
78 -->varlet %V_BOOL% type: V_BOOL v_bool
79 -->varlet %V_STRING% type: V_STRING v_string
80 -->varlet %V_FLOAT% type: V_FLOAT v_float
81 -->varlet %V_OCTETS% type: V_OCTETS v_octets
82 -->varlet %ARRAY% type: ARRAY array
83 -->varlet %IDENT% type: IDENT identifier
84 -->varlet %MEMBER% type: MEMBER value
85 -->varlet %OBJECT% type: OBJECT object
86 -->varlet %OPERATOR% type: OPERATOR operator
87 -->varlet %FUNC_CALL% type: FUNC_CALL function_call
88 -->varlet %DOCUMENT_PATH% name: 'doc' document_path
89
90
91 -->varlet %LITERAL_10% %LITERAL% {%V_SINT%: 10}
92 -->varlet %LITERAL_20% %LITERAL% {%V_SINT%: 20}
93 -->varlet %LITERAL_30% %LITERAL% {%V_SINT%: 30}
94 -->varlet %LITERAL_40% %LITERAL% {%V_SINT%: 40}
95
96 -->varlet %LITERAL_TRUE% %LITERAL% {%V_BOOL%: true}
97 -->varlet %LITERAL_FALSE% %LITERAL% {%V_BOOL%: false}
98 -->varlet %LITERAL_NULL% %LITERAL% {type: V_NULL}
99
100 -->varlet %LITERAL_RED% %LITERAL% {%V_STRING% {value:'red'}}
101 -->varlet %LITERAL_GREEN% %LITERAL% {%V_STRING% {value:'green'}}
102 -->varlet %LITERAL_BLUE% %LITERAL% {%V_STRING% {value:'blue'}}
103 -->varlet %LITERAL_WHITE% %LITERAL% {%V_STRING% {value:'white'}}
104
105 -->varlet %LITERAL_APPLE% %LITERAL% {%V_OCTETS% {value:'apple' content_type:0}}
106 -->varlet %LITERAL_PEAR% %LITERAL% {%V_OCTETS% {value:'pear' content_type:0}}
107 -->varlet %LITERAL_PLUM% %LITERAL% {%V_OCTETS% {value:'plum' content_type:0}}
108 -->varlet %LITERAL_BANANA% %LITERAL% {%V_OCTETS% {value:'banana' content_type:0}}
109
110
111 -->varlet %LITERAL_ARRAY_10_20_30% %ARRAY% {value {%LITERAL_10%} value {%LITERAL_20%} value {%LITERAL_30%}}
112 -->varlet %LITERAL_ARRAY_10% %ARRAY% {value {%LITERAL_10%}}
113 -->varlet %LITERAL_ARRAY_40% %ARRAY% {value {%LITERAL_40%}}
114 -->varlet %LITERAL_ARRAY_20% %ARRAY% {value {%LITERAL_20%}}
115
116 -->echo ## 1. Using 'overlaps' operator with literals
117 -->echo ## 1.1 with literal array (numeric)
118 -->callmacro Overlaps_positive %LITERAL_ARRAY_10% %LITERAL_ARRAY_10_20_30%
119 -->callmacro Overlaps_negative %LITERAL_ARRAY_40% %LITERAL_ARRAY_10_20_30%
120
121
122 -->varlet %LITERAL_ARRAY_RED_GREEN_BLUE% %ARRAY% {value {%LITERAL_RED%} value {%LITERAL_GREEN%} value {%LITERAL_BLUE%}}
123 -->varlet %LITERAL_ARRAY_RED% %ARRAY% {value {%LITERAL_RED%}}
124 -->varlet %LITERAL_ARRAY_WHITE% %ARRAY% {value {%LITERAL_WHITE%}}
125
126 -->echo ## 1. Using 'overlaps' operator with literals
127 -->echo ## 1.1 with literal array (string)
128 -->callmacro Overlaps_positive %LITERAL_ARRAY_RED% %LITERAL_ARRAY_RED_GREEN_BLUE%
129 -->callmacro Overlaps_negative %LITERAL_ARRAY_WHITE% %LITERAL_ARRAY_RED_GREEN_BLUE%
130
131 -->varlet %LITERAL_ARRAY_TRUE_TRUE% %ARRAY% {value {%LITERAL_TRUE%} value {%LITERAL_TRUE%}}
132 -->varlet %LITERAL_ARRAY_FALSE_FALSE% %ARRAY% {value {%LITERAL_FALSE%} value {%LITERAL_FALSE%}}
133 -->varlet %LITERAL_ARRAY_TRUE% %ARRAY% {value {%LITERAL_TRUE%}}
134 -->varlet %LITERAL_ARRAY_FALSE% %ARRAY% {value {%LITERAL_FALSE%}}
135
136 -->echo ## 1. Using 'overlaps' operator with literals
137 -->echo ## 1.1 with literal array (bool)
138 -->callmacro Overlaps_positive %LITERAL_ARRAY_TRUE% %LITERAL_ARRAY_TRUE_TRUE%
139 -->callmacro Overlaps_negative %LITERAL_ARRAY_FALSE% %LITERAL_ARRAY_TRUE_TRUE%
140
141 -->callmacro Overlaps_positive %LITERAL_ARRAY_FALSE% %LITERAL_ARRAY_FALSE_FALSE%
142 -->callmacro Overlaps_negative %LITERAL_ARRAY_TRUE% %LITERAL_ARRAY_FALSE_FALSE%
143
144
145 -->varlet %LITERAL_ARRAY_APPLE_PEAR_PLUM% %ARRAY% {value {%LITERAL_APPLE%} value {%LITERAL_PEAR%} value {%LITERAL_PLUM%}}
146 -->varlet %LITERAL_ARRAY_APPLE% %ARRAY% {value {%LITERAL_APPLE%}}
147 -->varlet %LITERAL_ARRAY_BANANA% %ARRAY% {value {%LITERAL_BANANA%}}
148
149 -->echo ## 1. Using 'overlaps' operator with literals
150 -->echo ## 1.1 with literal array (plain octets string)
151 -->callmacro Overlaps_positive %LITERAL_ARRAY_APPLE% %LITERAL_ARRAY_APPLE_PEAR_PLUM%
152 -->callmacro Overlaps_negative %LITERAL_ARRAY_BANANA% %LITERAL_ARRAY_APPLE_PEAR_PLUM%
153
154
155 -->varlet %JSON_OCTETS_ARRAY_10_20_30% %LITERAL% {%V_OCTETS% {value:'[10, 20, 30]' content_type:2}}
156 -->varlet %JSON_OCTETS_ARRAY_10% %LITERAL% {%V_OCTETS% {value:'[10]' content_type:2}}
157 -->varlet %JSON_OCTETS_ARRAY_40% %LITERAL% {%V_OCTETS% {value:'[40]' content_type:2}}
158
159 -->echo ## 1. Using 'overlaps' operator with literals
160 -->echo ## 1.1 with literal array (numeric octets)
161 -->callmacro Overlaps_positive %JSON_OCTETS_ARRAY_10% %JSON_OCTETS_ARRAY_10_20_30%
162 -->callmacro Overlaps_negative %JSON_OCTETS_ARRAY_40% %JSON_OCTETS_ARRAY_10_20_30%
163
164
165 -->varlet %JSON_OCTETS_ARRAY_RED_GREEN_BLUE% %LITERAL% {%V_OCTETS% {value:'["red", "green", "blue"]' content_type:2}}
166 -->varlet %JSON_OCTETS_ARRAY_RED% %LITERAL% {%V_OCTETS% {value:'["red"]' content_type:2}}
167 -->varlet %JSON_OCTETS_ARRAY_WHITE% %LITERAL% {%V_OCTETS% {value:'["white"]' content_type:2}}
168
169 -->echo ## 1. Using 'overlaps' operator with literals
170 -->echo ## 1.1 with literal array (string octets)
171 -->callmacro Overlaps_positive %JSON_OCTETS_ARRAY_RED% %JSON_OCTETS_ARRAY_RED_GREEN_BLUE%
172 -->callmacro Overlaps_negative %JSON_OCTETS_ARRAY_WHITE% %JSON_OCTETS_ARRAY_RED_GREEN_BLUE%
173
174
175 -->varlet %JSON_OCTETS_ARRAY_TRUE_TRUE% %LITERAL% {%V_OCTETS% {value:'[true, true]' content_type:2}}
176 -->varlet %JSON_OCTETS_ARRAY_TRUE% %LITERAL% {%V_OCTETS% {value:'[true]' content_type:2}}
177 -->varlet %JSON_OCTETS_ARRAY_FALSE_FALSE% %LITERAL% {%V_OCTETS% {value:'[false, false]' content_type:2}}
178 -->varlet %JSON_OCTETS_ARRAY_FALSE% %LITERAL% {%V_OCTETS% {value:'[false]' content_type:2}}
179
180 -->echo ## 1. Using 'overlaps' operator with literals
181 -->echo ## 1.1 with literal array (bool octets)
182 -->callmacro Overlaps_positive %JSON_OCTETS_ARRAY_TRUE% %JSON_OCTETS_ARRAY_TRUE_TRUE%
183 -->callmacro Overlaps_negative %JSON_OCTETS_ARRAY_FALSE% %JSON_OCTETS_ARRAY_TRUE_TRUE%
184 -->callmacro Overlaps_positive %JSON_OCTETS_ARRAY_FALSE% %JSON_OCTETS_ARRAY_FALSE_FALSE%
185 -->callmacro Overlaps_negative %JSON_OCTETS_ARRAY_TRUE% %JSON_OCTETS_ARRAY_FALSE_FALSE%
186
187
188 -->varlet %MEMBER_ARRAY_10% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'array_10'}}
189 -->varlet %MEMBER_ARRAY_40% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'array_40'}}
190 -->varlet %MEMBER_ARRAY_10_20_30% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'array_10_20_30'}}
191
192 -->echo ## 2. Using 'overlaps' operator with idetifiers
193 -->echo ## 2.1 with document member array (numeric)
194 -->callmacro Overlaps_positive %LITERAL_ARRAY_10% %MEMBER_ARRAY_10_20_30%
195 -->callmacro Overlaps_negative %LITERAL_ARRAY_40% %MEMBER_ARRAY_10_20_30%
196 -->callmacro Overlaps_positive %MEMBER_ARRAY_10% %LITERAL_ARRAY_10_20_30%
197 -->callmacro Overlaps_negative %MEMBER_ARRAY_40% %LITERAL_ARRAY_10_20_30%
198
199
200 -->varlet %MEMBER_ARRAY_TRUE_TRUE% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'array_true_true'}}
201 -->varlet %MEMBER_ARRAY_FALSE% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'array_false'}}
202
203 -->echo ## 2. Using 'overlaps' operator with idetifiers
204 -->echo ## 2.1 with document member array (bool)
205 -->callmacro Overlaps_positive %LITERAL_ARRAY_TRUE% %MEMBER_ARRAY_TRUE_TRUE%
206 -->callmacro Overlaps_negative %LITERAL_ARRAY_FALSE% %MEMBER_ARRAY_TRUE_TRUE%
207 -->callmacro Overlaps_positive %MEMBER_ARRAY_FALSE% %LITERAL_ARRAY_FALSE_FALSE%
208 -->callmacro Overlaps_negative %LITERAL_ARRAY_TRUE% %LITERAL_ARRAY_FALSE_FALSE%
209
210
211 -->varlet %MEMBER_ARRAY_RED% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'array_red'}}
212 -->varlet %MEMBER_ARRAY_BANANA% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'array_banana'}}
213 -->varlet %MEMBER_ARRAY_RED_GREEN_PEAR% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'array_red_green_pear'}}
214
215 -->echo ## 2. Using 'overlaps' operator with idetifiers
216 -->echo ## 2.1 with document member array (string)
217 -->callmacro Overlaps_positive %LITERAL_ARRAY_RED% %MEMBER_ARRAY_RED_GREEN_PEAR%
218 -->callmacro Overlaps_negative %LITERAL_ARRAY_WHITE% %MEMBER_ARRAY_RED_GREEN_PEAR%
219 -->callmacro Overlaps_positive %MEMBER_ARRAY_RED% %MEMBER_ARRAY_RED_GREEN_PEAR%
220 -->callmacro Overlaps_negative %MEMBER_ARRAY_BANANA% %MEMBER_ARRAY_RED_GREEN_PEAR%
221 -->callmacro Overlaps_positive %MEMBER_ARRAY_RED% %LITERAL_ARRAY_RED_GREEN_BLUE%
222 -->callmacro Overlaps_negative %MEMBER_ARRAY_BANANA% %LITERAL_ARRAY_RED_GREEN_BLUE%
223
224
225
226 # objects
227
228 -->varlet %LITERAL_OBJECT_10% %OBJECT% {fld {key:'ten' value {%LITERAL_10%}}}
229 -->varlet %LITERAL_OBJECT_40% %OBJECT% {fld {key:'forty' value {%LITERAL_40%}}}
230 -->varlet %LITERAL_OBJECT_10_20_30% %OBJECT% {fld {key:'ten' value {%LITERAL_10%}} fld {key:'twenty' value {%LITERAL_20%}} fld {key:'thirty' value {%LITERAL_30%}}}
231
232 -->echo ## 1. Using 'overlaps' operator with literals
233 -->echo ## 1.2 with literal object (numeric)
234 -->callmacro Overlaps_positive %LITERAL_OBJECT_10% %LITERAL_OBJECT_10_20_30%
235 -->callmacro Overlaps_negative %LITERAL_OBJECT_40% %LITERAL_OBJECT_10_20_30%
236
237
238 -->varlet %LITERAL_OBJECT_RED% %OBJECT% {fld {key:'red' value {%LITERAL_RED%}}}
239 -->varlet %LITERAL_OBJECT_WHITE% %OBJECT% {fld {key:'white' value {%LITERAL_WHITE%}}}
240 -->varlet %LITERAL_OBJECT_RED_GREEN_BLUE% %OBJECT% {fld {key:'red' value {%LITERAL_RED%}} fld {key:'green' value {%LITERAL_GREEN%}} fld {key:'blue' value {%LITERAL_BLUE%}}}
241
242 -->echo ## 1. Using 'overlaps' operator with literals
243 -->echo ## 1.2 with literal object (string)
244 -->callmacro Overlaps_positive %LITERAL_OBJECT_RED% %LITERAL_OBJECT_RED_GREEN_BLUE%
245 -->callmacro Overlaps_negative %LITERAL_OBJECT_WHITE% %LITERAL_OBJECT_RED_GREEN_BLUE%
246
247
248 -->varlet %JSON_OCTETS_OBJECT_10% %LITERAL% {%V_OCTETS% {value:'{"ten":10}' content_type:2}}
249 -->varlet %JSON_OCTETS_OBJECT_40% %LITERAL% {%V_OCTETS% {value:'{"forty":40}' content_type:2}}
250 -->varlet %JSON_OCTETS_OBJECT_10_20_30% %LITERAL% {%V_OCTETS% {value:'{"ten":10, "twenty":20, "thirty":30}' content_type:2}}
251
252 -->echo ## 1. Using 'overlaps' operator with literals
253 -->echo ## 1.2 with literal object (numeric octets)
254 -->callmacro Overlaps_positive %JSON_OCTETS_OBJECT_10% %JSON_OCTETS_OBJECT_10_20_30%
255 -->callmacro Overlaps_negative %JSON_OCTETS_OBJECT_40% %JSON_OCTETS_OBJECT_10_20_30%
256
257
258 -->varlet %JSON_OCTETS_OBJECT_RED% %LITERAL% {%V_OCTETS% {value:'{"red":"red"}' content_type:2}}
259 -->varlet %JSON_OCTETS_OBJECT_WHITE% %LITERAL% {%V_OCTETS% {value:'{"white":"white"}' content_type:2}}
260 -->varlet %JSON_OCTETS_OBJECT_RED_GREEN_BLUE% %LITERAL% {%V_OCTETS% {value:'{"red":"red", "green":"green", "blue":"blue"}' content_type:2}}
261
262 -->echo ## 1. Using 'overlaps' operator with literals
263 -->echo ## 1.2 with literal object (string octets)
264 -->callmacro Overlaps_positive %JSON_OCTETS_OBJECT_RED% %JSON_OCTETS_OBJECT_RED_GREEN_BLUE%
265 -->callmacro Overlaps_negative %JSON_OCTETS_OBJECT_WHITE% %JSON_OCTETS_OBJECT_RED_GREEN_BLUE%
266
267
268 -->varlet %DOCUMENT_ROOT% %IDENT% {%DOCUMENT_PATH% {type: MEMBER}}
269
270 -->echo ## 2. Using 'overlaps' operator with idetifiers
271 -->echo ## 2.1 with document member array (document root)
272 -->callmacro Overlaps_positive %LITERAL_OBJECT_RED% %DOCUMENT_ROOT%
273 -->callmacro Overlaps_negative %LITERAL_OBJECT_WHITE% %DOCUMENT_ROOT%
274
275 -->echo ## 2. Using 'overlaps' operator with idetifiers
276 -->echo ## 2.2 with document member object (document root)
277 -->callmacro Overlaps_positive %JSON_OCTETS_OBJECT_RED% %DOCUMENT_ROOT%
278 -->callmacro Overlaps_negative %JSON_OCTETS_OBJECT_WHITE% %DOCUMENT_ROOT%
279
280
281 -->varlet %MEMBER_OBJECT_NUMERIC_10% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'numeric_10'}}
282 -->varlet %MEMBER_OBJECT_NUMERIC_40% %IDENT% {%DOCUMENT_PATH% {%MEMBER%: 'numeric_40'}}
283
284 -->echo ## 2. Using 'overlaps' operator with idetifiers
285 -->echo ## 2.2 with document member object
286 -->callmacro Overlaps_positive %MEMBER_OBJECT_NUMERIC_10% %LITERAL_OBJECT_10_20_30%
287 -->callmacro Overlaps_negative %MEMBER_OBJECT_NUMERIC_40% %LITERAL_OBJECT_10_20_30%
288
289
290
291 # operators
292
293 -->varlet %ADD_OPERATOR% %OPERATOR% {name: '+' param{ %LITERAL_10%} param{ %LITERAL_20%} }
294 -->varlet %CAST_TO_JSON_OPERATOR% %OPERATOR% {name: 'cast' param{%LITERAL% {%V_STRING% {value:'["red"]'}}} param{%LITERAL% {%V_OCTETS% {value:'JSON'}}}}
295
296 -->echo ## 3. Using 'overlaps' operator with operators (not supported operator)
297 -->callmacro Error_on_overlaps %ADD_OPERATOR% %LITERAL_ARRAY_10_20_30% ER_X_EXPR_BAD_VALUE
298
299 -->echo ## 3. Using 'overlaps' operator with operators (cast to json)
300 -->callmacro Assert_overlaps overlaps %CAST_TO_JSON_OPERATOR% %LITERAL_ARRAY_RED_GREEN_BLUE% 1
301
302
303 # null
304
305 -->varlet %LITERAL_ARRAY_NULL% %ARRAY% {value {%LITERAL_NULL%}}
306 -->varlet %LITERAL_ARRAY_10_NULL_30% %ARRAY% {value {%LITERAL_10%} value {%LITERAL_NULL%} value {%LITERAL_30%}}
307
308 -->echo ## 1. Using 'overlaps' operator with literals
309 -->echo ## 1.1 with literal array (null)
310 -->callmacro Assert_overlaps overlaps %LITERAL_ARRAY_10% %LITERAL_ARRAY_10_NULL_30% 1
311 -->callmacro Assert_overlaps overlaps %LITERAL_ARRAY_NULL% %LITERAL_ARRAY_10_NULL_30% 1
312 -->callmacro Assert_overlaps not_overlaps %LITERAL_ARRAY_NULL% %LITERAL_ARRAY_10_20_30% 1
313 -->callmacro Assert_overlaps not_overlaps %LITERAL_ARRAY_40% %LITERAL_ARRAY_10_NULL_30% 1
314
315
316 -->varlet %LITERAL_OBJECT_NULL% %OBJECT% {fld {key:'zero' value {%LITERAL_NULL%}}}
317 -->varlet %LITERAL_OBJECT_10_NULL_30% %OBJECT% {fld {key:'zero' value {%LITERAL_NULL%}} fld {key:'ten' value {%LITERAL_10%}} fld {key:'thirty' value {%LITERAL_30%}}}
318
319 -->echo ## 1. Using 'overlaps' operator with literals
320 -->echo ## 1.2 with literal object (null)
321 -->callmacro Assert_overlaps overlaps %LITERAL_OBJECT_10% %LITERAL_OBJECT_10_NULL_30% 1
322 -->callmacro Assert_overlaps overlaps %LITERAL_OBJECT_NULL% %LITERAL_OBJECT_10_NULL_30% 1
323 -->callmacro Assert_overlaps not_overlaps %LITERAL_OBJECT_NULL% %LITERAL_OBJECT_10_20_30% 1
324 -->callmacro Assert_overlaps not_overlaps %LITERAL_OBJECT_40% %LITERAL_OBJECT_10_NULL_30% 1
325
326
327 # function
328
329 -->varlet %FUNCTION_CONCAT% %FUNC_CALL% {name{name: 'concat'} param{%LITERAL% {%V_STRING% {value:'["'}}} param{%LITERAL_RED%} param{%LITERAL% {%V_STRING% {value:'"]'}}}}
330
331 -->echo ## 4. Using 'overlaps' operator with function calls (not supported function)
332 -->callmacro Error_on_overlaps %LITERAL_ARRAY_RED% %FUNCTION_CONCAT% ER_X_EXPR_BAD_VALUE
333
334 -->echo ## 4. Using 'overlaps' operator with function calls (supported functions)
335 -->title -JSON_ARRAY - Create JSON array
336 -->varlet %FUNCTION_JSON_ARRAY% %FUNC_CALL% {name{name: 'json_array'} param{%LITERAL_10%} param{%LITERAL_RED%} param{%LITERAL_TRUE%}}
337 -->callmacro Overlaps_positive %LITERAL_ARRAY_RED% %FUNCTION_JSON_ARRAY%
338 -->callmacro Overlaps_negative %LITERAL_ARRAY_WHITE% %FUNCTION_JSON_ARRAY%
339
340 -->title -JSON_ARRAY_APPEND - Append data to JSON document
341 -->varlet %ROOT_POINT% %LITERAL% {%V_OCTETS% {value:'$'}}
342 -->varlet %FUNCTION_JSON_ARRAY_APPEND% %FUNC_CALL% {name{name: 'json_array_append'} param{%LITERAL_ARRAY_10_20_30%} param{%ROOT_POINT%} param{%LITERAL_RED%}}
343 -->callmacro Overlaps_positive %LITERAL_ARRAY_RED% %FUNCTION_JSON_ARRAY_APPEND%
344 -->callmacro Overlaps_negative %LITERAL_ARRAY_WHITE% %FUNCTION_JSON_ARRAY_APPEND%
345
346 -->title -JSON_ARRAY_INSERT - Insert into JSON array
347 -->varlet %ARRAY_POINT% %LITERAL% {%V_OCTETS% {value:'$[1]'}}
348 -->varlet %FUNCTION_JSON_ARRAY_INSERT% %FUNC_CALL% {name{name: 'json_array_insert'} param{%LITERAL_ARRAY_10_20_30%} param{%ARRAY_POINT%} param{%LITERAL_RED%}}
349 -->callmacro Overlaps_positive %LITERAL_ARRAY_RED% %FUNCTION_JSON_ARRAY_INSERT%
350 -->callmacro Overlaps_negative %LITERAL_ARRAY_WHITE% %FUNCTION_JSON_ARRAY_INSERT%
351
352 -->title -JSON_CONTAINS - Whether JSON document contains specific object at path
353 -->varlet %FUNCTION_JSON_CONTAINS% %FUNC_CALL% {name{name: 'json_contains'} param{%LITERAL_ARRAY_10_20_30%} param{%LITERAL_RED%}}
354 -->callmacro Error_on_overlaps %LITERAL_ARRAY_RED% %FUNCTION_JSON_CONTAINS% ER_X_EXPR_BAD_VALUE
355
356 -->title -JSON_CONTAINS_PATH - Whether JSON document contains any data at path
357 -->varlet %FUNCTION_JSON_CONTAINS_PATH% %FUNC_CALL% {name{name: 'json_contains_path'} param{%LITERAL_ARRAY_10_20_30%} param{%ARRAY_POINT%}}
358 -->callmacro Error_on_overlaps %LITERAL_ARRAY_RED% %FUNCTION_JSON_CONTAINS_PATH% ER_X_EXPR_BAD_VALUE
359
360 -->title -JSON_DEPTH - Maximum depth of JSON document
361 -->varlet %FUNCTION_JSON_DEPTH% %FUNC_CALL% {name{name: 'json_depth'} param{%LITERAL_ARRAY_10_20_30%}}
362 -->callmacro Error_on_overlaps %LITERAL_ARRAY_RED% %FUNCTION_JSON_DEPTH% ER_X_EXPR_BAD_VALUE
363
364 -->title -JSON_EXTRACT - Return data from JSON document
365 -->varlet %FUNCTION_JSON_EXTRACT% %FUNC_CALL% {name{name: 'json_extract'} param{%MEMBER_ARRAY_10_20_30%} param{%ROOT_POINT%}}
366 -->callmacro Overlaps_positive %LITERAL_ARRAY_10% %FUNCTION_JSON_EXTRACT%
367 -->callmacro Overlaps_negative %LITERAL_ARRAY_40% %FUNCTION_JSON_EXTRACT%
368
369 -->title -JSON_INSERT - Insert data into JSON document
370 -->varlet %FUNCTION_JSON_INSERT% %FUNC_CALL% {name{name: 'json_insert'} param{%LITERAL_ARRAY_RED%} param{%ARRAY_POINT%}, param{%LITERAL_10%}}
371 -->callmacro Overlaps_positive %LITERAL_ARRAY_10% %FUNCTION_JSON_INSERT%
372 -->callmacro Overlaps_negative %LITERAL_ARRAY_40% %FUNCTION_JSON_INSERT%
373
374 -->title -JSON_KEYS - Array of keys from JSON document
375 -->varlet %FUNCTION_JSON_KEYS% %FUNC_CALL% {name{name: 'json_keys'} param{%DOCUMENT_ROOT%}}
376 -->callmacro Overlaps_positive %LITERAL_ARRAY_10% %FUNCTION_JSON_INSERT%
377 -->callmacro Overlaps_negative %LITERAL_ARRAY_40% %FUNCTION_JSON_INSERT%
378
379 -->title -JSON_LENGTH - Number of elements in JSON document
380 -->varlet %FUNCTION_JSON_LENGTH% %FUNC_CALL% {name{name: 'json_length'} param{%DOCUMENT_ROOT%}}
381 -->callmacro Error_on_overlaps %LITERAL_ARRAY_RED% %FUNCTION_JSON_LENGTH% ER_X_EXPR_BAD_VALUE
382
383 -->title -JSON_MERGE - Merge JSON documents
384 -->varlet %FUNCTION_JSON_MERGE% %FUNC_CALL% {name{name: 'json_merge'} param{%LITERAL_OBJECT_10%} param{%LITERAL_OBJECT_RED%}}
385 -->callmacro Overlaps_positive %LITERAL_OBJECT_10% %FUNCTION_JSON_MERGE%
386 -->callmacro Overlaps_negative %LITERAL_OBJECT_40% %FUNCTION_JSON_MERGE%
387
388 -->title -JSON_OBJECT - Create JSON object
389 -->varlet %KEY_10% %LITERAL% {%V_OCTETS% {value:'ten'}}
390 -->varlet %FUNCTION_JSON_OBJECT% %FUNC_CALL% {name{name: 'json_object'} param{%KEY_10%} param{%LITERAL_10%}}
391 -->callmacro Overlaps_positive %LITERAL_OBJECT_10% %FUNCTION_JSON_OBJECT%
392 -->callmacro Overlaps_negative %LITERAL_OBJECT_40% %FUNCTION_JSON_OBJECT%
393
394 #-->title -JSON_QUOTE - Quote JSON document
395 #-->varlet %FUNCTION_JSON_QUOTE% %FUNC_CALL% {name{name: 'json_quote'} param{%LITERAL_RED%}}
396 # no good test scenario
397
398 -->title -JSON_REMOVE - Remove data from JSON document
399 -->varlet %FUNCTION_JSON_REMOVE% %FUNC_CALL% {name{name: 'json_remove'} param{%LITERAL_ARRAY_10_20_30%} param{%ARRAY_POINT%}}
400 -->callmacro Overlaps_positive %LITERAL_ARRAY_10% %FUNCTION_JSON_REMOVE%
401 -->callmacro Overlaps_negative %LITERAL_ARRAY_20% %FUNCTION_JSON_REMOVE%
402
403 -->title -JSON_REPLACE - Replace values in JSON document
404 -->varlet %FUNCTION_JSON_REPLACE% %FUNC_CALL% {name{name: 'json_replace'} param{%LITERAL_ARRAY_10_20_30%} param{%ARRAY_POINT%} param{%LITERAL_40%}}
405 -->callmacro Overlaps_positive %LITERAL_ARRAY_40% %FUNCTION_JSON_REPLACE%
406 -->callmacro Overlaps_negative %LITERAL_ARRAY_20% %FUNCTION_JSON_REPLACE%
407
408 -->title -JSON_SEARCH - Path to value within JSON document
409 -->varlet %FUNCTION_JSON_SEARCH% %FUNC_CALL% {name{name: 'json_search'} param{%LITERAL_ARRAY_RED_GREEN_BLUE%} param{%LITERAL% {%V_OCTETS% {value:'one'}}} param{%LITERAL_GREEN%}}
410 -->callmacro Overlaps_positive %ARRAY% {value {%ARRAY_POINT%}} %FUNCTION_JSON_SEARCH%
411 -->callmacro Overlaps_negative %LITERAL_ARRAY_WHITE% %FUNCTION_JSON_SEARCH%
412
413 -->title -JSON_SET - Insert data into JSON document
414 -->varlet %FUNCTION_JSON_SET% %FUNC_CALL% {name{name: 'json_set'} param{%LITERAL_ARRAY_RED_GREEN_BLUE%} param{%ARRAY_POINT%} param{%LITERAL_10%}}
415 -->callmacro Overlaps_positive %LITERAL_ARRAY_10% %FUNCTION_JSON_SET%
416 -->callmacro Overlaps_negative %LITERAL_ARRAY_20% %FUNCTION_JSON_SET%
417
418 -->title -JSON_TYPE - Type of JSON value
419 -->varlet %FUNCTION_JSON_TYPE% %FUNC_CALL% {name{name: 'json_type'} param{%LITERAL_OBJECT_RED%}}
420 -->callmacro Error_on_overlaps %LITERAL_ARRAY_RED% %FUNCTION_JSON_TYPE% ER_X_EXPR_BAD_VALUE
421
422 #-->title -JSON_UNQUOTE - Unquote JSON value
423 #-->varlet %FUNCTION_JSON_UNQUOTE% %FUNC_CALL% {name{name: 'json_unquote'} param{%MEMBER_SCALAR_RED%}}
424 # no good test scenario
425
426 -->title -JSON_VALID - Whether JSON value is valid
427 -->varlet %FUNCTION_JSON_VALID% %FUNC_CALL% {name{name: 'json_valid'} param{%LITERAL_OBJECT_RED%}}
428 -->callmacro Error_on_overlaps %LITERAL_ARRAY_RED% %FUNCTION_JSON_VALID% ER_X_EXPR_BAD_VALUE
429
430 # parameters
431
432 -->macro Overlaps_params %PARAMS% %ERROR%
433 Mysqlx.Crud.Find {
434 collection { name: "xtable" schema: "xtest" }
435 data_model: TABLE
436 projection {
437 alias: "overlaps"
438 source {
439 type: OPERATOR operator {
440 name: "overlaps"
441 %PARAMS%
442 }
443 }
444 }
445 }
446 -->expecterror %ERROR%
447 -->recvresult
448 -->endmacro
449
450 -->echo ## 5. Validating number of 'overlaps' arguments
451 -->callmacro Overlaps_params ER_X_EXPR_BAD_NUM_ARGS
452 -->callmacro Overlaps_params param{ %LITERAL_ARRAY_10%} ER_X_EXPR_BAD_NUM_ARGS
453 -->callmacro Overlaps_params param{ %LITERAL_ARRAY_10%} param{ %LITERAL_ARRAY_20%} ER_SUCCESS
454 -->callmacro Overlaps_params param{ %LITERAL_ARRAY_10%} param{ %LITERAL_ARRAY_20%} param{ %LITERAL_ARRAY_40%} ER_X_EXPR_BAD_NUM_ARGS
455
456
457 -->echo # Some extra scenarios
458 -->varlet %LITERAL_EMPTY_STRING% %LITERAL% {%V_STRING% {value:''}}
459 -->varlet %LITERAL_STRING_10% %LITERAL% {%V_STRING% {value:'10'}}
460 -->varlet %LITERAL_DATE% %LITERAL% {%V_STRING% {value:'2018:10:10'}}
461 -->varlet %LITERAL_78_67% %LITERAL% {%V_FLOAT%: 78.67}
462 -->varlet %LITERAL_ARRAY_EMPTY% %ARRAY% {}
463 -->varlet %LITERAL_ARRAY_EMPTY_STRING% %ARRAY% {value {%LITERAL_EMPTY_STRING%}}
464 -->varlet %LITERAL_ARRAY_STRING_10% %ARRAY% {value {%LITERAL_STRING_10%}}
465 -->varlet %LITERAL_ARRAY_MIX% %ARRAY% {value {%LITERAL_RED%} value {%LITERAL_10%} value {%LITERAL_STRING_10%} value {%LITERAL_NULL%} value {%LITERAL_78_67%} value {%LITERAL_DATE%}}
466 -->varlet %LITERAL_OBJECT_EMPTY_ARRAY% %OBJECT% {fld {key:'empty' value {%LITERAL_ARRAY_EMPTY%}}}
467 -->varlet %LITERAL_OBJECT_EMPTY_STRING% %OBJECT% {fld {key:'empty' value {%LITERAL_EMPTY_STRING%}}}
468
469 -->callmacro Overlaps_negative %LITERAL_ARRAY_EMPTY% %LITERAL_ARRAY_RED_GREEN_BLUE%
470 -->callmacro Overlaps_negative %LITERAL_ARRAY_EMPTY_STRING% %LITERAL_ARRAY_RED%
471 -->callmacro Overlaps_negative %LITERAL_OBJECT_EMPTY_STRING% %LITERAL_OBJECT_EMPTY_ARRAY%
472 -->callmacro Overlaps_positive %LITERAL_ARRAY_MIX% %LITERAL_ARRAY_STRING_10%
473 -->callmacro Overlaps_positive %LITERAL_ARRAY_MIX% %LITERAL_ARRAY_NULL%
474 -->callmacro Overlaps_negative %LITERAL_ARRAY_MIX% %LITERAL_ARRAY_WHITE%
475 -->callmacro Overlaps_positive %LITERAL_ARRAY_MIX% %LITERAL_78_67%
476
477
478 EOF
479
480 CREATE SCHEMA xtest;
481 CREATE TABLE xtest.xtable (doc JSON);
482 INSERT INTO xtest.xtable (doc) VALUES
483 ('{"array_10":[10],
484 "array_40":[40],
485 "array_10_20_30":[10,20,30],
486 "array_red":["red"],
487 "array_banana":["banana"],
488 "array_true_true":[true, true],
489 "array_false":[false],
490 "array_red_green_pear":["red","green","pear"],
491 "numeric_10":{"ten":10},
492 "numeric_40":{"forty":40},
493 "red":"red"}');
494
495 --exec $MYSQLXTEST -ux_root --password='' --file=$xtest_file 2>&1
496
497 ## Cleanup
498 --source ../include/xplugin_cleanup.inc