Debian Codegraph @

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

raw
1 ## Test meta-schema validation for various admin collection commands
2
3 ## Preamble
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6
7 ## Tests start here
8 create schema xtest default charset 'utf8mb4';
9
10 --let $xtest_file= $MYSQL_TMP_DIR/admin_collection_metaschema_validation.xpl
11 --write_file $xtest_file
12 -->import assert_schema.macro
13
14 -->macro Assert_invalid_schema %SCHEMA%
15 -->callmacro Assert_schema %COMMAND% xtest test %SCHEMA% ER_X_INVALID_VALIDATION_SCHEMA
16 -->endmacro
17
18 -->echo
19 -->echo
20 -->echo ## I. Test validation of a user provided schema encoded as
21 -->echo ## protobuf.string and a Datatypes.Object
22 -->echo #
23 -->echo # 1. Unknown property.
24 -->echo # 2. Mismatch "id" property type.
25 -->echo # 3. Mismatch "schema" property type.
26 -->echo # 4. Mismatch "title" property type.
27 -->echo # 5. Mismatch "description" property type.
28 -->echo # 6. Mismatch "multipleOf" property type.
29 -->echo # 7. Wrong "multipleOf" property value.
30 -->echo # 8. Mismatch "maximum" property type.
31 -->echo # 9. Mismatch "exclusiveMaximum" property type.
32 -->echo # 10. Mismatch "minimum" property type.
33 -->echo # 11. Mismatch "exclusiveminimum" property type.
34 -->echo # 12. Mismatch "maxLength" property type.
35 -->echo # 13. Wrong "maxLength" property value.
36 -->echo # 14. Mismatch "minLength" property type.
37 -->echo # 15. Wrong "minLength" property value.
38 -->echo # 16. Mismatch "pattern" property type.
39 -->echo # 17. Mismatch "additionalItems" property type.
40 -->echo # 18. Invalid schema contained in the "additionalItems" property.
41 -->echo # 19. Empty "items" properties array.
42 -->echo # 20. "items" properties containing invalid schema.
43 -->echo # 21. "items" properties array containing invalid schema.
44 -->echo # 22. Mismatch "maxItems" properties type.
45 -->echo # 23. Wrong "maxItems" properties value.
46 -->echo # 24. Mismatch "minItems" properties type.
47 -->echo # 25. Wrong "minItems" properties value.
48 -->echo # 26. Mismatch "uniqueItems" properties type.
49 -->echo # 27. Mismatch "maxProperties" properties type.
50 -->echo # 28. Wrong "maxProperties" properties value.
51 -->echo # 29. Mismatch "minProperties" properties type.
52 -->echo # 30. Wrong "minProperties" properties value.
53 -->echo # 31. Mismatch "required" properties type.
54 -->echo # 32. Empty "required" property field.
55 -->echo # 33. "required" property field containing an array of invalid types.
56 -->echo # 34. "required" properties array containing non-unique items.
57 -->echo # 35. Mismatch "additionalProperties" property type.
58 -->echo # 36. Invalid schema in the "additionalProperties" property field.
59 -->echo # 37. Mismatch "definitions" property type.
60 -->echo # 38. "definitions" property containing an invalid schema.
61 -->echo # 39. Mismatch "properties" property type.
62 -->echo # 40. "properties" property containing an invalid schema.
63 -->echo # 41. Mismatch "patternProperties" property type.
64 -->echo # 42. "patternProperties" property containing an invalid schema.
65 -->echo # 43. Mismatch "dependencies" property type.
66 -->echo # 44. "dependencies" properties containing an invalid schema.
67 -->echo # 45. "dependencies" properties containing an empty array.
68 -->echo # 46. "dependencies" properties containing an array of invalid types.
69 -->echo # 47. "dependencies" properties containing an array of a non-unique types.
70 -->echo # 48. Mismatch "enum" property type.
71 -->echo # 49. Empty "enum" properties array.
72 -->echo # 50. Non-unique values in the "enum" property array.
73 -->echo # 51. Mismatch "type" property type.
74 -->echo # 52. Invalid type in "type" properties array.
75 -->echo # 53. Empty "type" properties array.
76 -->echo # 54. Non-unique "type" properties array.
77 -->echo # 55. Mismatch "format" property type.
78 -->echo # 56. Mismatch "allOf" property type.
79 -->echo # 57. Empty "allOf" properties array.
80 -->echo # 58. Invalid schema in the "allOf" properties array.
81 -->echo # 59. Mismatch "anyOf" property type.
82 -->echo # 60. Empty "anyOf" properties array.
83 -->echo # 61. Invalid schema in the "anyOf" properties array.
84 -->echo # 62. Mismatch "oneOf" property type.
85 -->echo # 63. Empty "oneOf" properties array.
86 -->echo # 64. Invalid schema in the "oneOf" properties array.
87 -->echo # 65. Invalid schema as the "not" property value.
88
89 -->echo
90 -->echo #
91 -->echo # I.1
92 -->callmacro Assert_invalid_schema {"unknown": 1}
93 -->callmacro Assert_invalid_schema "{\"unknown\": 1}"
94
95 -->echo
96 -->echo #
97 -->echo # I.2
98 -->callmacro Assert_invalid_schema {"id": 2}
99 -->callmacro Assert_invalid_schema "{\"id\": 2}"
100
101 -->echo
102 -->echo #
103 -->echo # I.3
104 -->callmacro Assert_invalid_schema {"$schema": 3}
105 -->callmacro Assert_invalid_schema "{\"$schema\": 3}"
106
107 -->echo
108 -->echo #
109 -->echo # I.4
110 -->callmacro Assert_invalid_schema {"title": 4}
111 -->callmacro Assert_invalid_schema "{\"title\": 4}"
112
113 -->echo
114 -->echo #
115 -->echo # I.5
116 -->callmacro Assert_invalid_schema {"description": 5}
117 -->callmacro Assert_invalid_schema "{\"description\": 5}"
118
119 -->echo
120 -->echo #
121 -->echo # I.6
122 -->callmacro Assert_invalid_schema {"multipleOf": "five"}
123 -->callmacro Assert_invalid_schema "{\"multipleOf\": \"five\"}"
124
125 -->echo
126 -->echo #
127 -->echo # I.7
128 -->callmacro Assert_invalid_schema {"multipleOf": -1}
129 -->callmacro Assert_invalid_schema "{\"multipleOf\": -1}"
130
131 -->echo
132 -->echo #
133 -->echo # I.8
134 -->callmacro Assert_invalid_schema {"maximum": "one"}
135 -->callmacro Assert_invalid_schema "{\"maximum\": \"one\"}"
136
137 -->echo
138 -->echo #
139 -->echo # I.9
140 -->callmacro Assert_invalid_schema {"exclusiveMaximum": 0}
141 -->callmacro Assert_invalid_schema "{\"exclusiveMaximum\": 0}"
142
143 -->echo
144 -->echo #
145 -->echo # I.10
146 -->callmacro Assert_invalid_schema {"minimum": "zero"}
147 -->callmacro Assert_invalid_schema "{\"minimum\": \"zero\"}"
148
149 -->echo
150 -->echo #
151 -->echo # I.11
152 -->callmacro Assert_invalid_schema {"exclusiveMinimum": 0}
153 -->callmacro Assert_invalid_schema "{\"exclusiveMinimum\": 0}"
154
155 -->echo
156 -->echo #
157 -->echo # I.12
158 -->callmacro Assert_invalid_schema {"maxLength": "ten"}
159 -->callmacro Assert_invalid_schema "{\"maxLength\": \"ten\"}"
160
161 -->echo
162 -->echo #
163 -->echo # I.13
164 -->callmacro Assert_invalid_schema {"maxLength": -100}
165 -->callmacro Assert_invalid_schema "{\"maxLength\": -100}"
166
167 -->echo
168 -->echo #
169 -->echo # I.14
170 -->callmacro Assert_invalid_schema {"minLength": "ten"}
171 -->callmacro Assert_invalid_schema "{\"minLength\": \"ten\"}"
172
173 -->echo
174 -->echo #
175 -->echo # I.15
176 -->callmacro Assert_invalid_schema {"minLength": -10}
177 -->callmacro Assert_invalid_schema "{\"minLength\": -10}"
178
179 -->echo
180 -->echo #
181 -->echo # I.16
182 -->callmacro Assert_invalid_schema {"pattern": 0}
183 -->callmacro Assert_invalid_schema "{\"pattern\": 0}"
184
185 -->echo
186 -->echo #
187 -->echo # I.17
188 -->callmacro Assert_invalid_schema {"additionalItems": 0}
189 -->callmacro Assert_invalid_schema "{\"additionalItems\": 0}"
190
191 -->echo
192 -->echo #
193 -->echo # I.18
194 -->callmacro Assert_invalid_schema {"additionalItems": {"unknown": 0}}
195 -->callmacro Assert_invalid_schema "{\"additionalItems\": {\"unknown\": 0}}"
196
197 -->echo
198 -->echo #
199 -->echo # I.19
200 -->callmacro Assert_invalid_schema {"items": []}
201 -->callmacro Assert_invalid_schema "{\"items\": []}"
202
203 -->echo
204 -->echo #
205 -->echo # I.20
206 -->callmacro Assert_invalid_schema {"items": {"unknown": "foo"}}
207 -->callmacro Assert_invalid_schema "{\"items\": {\"unknown\": \"foo\"}}"
208
209 -->echo
210 -->echo #
211 -->echo # I.21
212 -->callmacro Assert_invalid_schema {"items": [{"unknown": "foo"}]}
213 -->callmacro Assert_invalid_schema "{\"items\": [{\"unknown\": \"foo\"}]}"
214
215 -->echo
216 -->echo #
217 -->echo # I.22
218 -->callmacro Assert_invalid_schema {"maxItems": "ten"}
219 -->callmacro Assert_invalid_schema "{\"maxItems\": \"ten\"}"
220
221 -->echo
222 -->echo #
223 -->echo # I.23
224 -->callmacro Assert_invalid_schema {"maxItems": -100}
225 -->callmacro Assert_invalid_schema "{\"maxItems\": -100}"
226
227 -->echo
228 -->echo #
229 -->echo # I.24
230 -->callmacro Assert_invalid_schema {"minItems": "ten"}
231 -->callmacro Assert_invalid_schema "{\"minItems\": \"ten\"}"
232
233 -->echo
234 -->echo #
235 -->echo # I.25
236 -->callmacro Assert_invalid_schema {"minItems": -10}
237 -->callmacro Assert_invalid_schema "{\"minItems\": -10}"
238
239 -->echo
240 -->echo #
241 -->echo # I.26
242 -->callmacro Assert_invalid_schema {"uniqueItems": 1}
243 -->callmacro Assert_invalid_schema "{\"uniqueItems\": 1}"
244
245 -->echo
246 -->echo #
247 -->echo # I.27
248 -->callmacro Assert_invalid_schema {"maxProperties": "two"}
249 -->callmacro Assert_invalid_schema "{\"maxProperties\": \"two\"}"
250
251 -->echo
252 -->echo #
253 -->echo # I.28
254 -->callmacro Assert_invalid_schema {"maxProperties": -2}
255 -->callmacro Assert_invalid_schema "{\"maxProperties\": -2}"
256
257 -->echo
258 -->echo #
259 -->echo # I.29
260 -->callmacro Assert_invalid_schema {"minProperties": "six"}
261 -->callmacro Assert_invalid_schema "{\"minProperties\": \"six\"}"
262
263 -->echo
264 -->echo #
265 -->echo # I.30
266 -->callmacro Assert_invalid_schema {"minProperties": -10000}
267 -->callmacro Assert_invalid_schema "{\"minProperties\": -10000}"
268
269 -->echo
270 -->echo #
271 -->echo # I.31
272 -->callmacro Assert_invalid_schema {"required": "true"}
273 -->callmacro Assert_invalid_schema "{\"required\": \"true\"}"
274
275 -->echo
276 -->echo #
277 -->echo # I.32
278 -->callmacro Assert_invalid_schema {"required": []}
279 -->callmacro Assert_invalid_schema "{\"required\": []}"
280
281 -->echo
282 -->echo #
283 -->echo # I.33
284 -->callmacro Assert_invalid_schema {"required": [1, 2, "valid"]}
285 -->callmacro Assert_invalid_schema "{\"required\": [1, 2, \"valid\"]}"
286
287 -->echo
288 -->echo #
289 -->echo # I.34
290 -->callmacro Assert_invalid_schema {"required": ["foo", "foo", "bar"]}
291 -->callmacro Assert_invalid_schema "{\"required\": [\"foo\", \"foo\", \"bar\"]}"
292
293 -->echo
294 -->echo #
295 -->echo # I.35
296 -->callmacro Assert_invalid_schema {"additionalProperties": 0}
297 -->callmacro Assert_invalid_schema "{\"additionalProperties\": 0}"
298
299 -->echo
300 -->echo #
301 -->echo # I.36
302 -->callmacro Assert_invalid_schema {"additionalProperties": {"unknown": 0}}
303 -->callmacro Assert_invalid_schema "{\"additionalProperties\": {\"unknown\": 0}}"
304
305 -->echo
306 -->echo #
307 -->echo # I.37
308 -->callmacro Assert_invalid_schema {"definitions": true}
309 -->callmacro Assert_invalid_schema "{\"definitions\": true}"
310
311 -->echo
312 -->echo #
313 -->echo # I.38
314 -->callmacro Assert_invalid_schema {"definitions": {"def": {"invalid": "bar"}}}
315 -->callmacro Assert_invalid_schema "{\"definitions\": {\"def\": {\"invalid\": \"bar\"}}}"
316
317 -->echo
318 -->echo #
319 -->echo # I.39
320 -->callmacro Assert_invalid_schema {"properties": true}
321 -->callmacro Assert_invalid_schema "{\"properties\": true}"
322
323 -->echo
324 -->echo #
325 -->echo # I.40
326 -->callmacro Assert_invalid_schema {"properties": {"def": {"invalid": "bar"}}}
327 -->callmacro Assert_invalid_schema "{\"properties\": {\"def\": {\"invalid\": \"bar\"}}}"
328
329 -->echo
330 -->echo #
331 -->echo # I.41
332 -->callmacro Assert_invalid_schema {"patternProperties": true}
333 -->callmacro Assert_invalid_schema "{\"patternProperties\": true}"
334
335 -->echo
336 -->echo #
337 -->echo # I.42
338 -->callmacro Assert_invalid_schema {"patternProperties": {"def": {"invalid": "bar"}}}
339 -->callmacro Assert_invalid_schema "{\"patternProperties\": {\"def\": {\"invalid\": \"bar\"}}}"
340
341 -->echo
342 -->echo #
343 -->echo # I.43
344 -->callmacro Assert_invalid_schema {"dependencies": "baz"}
345 -->callmacro Assert_invalid_schema "{\"dependencies\": \"baz\"}"
346
347 -->echo
348 -->echo #
349 -->echo # I.44
350 -->callmacro Assert_invalid_schema {"dependencies": {"unknown": "x"}}
351 -->callmacro Assert_invalid_schema "{\"dependencies\": {\"unknown\": \"x\"}}"
352
353 -->echo
354 -->echo #
355 -->echo # I.45
356 -->callmacro Assert_invalid_schema {"dependencies": []}
357 -->callmacro Assert_invalid_schema "{\"dependencies\": []}"
358
359 -->echo
360 -->echo #
361 -->echo # I.46
362 -->callmacro Assert_invalid_schema {"dependencies": [1, 2, "three"]}
363 -->callmacro Assert_invalid_schema "{\"dependencies\": [1, 2, \"three\"]}"
364
365 -->echo
366 -->echo #
367 -->echo # I.47
368 -->callmacro Assert_invalid_schema {"dependencies": ["one", "two", "one"]}
369 -->callmacro Assert_invalid_schema "{\"dependencies\": [\"one\", \"two\", \"one\"]}"
370
371 -->echo
372 -->echo #
373 -->echo # I.48
374 -->callmacro Assert_invalid_schema {"enum": "invalid"}
375 -->callmacro Assert_invalid_schema "{\"enum\": \"invalid\"}"
376
377 -->echo
378 -->echo #
379 -->echo # I.49
380 -->callmacro Assert_invalid_schema {"enum": []}
381 -->callmacro Assert_invalid_schema "{\"enum\": []}"
382
383 -->echo
384 -->echo #
385 -->echo # I.50
386 -->callmacro Assert_invalid_schema {"enum": [1, 1, 2]}
387 -->callmacro Assert_invalid_schema "{\"enum\": [1, 1, 2]}"
388
389 -->echo
390 -->echo #
391 -->echo # I.51
392 -->callmacro Assert_invalid_schema {"type": {"complex": "type"}}
393 -->callmacro Assert_invalid_schema "{\"type\": {\"complex\": \"type\"}}"
394
395 -->echo
396 -->echo #
397 -->echo # I.52
398 -->callmacro Assert_invalid_schema {"type": [{"complex": "type"}]}
399 -->callmacro Assert_invalid_schema "{\"type\": [{\"complex\": \"type\"}]}"
400
401 -->echo
402 -->echo #
403 -->echo # I.53
404 -->callmacro Assert_invalid_schema {"type": []}
405 -->callmacro Assert_invalid_schema "{\"type\": []}"
406
407 -->echo
408 -->echo #
409 -->echo # I.54
410 -->callmacro Assert_invalid_schema {"type": [1, 2, 3, 2]}
411 -->callmacro Assert_invalid_schema "{\"type\": [1, 2, 3, 2]}"
412
413 -->echo
414 -->echo #
415 -->echo # I.55
416 -->callmacro Assert_invalid_schema {"format": {"not": "supported"}}
417 -->callmacro Assert_invalid_schema "{\"format\": {\"not\": \"supported\"}}"
418
419 -->echo
420 -->echo #
421 -->echo # I.56
422 -->callmacro Assert_invalid_schema {"allOf": 5}
423 -->callmacro Assert_invalid_schema "{\"allOf\": 5}"
424
425 -->echo
426 -->echo #
427 -->echo # I.57
428 -->callmacro Assert_invalid_schema {"allOf": []}
429 -->callmacro Assert_invalid_schema "{\"allOf\": []}"
430
431 -->echo
432 -->echo #
433 -->echo # I.58
434 -->callmacro Assert_invalid_schema {"allOf": [{"unknown": "x"}]}
435 -->callmacro Assert_invalid_schema "{\"allOf\": [{\"unknown\": \"x\"}]}"
436
437 -->echo
438 -->echo #
439 -->echo # I.59
440 -->callmacro Assert_invalid_schema {"anyOf": true}
441 -->callmacro Assert_invalid_schema "{\"anyOf\": true}"
442
443 -->echo
444 -->echo #
445 -->echo # I.60
446 -->callmacro Assert_invalid_schema {"anyOf": []}
447 -->callmacro Assert_invalid_schema "{\"anyOf\": []}"
448
449 -->echo
450 -->echo #
451 -->echo # I.61
452 -->callmacro Assert_invalid_schema {"anyOf": [{"unknown": "y"}]}
453 -->callmacro Assert_invalid_schema "{\"anyOf\": [{\"unknown\": \"y\"}]}"
454
455 -->echo
456 -->echo #
457 -->echo # I.62
458 -->callmacro Assert_invalid_schema {"oneOf": "aaa"}
459 -->callmacro Assert_invalid_schema "{\"oneOf\": \"aaa\"}"
460
461 -->echo
462 -->echo #
463 -->echo # I.63
464 -->callmacro Assert_invalid_schema {"oneOf": []}
465 -->callmacro Assert_invalid_schema "{\"oneOf\": []}"
466
467 -->echo
468 -->echo #
469 -->echo # I.64
470 -->callmacro Assert_invalid_schema {"oneOf": [{"unknown": "z"}]}
471 -->callmacro Assert_invalid_schema "{\"oneOf\": [{\"unknown\": \"z\"}]}"
472
473 -->echo
474 -->echo #
475 -->echo # I.65
476 -->callmacro Assert_invalid_schema {"not": [{"unknown": "foo"}]}
477 -->callmacro Assert_invalid_schema "{\"not\": [{\"unknown\": \"foo\"}]}"
478
479 EOF
480
481 exec $MYSQLXTEST -ux_root --password=''
482 --file=$xtest_file -v%COMMAND%=create_collection 2>&1;
483
484 exec $MYSQLXTEST -ux_root --password=''
485 --file=$xtest_file -v%COMMAND%=ensure_collection 2>&1;
486
487 exec $MYSQLXTEST -ux_root --password=''
488 --file=$xtest_file -v%COMMAND%=modify_collection_options 2>&1;
489
490 ## Cleanup
491 --source ../include/xplugin_cleanup.inc