Debian Codegraph @

mysql-test/suite/x/r/bug_23028052.result

raw
1 #
2 # Tests for setting the global and session value for net_read_timeout
3 #
4 # Get initial values
5 SET @start_global_read_value = @@global.net_read_timeout;
6 SELECT @start_global_read_value;
7 @start_global_read_value
8 30
9 SET @start_session_read_value = @@session.net_read_timeout;
10 SELECT @start_session_read_value;
11 @start_session_read_value
12 30
13 # Try to change the values
14 RUN SET @@global.net_read_timeout = 100
15
16 0 rows affected
17 RUN SET @@session.net_read_timeout = 200
18 While executing SET @@session.net_read_timeout = 200:
19 Got expected error: Command not supported by pluggable protocols (code 3130)
20 Mysqlx.Ok {
21 msg: "bye!"
22 }
23 ok
24 # Get after values
25 SELECT @@global.net_read_timeout;
26 @@global.net_read_timeout
27 100
28 SELECT @@session.net_read_timeout;
29 @@session.net_read_timeout
30 30
31 SET @@global.net_read_timeout = @start_global_read_value;
32 #
33 # Tests for setting the global and session value for net_write_timeout
34 #
35 # Get initial values
36 SET @start_global_write_value = @@global.net_write_timeout;
37 SELECT @start_global_write_value;
38 @start_global_write_value
39 60
40 SET @start_session_write_value = @@session.net_write_timeout;
41 SELECT @start_session_write_value;
42 @start_session_write_value
43 60
44 # Try to change the values
45 RUN SET @@global.net_write_timeout = 100
46
47 0 rows affected
48 RUN SET @@session.net_write_timeout = 200
49 While executing SET @@session.net_write_timeout = 200:
50 Got expected error: Command not supported by pluggable protocols (code 3130)
51 Mysqlx.Ok {
52 msg: "bye!"
53 }
54 ok
55 # Get after values
56 SELECT @@global.net_write_timeout;
57 @@global.net_write_timeout
58 100
59 SELECT @@session.net_write_timeout;
60 @@session.net_write_timeout
61 60
62 SET @@global.net_write_timeout = @start_global_write_value;
63 #
64 # Tests for setting the global and session value for net_retry_count
65 #
66 # Get initial values
67 SET @start_global_retry_value = @@global.net_retry_count;
68 SELECT @start_global_retry_value;
69 @start_global_retry_value
70 10
71 SET @start_session_retry_value = @@session.net_retry_count;
72 SELECT @start_session_retry_value;
73 @start_session_retry_value
74 10
75 # Try to change the values
76 RUN SET @@global.net_retry_count = 100
77
78 0 rows affected
79 RUN SET @@session.net_retry_count = 200
80 While executing SET @@session.net_retry_count = 200:
81 Got expected error: Command not supported by pluggable protocols (code 3130)
82 Mysqlx.Ok {
83 msg: "bye!"
84 }
85 ok
86 # Get after values
87 SELECT @@global.net_retry_count;
88 @@global.net_retry_count
89 100
90 SELECT @@session.net_retry_count;
91 @@session.net_retry_count
92 10
93 SET @@global.net_retry_count = @start_global_retry_value;