## Test of general functionality of modify_collection_options admin command. ## Preamble --source include/xplugin_preamble.inc --source include/xplugin_create_user.inc ## Test starts here --write_file $MYSQL_TMP_DIR/resultset.xpl -->import assert_messages.macro -->import assert_notices.macro -->import validation_schema.macro -->macro Create_base_collection varlet %SCHEMA% type:SCALAR scalar{ type:V_STRING v_string{value: "{\"type\": \"object\", \"properties\": {\"latitude\": {\"type\": \"number\", \"minimum\": -90, \"maximum\": 90}}, \"required\": [\"latitude\"]}"}}; -->callmacro Execute_admin_cmd_with_validation create_collection test_coll %SCHEMA% "strict" -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk -->callmacro Insert_value_to_collection test_coll '{"_id": "one", "latitude": 82}' -->callmacro Assert_notice_session_state ROWS_AFFECTED v_unsigned_int:1 -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk -->callmacro Insert_value_to_collection test_coll '{"_id": "two", "latitude": 49}' -->callmacro Assert_notice_session_state ROWS_AFFECTED v_unsigned_int:1 -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk -->endmacro -->varlet %COMMAND% modify_collection_options -->echo -->echo -->echo ## I. Check command flow when using a modify_collection_options admin -->echo ## command. -->echo # -->echo # 1. Modify existing schema with other valid schema. -->echo # 2. Modify existing schema with schema that does not match to existing -->echo # collection content. -->echo -->echo # -->echo # I.1 -->callmacro Create_base_collection varlet %NEW_SCHEMA% type:SCALAR scalar{ type:V_STRING v_string{value: "{\"type\": \"object\", \"properties\": {\"latitude\": {\"type\": \"number\", \"minimum\": -90, \"maximum\": 100}}, \"required\": [\"latitude\"]}"}}; callmacro Execute_admin_cmd_with_validation %COMMAND% test_coll %NEW_SCHEMA% "strict"; -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # I.2 -->callmacro Create_base_collection varlet %NEW_SCHEMA% type:SCALAR scalar{ type:V_STRING v_string{value: "{\"type\": \"object\", \"properties\": {\"latitude\": {\"type\": \"number\", \"minimum\": -90, \"maximum\": 50}}, \"required\": [\"latitude\"]}"}}; callmacro Execute_admin_cmd_with_validation %COMMAND% test_coll %NEW_SCHEMA% "strict"; -->callmacro Assert_message Mysqlx.Error -->callmacro Drop_collection test_coll EOF CREATE SCHEMA IF NOT EXISTS xtest; USE xtest; exec $MYSQLXTEST -ux_root --password='' --schema=xtest --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1; ## Cleanup --source ../include/xplugin_cleanup.inc