Debian Codegraph @

mysql-test/suite/x/t/system_variable_io_timeouts.test

raw
1 ## Test configuration
2 ##
3 --let $wait_for_unixsocket_status = no_wait
4 --let $wait_for_tcpsocket_status = no_wait
5 --source include/xplugin_preamble.inc
6 --source include/xplugin_create_user.inc
7
8 CREATE USER 'regular_user'@'%' IDENTIFIED WITH 'mysql_native_password';
9 CREATE USER 'var_admin_user'@'%' IDENTIFIED WITH 'mysql_native_password';
10 CREATE USER 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password';
11
12 disable_warnings;
13 GRANT 'SYSTEM_VARIABLES_ADMIN' ON *.* TO 'var_admin_user'@'%';
14 GRANT SUPER ON *.* TO 'super_user'@'%';
15 enable_warnings;
16
17 #
18 ## Verify Mysqlx_wait_timeout
19 #
20 --let $timeout_default_value=28800
21 --let $timeout_variable=Mysqlx_wait_timeout
22 --let $user_without_permissions=regular_user
23 --let $user_with_permissions=var_admin_user
24 --let $is_session=1
25 --source ../include/system_variable_timeout.inc
26
27 --let $user_with_permissions=super_user
28 --source ../include/system_variable_timeout.inc
29
30 #
31 ## Verify Mysqlx_interactive_timeout
32 #
33 --let $timeout_default_value=28800
34 --let $timeout_variable=Mysqlx_interactive_timeout
35 --let $user_without_permissions=regular_user
36 --let $user_with_permissions=var_admin_user
37 --let $is_session=0
38 --source ../include/system_variable_timeout.inc
39
40 --let $user_with_permissions=super_user
41 --source ../include/system_variable_timeout.inc
42
43 #
44 ## Verify Mysqlx_read_timeout
45 #
46 --let $timeout_default_value=30
47 --let $timeout_variable=Mysqlx_read_timeout
48 --let $user_without_permissions=regular_user
49 --let $user_with_permissions=var_admin_user
50 --let $is_session=1
51 --source ../include/system_variable_timeout.inc
52
53 --let $user_with_permissions=super_user
54 --source ../include/system_variable_timeout.inc
55
56 #
57 ## Verify Mysqlx_write_timeout
58 #
59 --let $timeout_default_value=60
60 --let $timeout_variable=Mysqlx_write_timeout
61 --let $user_without_permissions=regular_user
62 --let $user_with_permissions=var_admin_user
63 --let $is_session=1
64 --source ../include/system_variable_timeout.inc
65
66 --let $user_with_permissions=super_user
67 --source ../include/system_variable_timeout.inc
68
69 ## Cleanup
70 ##
71 DROP USER 'regular_user'@'%';
72 DROP USER 'var_admin_user'@'%';
73 DROP USER 'super_user'@'%';
74
75 --source ../include/xplugin_cleanup.inc