Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest;
2 CREATE TABLE xtest.xtable (doc JSON);
3 INSERT INTO xtest.xtable (doc) VALUES
4 ('{"array_10":[10],
5 "array_40":[40],
6 "array_10_20_30":[10,20,30],
7 "array_red":["red"],
8 "array_banana":["banana"],
9 "array_true_true":[true, true],
10 "array_false":[false],
11 "array_red_green_pear":["red","green","pear"],
12 "numeric_10":{"ten":10},
13 "numeric_40":{"forty":40},
14 "red":"red"}');
15 ## 1. Using 'overlaps' operator with literals
16 ## 1.1 with literal array (numeric)
17 Verify [Operator "overlaps" returns value 1]
18 Verify [Operator "not_overlaps" returns value 0]
19 Verify [Operator "overlaps" returns value 0]
20 Verify [Operator "not_overlaps" returns value 1]
21 ## 1. Using 'overlaps' operator with literals
22 ## 1.1 with literal array (string)
23 Verify [Operator "overlaps" returns value 1]
24 Verify [Operator "not_overlaps" returns value 0]
25 Verify [Operator "overlaps" returns value 0]
26 Verify [Operator "not_overlaps" returns value 1]
27 ## 1. Using 'overlaps' operator with literals
28 ## 1.1 with literal array (bool)
29 Verify [Operator "overlaps" returns value 1]
30 Verify [Operator "not_overlaps" returns value 0]
31 Verify [Operator "overlaps" returns value 0]
32 Verify [Operator "not_overlaps" returns value 1]
33 Verify [Operator "overlaps" returns value 1]
34 Verify [Operator "not_overlaps" returns value 0]
35 Verify [Operator "overlaps" returns value 0]
36 Verify [Operator "not_overlaps" returns value 1]
37 ## 1. Using 'overlaps' operator with literals
38 ## 1.1 with literal array (plain octets string)
39 Verify [Operator "overlaps" returns value 1]
40 Verify [Operator "not_overlaps" returns value 0]
41 Verify [Operator "overlaps" returns value 0]
42 Verify [Operator "not_overlaps" returns value 1]
43 ## 1. Using 'overlaps' operator with literals
44 ## 1.1 with literal array (numeric octets)
45 Verify [Operator "overlaps" returns value 1]
46 Verify [Operator "not_overlaps" returns value 0]
47 Verify [Operator "overlaps" returns value 0]
48 Verify [Operator "not_overlaps" returns value 1]
49 ## 1. Using 'overlaps' operator with literals
50 ## 1.1 with literal array (string octets)
51 Verify [Operator "overlaps" returns value 1]
52 Verify [Operator "not_overlaps" returns value 0]
53 Verify [Operator "overlaps" returns value 0]
54 Verify [Operator "not_overlaps" returns value 1]
55 ## 1. Using 'overlaps' operator with literals
56 ## 1.1 with literal array (bool octets)
57 Verify [Operator "overlaps" returns value 1]
58 Verify [Operator "not_overlaps" returns value 0]
59 Verify [Operator "overlaps" returns value 0]
60 Verify [Operator "not_overlaps" returns value 1]
61 Verify [Operator "overlaps" returns value 1]
62 Verify [Operator "not_overlaps" returns value 0]
63 Verify [Operator "overlaps" returns value 0]
64 Verify [Operator "not_overlaps" returns value 1]
65 ## 2. Using 'overlaps' operator with idetifiers
66 ## 2.1 with document member array (numeric)
67 Verify [Operator "overlaps" returns value 1]
68 Verify [Operator "not_overlaps" returns value 0]
69 Verify [Operator "overlaps" returns value 0]
70 Verify [Operator "not_overlaps" returns value 1]
71 Verify [Operator "overlaps" returns value 1]
72 Verify [Operator "not_overlaps" returns value 0]
73 Verify [Operator "overlaps" returns value 0]
74 Verify [Operator "not_overlaps" returns value 1]
75 ## 2. Using 'overlaps' operator with idetifiers
76 ## 2.1 with document member array (bool)
77 Verify [Operator "overlaps" returns value 1]
78 Verify [Operator "not_overlaps" returns value 0]
79 Verify [Operator "overlaps" returns value 0]
80 Verify [Operator "not_overlaps" returns value 1]
81 Verify [Operator "overlaps" returns value 1]
82 Verify [Operator "not_overlaps" returns value 0]
83 Verify [Operator "overlaps" returns value 0]
84 Verify [Operator "not_overlaps" returns value 1]
85 ## 2. Using 'overlaps' operator with idetifiers
86 ## 2.1 with document member array (string)
87 Verify [Operator "overlaps" returns value 1]
88 Verify [Operator "not_overlaps" returns value 0]
89 Verify [Operator "overlaps" returns value 0]
90 Verify [Operator "not_overlaps" returns value 1]
91 Verify [Operator "overlaps" returns value 1]
92 Verify [Operator "not_overlaps" returns value 0]
93 Verify [Operator "overlaps" returns value 0]
94 Verify [Operator "not_overlaps" returns value 1]
95 Verify [Operator "overlaps" returns value 1]
96 Verify [Operator "not_overlaps" returns value 0]
97 Verify [Operator "overlaps" returns value 0]
98 Verify [Operator "not_overlaps" returns value 1]
99 ## 1. Using 'overlaps' operator with literals
100 ## 1.2 with literal object (numeric)
101 Verify [Operator "overlaps" returns value 1]
102 Verify [Operator "not_overlaps" returns value 0]
103 Verify [Operator "overlaps" returns value 0]
104 Verify [Operator "not_overlaps" returns value 1]
105 ## 1. Using 'overlaps' operator with literals
106 ## 1.2 with literal object (string)
107 Verify [Operator "overlaps" returns value 1]
108 Verify [Operator "not_overlaps" returns value 0]
109 Verify [Operator "overlaps" returns value 0]
110 Verify [Operator "not_overlaps" returns value 1]
111 ## 1. Using 'overlaps' operator with literals
112 ## 1.2 with literal object (numeric octets)
113 Verify [Operator "overlaps" returns value 1]
114 Verify [Operator "not_overlaps" returns value 0]
115 Verify [Operator "overlaps" returns value 0]
116 Verify [Operator "not_overlaps" returns value 1]
117 ## 1. Using 'overlaps' operator with literals
118 ## 1.2 with literal object (string octets)
119 Verify [Operator "overlaps" returns value 1]
120 Verify [Operator "not_overlaps" returns value 0]
121 Verify [Operator "overlaps" returns value 0]
122 Verify [Operator "not_overlaps" returns value 1]
123 ## 2. Using 'overlaps' operator with idetifiers
124 ## 2.1 with document member array (document root)
125 Verify [Operator "overlaps" returns value 1]
126 Verify [Operator "not_overlaps" returns value 0]
127 Verify [Operator "overlaps" returns value 0]
128 Verify [Operator "not_overlaps" returns value 1]
129 ## 2. Using 'overlaps' operator with idetifiers
130 ## 2.2 with document member object (document root)
131 Verify [Operator "overlaps" returns value 1]
132 Verify [Operator "not_overlaps" returns value 0]
133 Verify [Operator "overlaps" returns value 0]
134 Verify [Operator "not_overlaps" returns value 1]
135 ## 2. Using 'overlaps' operator with idetifiers
136 ## 2.2 with document member object
137 Verify [Operator "overlaps" returns value 1]
138 Verify [Operator "not_overlaps" returns value 0]
139 Verify [Operator "overlaps" returns value 0]
140 Verify [Operator "not_overlaps" returns value 1]
141 ## 3. Using 'overlaps' operator with operators (not supported operator)
142 Got expected error: OVERLAPS expression requires operator that produce a JSON value. (code 5154)
143 ## 3. Using 'overlaps' operator with operators (cast to json)
144 Verify [Operator "overlaps" returns value 1]
145 ## 1. Using 'overlaps' operator with literals
146 ## 1.1 with literal array (null)
147 Verify [Operator "overlaps" returns value 1]
148 Verify [Operator "overlaps" returns value 1]
149 Verify [Operator "not_overlaps" returns value 1]
150 Verify [Operator "not_overlaps" returns value 1]
151 ## 1. Using 'overlaps' operator with literals
152 ## 1.2 with literal object (null)
153 Verify [Operator "overlaps" returns value 1]
154 Verify [Operator "overlaps" returns value 1]
155 Verify [Operator "not_overlaps" returns value 1]
156 Verify [Operator "not_overlaps" returns value 1]
157 ## 4. Using 'overlaps' operator with function calls (not supported function)
158 Got expected error: OVERLAPS expression requires function that produce a JSON value. (code 5154)
159 ## 4. Using 'overlaps' operator with function calls (supported functions)
160
161 JSON_ARRAY - Create JSON array
162 ------------------------------
163 Verify [Operator "overlaps" returns value 1]
164 Verify [Operator "not_overlaps" returns value 0]
165 Verify [Operator "overlaps" returns value 0]
166 Verify [Operator "not_overlaps" returns value 1]
167
168 JSON_ARRAY_APPEND - Append data to JSON document
169 ------------------------------------------------
170 Verify [Operator "overlaps" returns value 1]
171 Verify [Operator "not_overlaps" returns value 0]
172 Verify [Operator "overlaps" returns value 0]
173 Verify [Operator "not_overlaps" returns value 1]
174
175 JSON_ARRAY_INSERT - Insert into JSON array
176 ------------------------------------------
177 Verify [Operator "overlaps" returns value 1]
178 Verify [Operator "not_overlaps" returns value 0]
179 Verify [Operator "overlaps" returns value 0]
180 Verify [Operator "not_overlaps" returns value 1]
181
182 JSON_CONTAINS - Whether JSON document contains specific object at path
183 ----------------------------------------------------------------------
184 Got expected error: OVERLAPS expression requires function that produce a JSON value. (code 5154)
185
186 JSON_CONTAINS_PATH - Whether JSON document contains any data at path
187 --------------------------------------------------------------------
188 Got expected error: OVERLAPS expression requires function that produce a JSON value. (code 5154)
189
190 JSON_DEPTH - Maximum depth of JSON document
191 -------------------------------------------
192 Got expected error: OVERLAPS expression requires function that produce a JSON value. (code 5154)
193
194 JSON_EXTRACT - Return data from JSON document
195 ---------------------------------------------
196 Verify [Operator "overlaps" returns value 1]
197 Verify [Operator "not_overlaps" returns value 0]
198 Verify [Operator "overlaps" returns value 0]
199 Verify [Operator "not_overlaps" returns value 1]
200
201 JSON_INSERT - Insert data into JSON document
202 --------------------------------------------
203 Verify [Operator "overlaps" returns value 1]
204 Verify [Operator "not_overlaps" returns value 0]
205 Verify [Operator "overlaps" returns value 0]
206 Verify [Operator "not_overlaps" returns value 1]
207
208 JSON_KEYS - Array of keys from JSON document
209 --------------------------------------------
210 Verify [Operator "overlaps" returns value 1]
211 Verify [Operator "not_overlaps" returns value 0]
212 Verify [Operator "overlaps" returns value 0]
213 Verify [Operator "not_overlaps" returns value 1]
214
215 JSON_LENGTH - Number of elements in JSON document
216 -------------------------------------------------
217 Got expected error: OVERLAPS expression requires function that produce a JSON value. (code 5154)
218
219 JSON_MERGE - Merge JSON documents
220 ---------------------------------
221 Verify [Operator "overlaps" returns value 1]
222 Verify [Operator "not_overlaps" returns value 0]
223 Verify [Operator "overlaps" returns value 0]
224 Verify [Operator "not_overlaps" returns value 1]
225
226 JSON_OBJECT - Create JSON object
227 --------------------------------
228 Verify [Operator "overlaps" returns value 1]
229 Verify [Operator "not_overlaps" returns value 0]
230 Verify [Operator "overlaps" returns value 0]
231 Verify [Operator "not_overlaps" returns value 1]
232
233 JSON_REMOVE - Remove data from JSON document
234 --------------------------------------------
235 Verify [Operator "overlaps" returns value 1]
236 Verify [Operator "not_overlaps" returns value 0]
237 Verify [Operator "overlaps" returns value 0]
238 Verify [Operator "not_overlaps" returns value 1]
239
240 JSON_REPLACE - Replace values in JSON document
241 ----------------------------------------------
242 Verify [Operator "overlaps" returns value 1]
243 Verify [Operator "not_overlaps" returns value 0]
244 Verify [Operator "overlaps" returns value 0]
245 Verify [Operator "not_overlaps" returns value 1]
246
247 JSON_SEARCH - Path to value within JSON document
248 ------------------------------------------------
249 Verify [Operator "overlaps" returns value 1]
250 Verify [Operator "not_overlaps" returns value 0]
251 Verify [Operator "overlaps" returns value 0]
252 Verify [Operator "not_overlaps" returns value 1]
253
254 JSON_SET - Insert data into JSON document
255 -----------------------------------------
256 Verify [Operator "overlaps" returns value 1]
257 Verify [Operator "not_overlaps" returns value 0]
258 Verify [Operator "overlaps" returns value 0]
259 Verify [Operator "not_overlaps" returns value 1]
260
261 JSON_TYPE - Type of JSON value
262 ------------------------------
263 Got expected error: OVERLAPS expression requires function that produce a JSON value. (code 5154)
264
265 JSON_VALID - Whether JSON value is valid
266 ----------------------------------------
267 Got expected error: OVERLAPS expression requires function that produce a JSON value. (code 5154)
268 ## 5. Validating number of 'overlaps' arguments
269 Got expected error: OVERLAPS expression requires two parameters. (code 5151)
270 Got expected error: OVERLAPS expression requires two parameters. (code 5151)
271 overlaps
272 0
273 command ok
274 Got expected error (code 0)
275 Got expected error: OVERLAPS expression requires two parameters. (code 5151)
276 # Some extra scenarios
277 Verify [Operator "overlaps" returns value 0]
278 Verify [Operator "not_overlaps" returns value 1]
279 Verify [Operator "overlaps" returns value 0]
280 Verify [Operator "not_overlaps" returns value 1]
281 Verify [Operator "overlaps" returns value 0]
282 Verify [Operator "not_overlaps" returns value 1]
283 Verify [Operator "overlaps" returns value 1]
284 Verify [Operator "not_overlaps" returns value 0]
285 Verify [Operator "overlaps" returns value 1]
286 Verify [Operator "not_overlaps" returns value 0]
287 Verify [Operator "overlaps" returns value 0]
288 Verify [Operator "not_overlaps" returns value 1]
289 Verify [Operator "overlaps" returns value 1]
290 Verify [Operator "not_overlaps" returns value 0]
291 Mysqlx.Ok {
292 msg: "bye!"
293 }
294 ok