59 lines
2.0 KiB
Plaintext
59 lines
2.0 KiB
Plaintext
## Following macros are defined in this file:
|
|
#
|
|
# * Assert_status_variable
|
|
# * Assert_received_notices
|
|
# * Assert_global_variable
|
|
# * Assert_session_variable
|
|
# * Assert_user_variable
|
|
#
|
|
|
|
|
|
-->macro Assert_status_variable %VARIABLE_NAME% %EXPECTED_VALUE%
|
|
-->stmtsql SHOW STATUS LIKE '%VARIABLE_NAME%';
|
|
-->recvtovar %VARIABLE_VALUE% Value
|
|
-->echo Verify [Status variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
|
|
-->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
|
|
-->endmacro
|
|
|
|
|
|
-->macro Assert_received_notices
|
|
-->received Mysqlx.Notice.ServerHello %MYSQLXTEST_NO_OF_SERVER_HELLOS%
|
|
-->received Mysqlx.Notice.Warning %MYSQLXTEST_NO_OF_WARNINGS%
|
|
-->callmacro Assert_status_variable Mysqlx_notice_warning_sent %MYSQLXTEST_NO_OF_WARNINGS%
|
|
-->received Mysqlx.Notice.Frame %MYSQLXTEST_NO_OF_OTHER%
|
|
-->varinc %MYSQLXTEST_NO_OF_OTHER% -%MYSQLXTEST_NO_OF_WARNINGS%
|
|
-->varinc %MYSQLXTEST_NO_OF_OTHER% -%MYSQLXTEST_NO_OF_SERVER_HELLOS%
|
|
-->callmacro Assert_status_variable Mysqlx_notice_other_sent %MYSQLXTEST_NO_OF_OTHER%
|
|
-->endmacro
|
|
|
|
|
|
-->macro Assert_global_variable %VARIABLE_NAME% %EXPECTED_VALUE%
|
|
-->quiet
|
|
-->stmtsql SHOW GLOBAL VARIABLES LIKE '%VARIABLE_NAME%';
|
|
-->recvtovar %VARIABLE_VALUE% Value
|
|
-->echo Verify [Global variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
|
|
-->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
|
|
-->noquiet
|
|
-->endmacro
|
|
|
|
|
|
-->macro Assert_session_variable %VARIABLE_NAME% %EXPECTED_VALUE%
|
|
-->quiet
|
|
-->stmtsql SELECT @@%VARIABLE_NAME% as Value;
|
|
-->recvtovar %VARIABLE_VALUE% Value
|
|
-->echo Verify [Session variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
|
|
-->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
|
|
-->noquiet
|
|
-->endmacro
|
|
|
|
|
|
-->macro Assert_user_variable %VARIABLE_NAME% %EXPECTED_VALUE%
|
|
-->quiet
|
|
-->stmtsql SELECT @%VARIABLE_NAME% as Value;
|
|
-->recvtovar %VARIABLE_VALUE% Value
|
|
-->echo Verify [User variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
|
|
-->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
|
|
-->noquiet
|
|
-->endmacro
|
|
|