Debian Codegraph @

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

raw
1 ## Preamble
2 --source include/xplugin_preamble.inc
3 --source include/xplugin_create_user.inc
4
5 --echo #
6 --echo # Tests for setting the global and session value for net_read_timeout
7 --echo #
8
9 --echo # Get initial values
10 SET @start_global_read_value = @@global.net_read_timeout;
11 SELECT @start_global_read_value;
12 SET @start_session_read_value = @@session.net_read_timeout;
13 SELECT @start_session_read_value;
14
15 --echo # Try to change the values
16 --write_file $MYSQL_TMP_DIR/net_var_1.xpl
17 -->expecterror ER_PLUGGABLE_PROTOCOL_COMMAND_NOT_SUPPORTED
18 -->sql
19 SET @@global.net_read_timeout = 100;
20 SET @@session.net_read_timeout = 200;
21 -->endsql
22 EOF
23 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/net_var_1.xpl 2>&1
24
25 --echo # Get after values
26 SELECT @@global.net_read_timeout;
27 SELECT @@session.net_read_timeout;
28
29 # reset value
30 SET @@global.net_read_timeout = @start_global_read_value;
31
32 --echo #
33 --echo # Tests for setting the global and session value for net_write_timeout
34 --echo #
35
36 --echo # Get initial values
37 SET @start_global_write_value = @@global.net_write_timeout;
38 SELECT @start_global_write_value;
39 SET @start_session_write_value = @@session.net_write_timeout;
40 SELECT @start_session_write_value;
41
42 --echo # Try to change the values
43 --write_file $MYSQL_TMP_DIR/net_var_2.xpl
44 -->expecterror ER_PLUGGABLE_PROTOCOL_COMMAND_NOT_SUPPORTED
45 -->sql
46 SET @@global.net_write_timeout = 100;
47 SET @@session.net_write_timeout = 200;
48 -->endsql
49 EOF
50
51 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/net_var_2.xpl 2>&1
52
53 --echo # Get after values
54 SELECT @@global.net_write_timeout;
55 SELECT @@session.net_write_timeout;
56
57 # reset value
58 SET @@global.net_write_timeout = @start_global_write_value;
59
60 --echo #
61 --echo # Tests for setting the global and session value for net_retry_count
62 --echo #
63
64 --echo # Get initial values
65 SET @start_global_retry_value = @@global.net_retry_count;
66 SELECT @start_global_retry_value;
67 SET @start_session_retry_value = @@session.net_retry_count;
68 SELECT @start_session_retry_value;
69
70 --echo # Try to change the values
71 --write_file $MYSQL_TMP_DIR/net_var_3.xpl
72
73 -->expecterror ER_PLUGGABLE_PROTOCOL_COMMAND_NOT_SUPPORTED
74 -->sql
75 SET @@global.net_retry_count = 100;
76 SET @@session.net_retry_count = 200;
77 -->endsql
78 EOF
79
80 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/net_var_3.xpl 2>&1
81
82 --echo # Get after values
83 SELECT @@global.net_retry_count;
84 SELECT @@session.net_retry_count;
85
86 # reset value
87 SET @@global.net_retry_count = @start_global_retry_value;
88
89 ## Cleanup
90 --source ../include/xplugin_cleanup.inc