## Test validation errors when doing operations on collections ## Preamble --source include/xplugin_preamble.inc --source include/xplugin_create_user.inc ## Tests start here create schema xtest; --let $xtest_file= $MYSQL_TMP_DIR/validation_errors.xpl --write_file $xtest_file -->import validation_schema.macro -->quiet varlet %BASE_SCHEMA% {"type": "object", "properties": {"size": {"type": "number", "minimum": 0, "maximum": 1000}}, "required": ["size"]}; -->macro Create_and_fill_test_collection -->callmacro Create_coll_with_validation test_coll %BASE_SCHEMA% strict -->callmacro Insert_value_to_collection test_coll '{"_id": "one", "size": 10}' -->recvresult -->callmacro Insert_value_to_collection test_coll '{"_id": "two", "size": 20}' -->recvresult -->callmacro Insert_value_to_collection test_coll '{"_id": "three", "size": 30}' -->recvresult -->endmacro -->macro Assert_validation_error %REQUIREMENT% recvmessage Mysqlx.Error { severity: ERROR code: 5180 msg: "Document is not valid according to the schema assigned to collection. The JSON document location \'#/size\' failed requirement \'%REQUIREMENT%\' at JSON Schema location \'#/properties/size\'." sql_state: "HY000" }; -->endmacro -->echo -->echo -->echo ## I. Check validation errors on collection insert. -->echo # -->echo # 1. Insert one invalid value to an empty collection. -->echo # 2. Insert one invalid value to a non-empty collection. -->echo # 3. Insert multiple values where one is invalid. -->echo # 4. Insert multiple invalid values. -->echo -->echo ## II. Check validation errors on collection update. -->echo # 1. Update one element in a collection. -->echo # 2. Update multiple elements in a collection. -->echo -->echo ## III. Check validation errors on schema enable. -->echo # 1. Enable schema for collection with one element not matching the -->echo # schema. -->echo # 2. Enable schema for collection with multiple elements not matching -->echo # the schema. -->echo -->echo ## IV. Check validation errors on schema update. -->echo # 1. Update schema for collection with one element not matching the -->echo # new schema. -->echo # 2. Update schema for collection with multiple elements not matching -->echo # the new schema. -->echo -->echo # -->echo # I.1 -->callmacro Create_coll_with_validation test_coll %BASE_SCHEMA% strict -->callmacro Insert_value_to_collection test_coll '{"_id": "one", "size": 1234}' -->callmacro Assert_validation_error maximum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # I.2 -->callmacro Create_and_fill_test_collection -->callmacro Insert_value_to_collection test_coll '{"_id": "four", "size": -1}' -->callmacro Assert_validation_error minimum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # I.3 -->callmacro Create_coll_with_validation test_coll %BASE_SCHEMA% strict Mysqlx.Crud.Insert { collection { name: "test_coll" schema: "xtest" } data_model: DOCUMENT row { field { type: LITERAL literal { type: V_STRING v_string { value: '{"_id": "one", "size": 34}' } } } } row { field { type: LITERAL literal { type: V_STRING v_string { value: '{"_id": "two", "size": 72}' } } } } row { field { type: LITERAL literal { type: V_STRING v_string { value: '{"_id": "x", "size": -2}' } } } } row { field { type: LITERAL literal { type: V_STRING v_string { value: '{"_id": "four", "size": 172}' } } } } } -->callmacro Assert_validation_error minimum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # I.4 -->callmacro Create_coll_with_validation test_coll %BASE_SCHEMA% strict Mysqlx.Crud.Insert { collection { name: "test_coll" schema: "xtest" } data_model: DOCUMENT row { field { type: LITERAL literal { type: V_STRING v_string { value: '{"_id": "one", "size": 34}' } } } } row { field { type: LITERAL literal { type: V_STRING v_string { value: '{"_id": "x", "size": 1072}' } } } } row { field { type: LITERAL literal { type: V_STRING v_string { value: '{"_id": "y", "size": -2}' } } } } row { field { type: LITERAL literal { type: V_STRING v_string { value: '{"_id": "z", "size": 1072}' } } } } } -->callmacro Assert_validation_error maximum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # II.1 -->callmacro Create_and_fill_test_collection callmacro Update_item test_coll size {type: V_SINT v_signed_int: 20} {type: V_SINT v_signed_int: -20}; -->callmacro Assert_validation_error minimum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # II.2 -->callmacro Create_and_fill_test_collection Mysqlx.Crud.Update { collection { name: "test_coll" schema: "xtest"} data_model: DOCUMENT criteria { type: OPERATOR operator { name: ">" param { type: IDENT identifier { document_path { type: MEMBER value: "size" } } } param { type: LITERAL literal {type: V_SINT v_signed_int: 0} } } } operation { source { document_path {type: MEMBER value: 'size'} } operation: ITEM_SET value: { type: LITERAL literal {type: V_SINT v_signed_int: -1} } } } -->callmacro Assert_validation_error minimum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # III.1 -->callmacro Create_coll_with_validation test_coll %BASE_SCHEMA% off -->callmacro Insert_value_to_collection test_coll '{"_id": "one", "size": 10}' -->recvresult -->callmacro Insert_value_to_collection test_coll '{"_id": "two", "size": -1}' -->recvresult -->callmacro Insert_value_to_collection test_coll '{"_id": "three", "size": 30}' -->recvresult -->callmacro Modify_level test_coll strict -->callmacro Assert_validation_error minimum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # III.2 -->callmacro Create_coll_with_validation test_coll %BASE_SCHEMA% off -->callmacro Insert_value_to_collection test_coll '{"_id": "one", "size": 1200}' -->recvresult -->callmacro Insert_value_to_collection test_coll '{"_id": "two", "size": -1}' -->recvresult -->callmacro Insert_value_to_collection test_coll '{"_id": "three", "size": -1}' -->recvresult -->callmacro Modify_level test_coll strict -->callmacro Assert_validation_error maximum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # IV.1 -->callmacro Create_and_fill_test_collection varlet %SCHEMA% {"type": "object", "properties": {"size": {"type": "number", "minimum": 25, "maximum": 1000}}, "required": ["size"]}; stmtadmin modify_collection_options {"schema": "xtest", "name": "test_coll", "options": { "validation": { "schema": %SCHEMA%, "level": "strict" } } }; -->callmacro Assert_validation_error minimum -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # IV.2 -->callmacro Create_and_fill_test_collection varlet %SCHEMA% {"type": "object", "properties": {"size": {"type": "number", "minimum": 100, "maximum": 1000}}, "required": ["size"]}; stmtadmin modify_collection_options {"schema": "xtest", "name": "test_coll", "options": { "validation": { "schema": %SCHEMA%, "level": "strict" } } }; -->callmacro Assert_validation_error minimum -->callmacro Drop_collection test_coll -->noquiet EOF --exec $MYSQLXTEST -ux_root --password='' --file=$xtest_file 2>&1 ## Cleanup --source ../include/xplugin_cleanup.inc