Debian Codegraph @

mysql-test/suite/x/include/system_variable_timeout.inc

raw
1 ## Test body
2 ##
3
4 --write_file $MYSQL_TMP_DIR/mysqlx-session-variable-timeout.xpl
5 -->import assert_variable.macro
6
7 -->newsession power_user %POWER_USER%
8 -->stmtsql SET SESSION %TIMEOUT_VARIABLE%=10;
9 -->recvresult
10
11 -->callmacro Assert_session_variable %TIMEOUT_VARIABLE% 10
12
13 -->newsession regular_user %REGULAR_USER%
14 -->stmtsql SET SESSION %TIMEOUT_VARIABLE%=20;
15 -->recvresult
16
17 -->callmacro Assert_session_variable %TIMEOUT_VARIABLE% 20
18
19 EOF
20
21 --echo #
22 --echo # Verify access to $timeout_variable system variable after plugin installation
23 --echo #
24 --echo # * invalid values
25 --echo # * user with permissions
26 --echo # * user without permissions
27 --echo #
28
29 --let $assert_text= $timeout_variable global variablem must exist
30 --let $assert_cond= [SELECT COUNT(@@GLOBAL.$timeout_variable) as Result;, Result, 1] =1
31 --source include/assert.inc
32
33 --error ER_WRONG_TYPE_FOR_VAR
34 eval SET @@GLOBAL.$timeout_variable="TEXT";
35 eval SELECT @@GLOBAL.$timeout_variable;
36 --let $assert_text= Invalid set doesn't change the value of $timeout_variable (global variable)
37 --let $assert_cond= [SELECT @@GLOBAL.$timeout_variable = $timeout_default_value as Result;, Result, 1] =1
38 --source include/assert.inc
39
40 --echo #
41 --echo ## user with permissions
42 --connect(con_user2, 127.0.0.1, $user_with_permissions,'',,,,)
43
44 eval SET @@GLOBAL.$timeout_variable=10;
45
46 --let $assert_text= User with permissions can change $timeout_variable value
47 --let $assert_cond= [SELECT @@GLOBAL.$timeout_variable = 10 as Result;, Result, 1] =1
48 --source include/assert.inc
49
50 --echo #
51 --echo ## user without permissions
52 --connect(con_user1, 127.0.0.1, $user_without_permissions,'',,,,)
53
54 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
55 eval SET @@GLOBAL.$timeout_variable=11;
56
57 --let $assert_text= User without permissions can't change $timeout_variable value
58 --let $assert_cond= [SELECT @@GLOBAL.$timeout_variable = 10 as Result;, Result, 1] =1
59 --source include/assert.inc
60
61 if ($is_session > 0)
62 {
63 exec $MYSQLXTEST
64 -u x_root
65 -v%REGULAR_USER%=$user_without_permissions
66 -v%POWER_USER%=$user_with_permissions
67 -v%TIMEOUT_VARIABLE%=$timeout_variable
68 --file $MYSQL_TMP_DIR/mysqlx-session-variable-timeout.xpl;
69 }
70
71 ## Cleanup
72 ##
73 --connection default
74 --disconnect con_user2
75 --disconnect con_user1
76
77 eval SET @@GLOBAL.$timeout_variable=DEFAULT;
78
79 --remove_file $MYSQL_TMP_DIR/mysqlx-session-variable-timeout.xpl