--write_file $MYSQL_TMP_DIR/resultset.xpl -->import assert_messages.macro -->import assert_notices.macro -->import crud_insert.macro -->echo -->echo -->echo ## Test setup -->macro Insert_doc %COLL% %DOC% callmacro Insert_one DOCUMENT %COLL% type: LITERAL literal{type: V_OCTETS v_octets{value:%DOC% content_type:2}} ER_SUCCESS; -->endmacro DROP TABLE IF EXISTS xtest.coll; stmtadmin create_collection {"schema":"xtest","name":"coll"}; recvresult; callmacro Insert_doc coll '{"_id": "1", "name":"first", "prio":1}'; callmacro Insert_doc coll '{"_id": "2", "name":"second", "prio":2}'; callmacro Insert_doc coll '{"_id": "3", "name":"third", "prio":1}'; callmacro Insert_doc coll '{"_id": "5", "name":"fifth", "prio":4}'; ## ## Purpose of this test is: # # * validating that resultsets are in align to the UML flow: # # ... # loop has more resultsets or not at end of fetch # group resultset # loop has more columns # server --> client: ColumnMetaData # end # loop has more rows # server --> client: Row # end # end # alt has more resultsets # server --> client: FetchDoneMoreResultsets # end # end # loop has more OUT-paramsets or not at end of fetch # server --> client: FetchDoneMoreOutParams # group resultset # loop has more columns # server --> client: ColumnMetaData # end # loop has more rows # server --> client: Row # end # end # end # alt at end of all resultsets # server --> client: FetchDone # else cursor is opened # server --> client: FetchSuspended # end # ... # # * expecting following notices for CRUD operations on collection: # # |Notice\Stmt |Select |Insert |Update |Delete | # |-----------------------|-------|-------|-------|-------| # |ROWS_AFFECTED |X(0) |X |X |X | # |PRODUCED_MESSAGE | | |X | | # |GENERATED_INSERT_ID | | | | | # |GENERATED_DOCUMENT_IDS | |X | | | # -->echo -->echo -->echo ## I. Validate simple resultsets for CRUD messages -->echo # -->echo # 1. Assert resultset for CRUD-delete message -->echo # 2. Assert resultset for CRUD-update message -->echo # 3. Assert resultset for CRUD-create message (doc with id) -->echo # 4. Assert resultset for CRUD-create message (doc without id) -->echo # 5. Assert resultset for CRUD-read message -->echo -->echo ## II. Validate simple resultset with warnings -->echo # -->echo # 1. Assert one resultsets for select queries -->echo -->echo # -->echo # I.1 Mysqlx.Prepare.Prepare { stmt_id: 1 stmt: { type: DELETE delete { collection { name: "coll" } data_model: DOCUMENT criteria { type: OPERATOR operator { name: "==" param { type: IDENT identifier { document_path { type: MEMBER value: "name" } } } param { type: LITERAL literal { type: V_OCTETS v_octets { value: "fifth" } } } } } } } } recvok; Mysqlx.Prepare.Execute { stmt_id: 1 } callmacro Assert_notice_session_state ROWS_AFFECTED v_unsigned_int:1; callmacro Assert_message Mysqlx.Sql.StmtExecuteOk; -->echo -->echo # -->echo # I.2 Mysqlx.Prepare.Prepare { stmt_id: 2 stmt: { type: UPDATE update { collection { name: "coll" } data_model: DOCUMENT operation { source { document_path { type: MEMBER value: "prio" } } operation: ITEM_SET value { type: OPERATOR operator { name: "-" param { type: IDENT identifier { document_path { type: MEMBER value: "prio" } } } param { type: LITERAL literal { type: V_SINT v_signed_int: 1 } } } } } } } } recvok; Mysqlx.Prepare.Execute { stmt_id: 2 } callmacro Assert_notice_session_state PRODUCED_MESSAGE type: V_STRING; callmacro Assert_notice_session_state ROWS_AFFECTED v_unsigned_int:3; callmacro Assert_message Mysqlx.Sql.StmtExecuteOk; -->echo -->echo # -->echo # I.3 Mysqlx.Prepare.Prepare { stmt_id: 3 stmt: { type: INSERT insert { collection { name: "coll" schema: "xtest" } data_model: DOCUMENT row { field { type: LITERAL literal { type: V_OCTETS v_octets { value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}" content_type: 2 } } } } upsert: false } } } recvok; Mysqlx.Prepare.Execute { stmt_id: 3 } callmacro Assert_notice_session_state ROWS_AFFECTED v_unsigned_int:1; callmacro Assert_message Mysqlx.Sql.StmtExecuteOk; -->echo -->echo # -->echo # I.4 Mysqlx.Prepare.Prepare { stmt_id: 4 stmt: { type: INSERT insert { collection { name: "coll" schema: "xtest" } data_model: DOCUMENT row { field { type: LITERAL literal { type: V_OCTETS v_octets { value: "{\"name\":\"sixth\", \"prio\":3}" content_type: 2 } } } } upsert: false } } } recvok; Mysqlx.Prepare.Execute { stmt_id: 4 } callmacro Assert_notice_session_state ROWS_AFFECTED v_unsigned_int:1; callmacro Assert_notice_session_state GENERATED_DOCUMENT_IDS type: V_OCTETS; callmacro Assert_message Mysqlx.Sql.StmtExecuteOk; -->echo -->echo # -->echo # I.5 Mysqlx.Prepare.Prepare { stmt_id: 5 stmt: { type: FIND find { collection { name: "coll" } data_model: DOCUMENT projection { alias:"name" source { type: IDENT identifier { document_path { type: MEMBER value: "name" } } } } } } } recvok; Mysqlx.Prepare.Execute { stmt_id: 5 } callmacro Assert_metadata BYTES "doc"; callmacro Assert_rows 5; callmacro Assert_message Mysqlx.Resultset.FetchDone; callmacro Assert_message Mysqlx.Sql.StmtExecuteOk; -->echo -->echo # -->echo # II.1 Mysqlx.Prepare.Prepare { stmt_id: 6 stmt: { type: FIND find { collection { name: "coll" } data_model: DOCUMENT projection { alias:"name" source { type: OPERATOR operator { name: "/" param { type: LITERAL literal { type: V_SINT v_signed_int: 1 } } param { type: IDENT identifier { document_path { type: MEMBER value: "prio" } } } } } } } } } recvok; Mysqlx.Prepare.Execute { stmt_id: 6 } callmacro Assert_metadata BYTES "doc"; callmacro Assert_rows 5; callmacro Assert_message Mysqlx.Resultset.FetchDone; ## ER_DIVISION_BY_ZERO == 1365 callmacro Assert_notice_warning WARNING 1365; callmacro Assert_notice_warning WARNING 1365; callmacro Assert_message Mysqlx.Sql.StmtExecuteOk; EOF CREATE SCHEMA IF NOT EXISTS xtest; USE xtest;