## Test of general functionality of create_collection 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 varlet %SIMPLE_SCHEMA% type:SCALAR scalar{ type:V_STRING v_string{value: "{\"type\":\"object\"}"}}; varlet %SCHEMA% type:SCALAR scalar{ type:V_STRING v_string{value: "{\"type\": \"object\", \"properties\": {\"latitude\": {\"type\": \"number\", \"minimum\": -90, \"maximum\": 90}}, \"required\": [\"latitude\"]}"}}; -->echo -->echo -->echo ## Check command flow when using a create_collection or -->echo ## ensure_collection admin commands. -->echo # -->echo # 1. Create valid collection. -->echo # 2. Create collection and insert valid value. -->echo # 3. Create collection and insert invalid value. -->echo # 4. Create collection, insert valid value and update to valid value. -->echo # 5. Create collection, insert valid value and update to invalid value. -->echo # 6. Create collection which is already created in the system. -->echo # a) use create_collection command -->echo # b) use ensure_collection command -->echo -->echo # -->echo # -.1 callmacro Execute_admin_cmd_with_validation %COMMAND% test_coll %SIMPLE_SCHEMA% "strict"; -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # -.2 callmacro Execute_admin_cmd_with_validation %COMMAND% 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 Drop_collection test_coll -->echo -->echo # -->echo # -.3 callmacro Execute_admin_cmd_with_validation %COMMAND% test_coll %SCHEMA% "strict"; -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk -->callmacro Insert_value_to_collection test_coll '{"_id": "one", "latitude": 97}' -->callmacro Assert_message Mysqlx.Error -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # -.4 callmacro Execute_admin_cmd_with_validation %COMMAND% 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 Update_item test_coll latitude {type: V_SINT v_signed_int: 82} {type: V_SINT v_signed_int: 80}; -->callmacro Assert_notice_session_state PRODUCED_MESSAGE type: V_STRING -->callmacro Assert_notice_session_state ROWS_AFFECTED v_unsigned_int:1 -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # -.5 callmacro Execute_admin_cmd_with_validation %COMMAND% 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 Update_item test_coll latitude {type: V_SINT v_signed_int: 82} {type: V_SINT v_signed_int: 123}; -->callmacro Assert_message Mysqlx.Error -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # -.6.a callmacro Execute_admin_cmd_with_validation create_collection test_coll %SCHEMA% "strict"; -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk callmacro Execute_admin_cmd_with_validation create_collection test_coll %SCHEMA% "strict"; -->callmacro Assert_message Mysqlx.Error -->callmacro Drop_collection test_coll -->echo -->echo # -->echo # -.6.b callmacro Execute_admin_cmd_with_validation create_collection test_coll %SCHEMA% "strict"; -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk callmacro Execute_admin_cmd_with_validation ensure_collection test_coll %SCHEMA% "strict"; -->callmacro Assert_message Mysqlx.Sql.StmtExecuteOk -->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 -v%COMMAND%=create_collection 2>&1; exec $MYSQLXTEST -ux_root --password='' --schema=xtest --file=$MYSQL_TMP_DIR/resultset.xpl -v%COMMAND%=ensure_collection 2>&1; ## Cleanup --source ../include/xplugin_cleanup.inc