Debian Codegraph @

mysql-test/suite/x/t/macros/assert_variable.macro

raw
1 ## Following macros are defined in this file:
2 #
3 # * Assert_status_variable
4 # * Assert_received_notices
5 # * Assert_global_variable
6 # * Assert_session_variable
7 # * Assert_user_variable
8 #
9
10
11 -->macro Assert_status_variable %VARIABLE_NAME% %EXPECTED_VALUE%
12 -->stmtsql SHOW STATUS LIKE '%VARIABLE_NAME%';
13 -->recvtovar %VARIABLE_VALUE% Value
14 -->echo Verify [Status variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
15 -->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
16 -->endmacro
17
18
19 -->macro Assert_received_notices
20 -->received Mysqlx.Notice.ServerHello %MYSQLXTEST_NO_OF_SERVER_HELLOS%
21 -->received Mysqlx.Notice.Warning %MYSQLXTEST_NO_OF_WARNINGS%
22 -->callmacro Assert_status_variable Mysqlx_notice_warning_sent %MYSQLXTEST_NO_OF_WARNINGS%
23 -->received Mysqlx.Notice.Frame %MYSQLXTEST_NO_OF_OTHER%
24 -->varinc %MYSQLXTEST_NO_OF_OTHER% -%MYSQLXTEST_NO_OF_WARNINGS%
25 -->varinc %MYSQLXTEST_NO_OF_OTHER% -%MYSQLXTEST_NO_OF_SERVER_HELLOS%
26 -->callmacro Assert_status_variable Mysqlx_notice_other_sent %MYSQLXTEST_NO_OF_OTHER%
27 -->endmacro
28
29
30 -->macro Assert_global_variable %VARIABLE_NAME% %EXPECTED_VALUE%
31 -->quiet
32 -->stmtsql SHOW GLOBAL VARIABLES LIKE '%VARIABLE_NAME%';
33 -->recvtovar %VARIABLE_VALUE% Value
34 -->echo Verify [Global variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
35 -->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
36 -->noquiet
37 -->endmacro
38
39
40 -->macro Assert_session_variable %VARIABLE_NAME% %EXPECTED_VALUE%
41 -->quiet
42 -->stmtsql SELECT @@%VARIABLE_NAME% as Value;
43 -->recvtovar %VARIABLE_VALUE% Value
44 -->echo Verify [Session variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
45 -->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
46 -->noquiet
47 -->endmacro
48
49
50 -->macro Assert_user_variable %VARIABLE_NAME% %EXPECTED_VALUE%
51 -->quiet
52 -->stmtsql SELECT @%VARIABLE_NAME% as Value;
53 -->recvtovar %VARIABLE_VALUE% Value
54 -->echo Verify [User variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
55 -->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
56 -->noquiet
57 -->endmacro
58