## Test meta-schema validation for various admin collection commands

## Preamble
--source include/xplugin_preamble.inc
--source include/xplugin_create_user.inc

## Tests start here
create schema xtest default charset 'utf8mb4';

--let $xtest_file= $MYSQL_TMP_DIR/admin_collection_metaschema_validation.xpl
--write_file $xtest_file
-->import assert_schema.macro

-->macro Assert_invalid_schema %SCHEMA%
-->callmacro Assert_schema	%COMMAND%	xtest	test	%SCHEMA%	ER_X_INVALID_VALIDATION_SCHEMA
-->endmacro

-->echo
-->echo
-->echo ## I. Test validation of a user provided schema encoded as
-->echo ##    protobuf.string and a Datatypes.Object
-->echo #
-->echo # 1. Unknown property.
-->echo # 2. Mismatch "id" property type.
-->echo # 3. Mismatch "schema" property type.
-->echo # 4. Mismatch "title" property type.
-->echo # 5. Mismatch "description" property type.
-->echo # 6. Mismatch "multipleOf" property type.
-->echo # 7. Wrong "multipleOf" property value.
-->echo # 8. Mismatch "maximum" property type.
-->echo # 9. Mismatch "exclusiveMaximum" property type.
-->echo # 10. Mismatch "minimum" property type.
-->echo # 11. Mismatch "exclusiveminimum" property type.
-->echo # 12. Mismatch "maxLength" property type.
-->echo # 13. Wrong "maxLength" property value.
-->echo # 14. Mismatch "minLength" property type.
-->echo # 15. Wrong "minLength" property value.
-->echo # 16. Mismatch "pattern" property type.
-->echo # 17. Mismatch "additionalItems" property type.
-->echo # 18. Invalid schema contained in the "additionalItems" property.
-->echo # 19. Empty "items" properties array.
-->echo # 20. "items" properties containing invalid schema.
-->echo # 21. "items" properties array containing invalid schema.
-->echo # 22. Mismatch "maxItems" properties type.
-->echo # 23. Wrong "maxItems" properties value.
-->echo # 24. Mismatch "minItems" properties type.
-->echo # 25. Wrong "minItems" properties value.
-->echo # 26. Mismatch "uniqueItems" properties type.
-->echo # 27. Mismatch "maxProperties" properties type.
-->echo # 28. Wrong "maxProperties" properties value.
-->echo # 29. Mismatch "minProperties" properties type.
-->echo # 30. Wrong "minProperties" properties value.
-->echo # 31. Mismatch "required" properties type.
-->echo # 32. Empty "required" property field.
-->echo # 33. "required" property field containing an array of invalid types.
-->echo # 34. "required" properties array containing non-unique items.
-->echo # 35. Mismatch "additionalProperties" property type.
-->echo # 36. Invalid schema in the "additionalProperties" property field.
-->echo # 37. Mismatch "definitions" property type.
-->echo # 38. "definitions" property containing an invalid schema.
-->echo # 39. Mismatch "properties" property type.
-->echo # 40. "properties" property containing an invalid schema.
-->echo # 41. Mismatch "patternProperties" property type.
-->echo # 42. "patternProperties" property containing an invalid schema.
-->echo # 43. Mismatch "dependencies" property type.
-->echo # 44. "dependencies" properties containing an invalid schema.
-->echo # 45. "dependencies" properties containing an empty array.
-->echo # 46. "dependencies" properties containing an array of invalid types.
-->echo # 47. "dependencies" properties containing an array of a non-unique types.
-->echo # 48. Mismatch "enum" property type.
-->echo # 49. Empty "enum" properties array.
-->echo # 50. Non-unique values in the "enum" property array.
-->echo # 51. Mismatch "type" property type.
-->echo # 52. Invalid type in "type" properties array.
-->echo # 53. Empty "type" properties array.
-->echo # 54. Non-unique "type" properties array.
-->echo # 55. Mismatch "format" property type.
-->echo # 56. Mismatch "allOf" property type.
-->echo # 57. Empty "allOf" properties array.
-->echo # 58. Invalid schema in the "allOf" properties array.
-->echo # 59. Mismatch "anyOf" property type.
-->echo # 60. Empty "anyOf" properties array.
-->echo # 61. Invalid schema in the "anyOf" properties array.
-->echo # 62. Mismatch "oneOf" property type.
-->echo # 63. Empty "oneOf" properties array.
-->echo # 64. Invalid schema in the "oneOf" properties array.
-->echo # 65. Invalid schema as the "not" property value.

-->echo
-->echo #
-->echo # I.1
-->callmacro Assert_invalid_schema	{"unknown": 1}
-->callmacro Assert_invalid_schema	"{\"unknown\": 1}"

-->echo
-->echo #
-->echo # I.2
-->callmacro Assert_invalid_schema	{"id": 2}
-->callmacro Assert_invalid_schema	"{\"id\": 2}"

-->echo
-->echo #
-->echo # I.3
-->callmacro Assert_invalid_schema	{"$schema": 3}
-->callmacro Assert_invalid_schema	"{\"$schema\": 3}"

-->echo
-->echo #
-->echo # I.4
-->callmacro Assert_invalid_schema	{"title": 4}
-->callmacro Assert_invalid_schema	"{\"title\": 4}"

-->echo
-->echo #
-->echo # I.5
-->callmacro Assert_invalid_schema	{"description": 5}
-->callmacro Assert_invalid_schema	"{\"description\": 5}"

-->echo
-->echo #
-->echo # I.6
-->callmacro Assert_invalid_schema	{"multipleOf": "five"}
-->callmacro Assert_invalid_schema	"{\"multipleOf\": \"five\"}"

-->echo
-->echo #
-->echo # I.7
-->callmacro Assert_invalid_schema	{"multipleOf": -1}
-->callmacro Assert_invalid_schema	"{\"multipleOf\": -1}"

-->echo
-->echo #
-->echo # I.8
-->callmacro Assert_invalid_schema	{"maximum": "one"}
-->callmacro Assert_invalid_schema	"{\"maximum\": \"one\"}"

-->echo
-->echo #
-->echo # I.9
-->callmacro Assert_invalid_schema	{"exclusiveMaximum": 0}
-->callmacro Assert_invalid_schema	"{\"exclusiveMaximum\": 0}"

-->echo
-->echo #
-->echo # I.10
-->callmacro Assert_invalid_schema	{"minimum": "zero"}
-->callmacro Assert_invalid_schema	"{\"minimum\": \"zero\"}"

-->echo
-->echo #
-->echo # I.11
-->callmacro Assert_invalid_schema	{"exclusiveMinimum": 0}
-->callmacro Assert_invalid_schema	"{\"exclusiveMinimum\": 0}"

-->echo
-->echo #
-->echo # I.12
-->callmacro Assert_invalid_schema	{"maxLength": "ten"}
-->callmacro Assert_invalid_schema	"{\"maxLength\": \"ten\"}"

-->echo
-->echo #
-->echo # I.13
-->callmacro Assert_invalid_schema	{"maxLength": -100}
-->callmacro Assert_invalid_schema	"{\"maxLength\": -100}"

-->echo
-->echo #
-->echo # I.14
-->callmacro Assert_invalid_schema	{"minLength": "ten"}
-->callmacro Assert_invalid_schema	"{\"minLength\": \"ten\"}"

-->echo
-->echo #
-->echo # I.15
-->callmacro Assert_invalid_schema	{"minLength": -10}
-->callmacro Assert_invalid_schema	"{\"minLength\": -10}"

-->echo
-->echo #
-->echo # I.16
-->callmacro Assert_invalid_schema	{"pattern": 0}
-->callmacro Assert_invalid_schema	"{\"pattern\": 0}"

-->echo
-->echo #
-->echo # I.17
-->callmacro Assert_invalid_schema	{"additionalItems": 0}
-->callmacro Assert_invalid_schema	"{\"additionalItems\": 0}"

-->echo
-->echo #
-->echo # I.18
-->callmacro Assert_invalid_schema	{"additionalItems": {"unknown": 0}}
-->callmacro Assert_invalid_schema	"{\"additionalItems\": {\"unknown\": 0}}"

-->echo
-->echo #
-->echo # I.19
-->callmacro Assert_invalid_schema	{"items": []}
-->callmacro Assert_invalid_schema	"{\"items\": []}"

-->echo
-->echo #
-->echo # I.20
-->callmacro Assert_invalid_schema	{"items": {"unknown": "foo"}}
-->callmacro Assert_invalid_schema	"{\"items\": {\"unknown\": \"foo\"}}"

-->echo
-->echo #
-->echo # I.21
-->callmacro Assert_invalid_schema	{"items": [{"unknown": "foo"}]}
-->callmacro Assert_invalid_schema	"{\"items\": [{\"unknown\": \"foo\"}]}"

-->echo
-->echo #
-->echo # I.22
-->callmacro Assert_invalid_schema	{"maxItems": "ten"}
-->callmacro Assert_invalid_schema	"{\"maxItems\": \"ten\"}"

-->echo
-->echo #
-->echo # I.23
-->callmacro Assert_invalid_schema	{"maxItems": -100}
-->callmacro Assert_invalid_schema	"{\"maxItems\": -100}"

-->echo
-->echo #
-->echo # I.24
-->callmacro Assert_invalid_schema	{"minItems": "ten"}
-->callmacro Assert_invalid_schema	"{\"minItems\": \"ten\"}"

-->echo
-->echo #
-->echo # I.25
-->callmacro Assert_invalid_schema	{"minItems": -10}
-->callmacro Assert_invalid_schema	"{\"minItems\": -10}"

-->echo
-->echo #
-->echo # I.26
-->callmacro Assert_invalid_schema	{"uniqueItems": 1}
-->callmacro Assert_invalid_schema	"{\"uniqueItems\": 1}"

-->echo
-->echo #
-->echo # I.27
-->callmacro Assert_invalid_schema	{"maxProperties": "two"}
-->callmacro Assert_invalid_schema	"{\"maxProperties\": \"two\"}"

-->echo
-->echo #
-->echo # I.28
-->callmacro Assert_invalid_schema	{"maxProperties": -2}
-->callmacro Assert_invalid_schema	"{\"maxProperties\": -2}"

-->echo
-->echo #
-->echo # I.29
-->callmacro Assert_invalid_schema	{"minProperties": "six"}
-->callmacro Assert_invalid_schema	"{\"minProperties\": \"six\"}"

-->echo
-->echo #
-->echo # I.30
-->callmacro Assert_invalid_schema	{"minProperties": -10000}
-->callmacro Assert_invalid_schema	"{\"minProperties\": -10000}"

-->echo
-->echo #
-->echo # I.31
-->callmacro Assert_invalid_schema	{"required": "true"}
-->callmacro Assert_invalid_schema	"{\"required\": \"true\"}"

-->echo
-->echo #
-->echo # I.32
-->callmacro Assert_invalid_schema	{"required": []}
-->callmacro Assert_invalid_schema	"{\"required\": []}"

-->echo
-->echo #
-->echo # I.33
-->callmacro Assert_invalid_schema	{"required": [1, 2, "valid"]}
-->callmacro Assert_invalid_schema	"{\"required\": [1, 2, \"valid\"]}"

-->echo
-->echo #
-->echo # I.34
-->callmacro Assert_invalid_schema	{"required": ["foo", "foo", "bar"]}
-->callmacro Assert_invalid_schema	"{\"required\": [\"foo\", \"foo\", \"bar\"]}"

-->echo
-->echo #
-->echo # I.35
-->callmacro Assert_invalid_schema	{"additionalProperties": 0}
-->callmacro Assert_invalid_schema	"{\"additionalProperties\": 0}"

-->echo
-->echo #
-->echo # I.36
-->callmacro Assert_invalid_schema	{"additionalProperties": {"unknown": 0}}
-->callmacro Assert_invalid_schema	"{\"additionalProperties\": {\"unknown\": 0}}"

-->echo
-->echo #
-->echo # I.37
-->callmacro Assert_invalid_schema	{"definitions": true}
-->callmacro Assert_invalid_schema	"{\"definitions\": true}"

-->echo
-->echo #
-->echo # I.38
-->callmacro Assert_invalid_schema	{"definitions": {"def": {"invalid": "bar"}}}
-->callmacro Assert_invalid_schema	"{\"definitions\": {\"def\": {\"invalid\": \"bar\"}}}"

-->echo
-->echo #
-->echo # I.39
-->callmacro Assert_invalid_schema	{"properties": true}
-->callmacro Assert_invalid_schema	"{\"properties\": true}"

-->echo
-->echo #
-->echo # I.40
-->callmacro Assert_invalid_schema	{"properties": {"def": {"invalid": "bar"}}}
-->callmacro Assert_invalid_schema	"{\"properties\": {\"def\": {\"invalid\": \"bar\"}}}"

-->echo
-->echo #
-->echo # I.41
-->callmacro Assert_invalid_schema	{"patternProperties": true}
-->callmacro Assert_invalid_schema	"{\"patternProperties\": true}"

-->echo
-->echo #
-->echo # I.42
-->callmacro Assert_invalid_schema	{"patternProperties": {"def": {"invalid": "bar"}}}
-->callmacro Assert_invalid_schema	"{\"patternProperties\": {\"def\": {\"invalid\": \"bar\"}}}"

-->echo
-->echo #
-->echo # I.43
-->callmacro Assert_invalid_schema	{"dependencies": "baz"}
-->callmacro Assert_invalid_schema	"{\"dependencies\": \"baz\"}"

-->echo
-->echo #
-->echo # I.44
-->callmacro Assert_invalid_schema	{"dependencies": {"unknown": "x"}}
-->callmacro Assert_invalid_schema	"{\"dependencies\": {\"unknown\": \"x\"}}"

-->echo
-->echo #
-->echo # I.45
-->callmacro Assert_invalid_schema	{"dependencies": []}
-->callmacro Assert_invalid_schema	"{\"dependencies\": []}"

-->echo
-->echo #
-->echo # I.46
-->callmacro Assert_invalid_schema	{"dependencies": [1, 2, "three"]}
-->callmacro Assert_invalid_schema	"{\"dependencies\": [1, 2, \"three\"]}"

-->echo
-->echo #
-->echo # I.47
-->callmacro Assert_invalid_schema	{"dependencies": ["one", "two", "one"]}
-->callmacro Assert_invalid_schema	"{\"dependencies\": [\"one\", \"two\", \"one\"]}"

-->echo
-->echo #
-->echo # I.48
-->callmacro Assert_invalid_schema	{"enum": "invalid"}
-->callmacro Assert_invalid_schema	"{\"enum\": \"invalid\"}"

-->echo
-->echo #
-->echo # I.49
-->callmacro Assert_invalid_schema	{"enum": []}
-->callmacro Assert_invalid_schema	"{\"enum\": []}"

-->echo
-->echo #
-->echo # I.50
-->callmacro Assert_invalid_schema	{"enum": [1, 1, 2]}
-->callmacro Assert_invalid_schema	"{\"enum\": [1, 1, 2]}"

-->echo
-->echo #
-->echo # I.51
-->callmacro Assert_invalid_schema	{"type": {"complex": "type"}}
-->callmacro Assert_invalid_schema	"{\"type\": {\"complex\": \"type\"}}"

-->echo
-->echo #
-->echo # I.52
-->callmacro Assert_invalid_schema	{"type": [{"complex": "type"}]}
-->callmacro Assert_invalid_schema	"{\"type\": [{\"complex\": \"type\"}]}"

-->echo
-->echo #
-->echo # I.53
-->callmacro Assert_invalid_schema	{"type": []}
-->callmacro Assert_invalid_schema	"{\"type\": []}"

-->echo
-->echo #
-->echo # I.54
-->callmacro Assert_invalid_schema	{"type": [1, 2, 3, 2]}
-->callmacro Assert_invalid_schema	"{\"type\": [1, 2, 3, 2]}"

-->echo
-->echo #
-->echo # I.55
-->callmacro Assert_invalid_schema	{"format": {"not": "supported"}}
-->callmacro Assert_invalid_schema	"{\"format\": {\"not\": \"supported\"}}"

-->echo
-->echo #
-->echo # I.56
-->callmacro Assert_invalid_schema	{"allOf": 5}
-->callmacro Assert_invalid_schema	"{\"allOf\": 5}"

-->echo
-->echo #
-->echo # I.57
-->callmacro Assert_invalid_schema	{"allOf": []}
-->callmacro Assert_invalid_schema	"{\"allOf\": []}"

-->echo
-->echo #
-->echo # I.58
-->callmacro Assert_invalid_schema	{"allOf": [{"unknown": "x"}]}
-->callmacro Assert_invalid_schema	"{\"allOf\": [{\"unknown\": \"x\"}]}"

-->echo
-->echo #
-->echo # I.59
-->callmacro Assert_invalid_schema	{"anyOf": true}
-->callmacro Assert_invalid_schema	"{\"anyOf\": true}"

-->echo
-->echo #
-->echo # I.60
-->callmacro Assert_invalid_schema	{"anyOf": []}
-->callmacro Assert_invalid_schema	"{\"anyOf\": []}"

-->echo
-->echo #
-->echo # I.61
-->callmacro Assert_invalid_schema	{"anyOf": [{"unknown": "y"}]}
-->callmacro Assert_invalid_schema	"{\"anyOf\": [{\"unknown\": \"y\"}]}"

-->echo
-->echo #
-->echo # I.62
-->callmacro Assert_invalid_schema	{"oneOf": "aaa"}
-->callmacro Assert_invalid_schema	"{\"oneOf\": \"aaa\"}"

-->echo
-->echo #
-->echo # I.63
-->callmacro Assert_invalid_schema	{"oneOf": []}
-->callmacro Assert_invalid_schema	"{\"oneOf\": []}"

-->echo
-->echo #
-->echo # I.64
-->callmacro Assert_invalid_schema	{"oneOf": [{"unknown": "z"}]}
-->callmacro Assert_invalid_schema	"{\"oneOf\": [{\"unknown\": \"z\"}]}"

-->echo
-->echo #
-->echo # I.65
-->callmacro Assert_invalid_schema	{"not": [{"unknown": "foo"}]}
-->callmacro Assert_invalid_schema	"{\"not\": [{\"unknown\": \"foo\"}]}"

EOF

exec $MYSQLXTEST -ux_root --password=''
  --file=$xtest_file -v%COMMAND%=create_collection 2>&1;

exec $MYSQLXTEST -ux_root --password=''
  --file=$xtest_file -v%COMMAND%=ensure_collection 2>&1;

exec $MYSQLXTEST -ux_root --password=''
  --file=$xtest_file -v%COMMAND%=modify_collection_options 2>&1;

## Cleanup
--source ../include/xplugin_cleanup.inc