Debian Codegraph @

mysql-test/suite/sys_vars/t/ssl_session_cache_timeout_basic.test

raw
1 --echo #
2 --echo # WL#13075: Support TLS session reuse in the C API
3 --echo #
4
5 --echo # Check the default value
6 SELECT @@GLOBAL.ssl_session_cache_timeout;
7 --echo 300 Expected
8
9
10 --echo # Check if value can set
11 SET @@GLOBAL.ssl_session_cache_timeout=400;
12 SELECT @@GLOBAL.ssl_session_cache_timeout;
13 --echo 400 expected
14
15
16 --echo # Check if the value in GLOBAL Table matches value in variable
17
18 --disable_warnings
19 SELECT @@GLOBAL.ssl_session_cache_timeout = VARIABLE_VALUE
20 FROM performance_schema.global_variables
21 WHERE VARIABLE_NAME='ssl_session_cache_timeout';
22 --enable_warnings
23 --echo 1 Expected
24
25 SELECT @@GLOBAL.ssl_session_cache_timeout;
26
27 --echo # Check if there's only one value in global_variables
28 --disable_warnings
29 SELECT COUNT(VARIABLE_VALUE)
30 FROM performance_schema.global_variables
31 WHERE VARIABLE_NAME='ssl_session_cache_timeout';
32 --enable_warnings
33 --echo 1 Expected
34
35
36
37 --echo # Check if accessing variable with and without GLOBAL point to same variable
38 # 1 expected
39 SELECT @@ssl_session_cache_timeout = @@GLOBAL.ssl_session_cache_timeout;
40
41
42 --echo # Check if ssl_session_cache_timeout can be accessed with @@ sign
43 SELECT @@ssl_session_cache_timeout;
44
45 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
46 SELECT @@local.ssl_session_cache_timeout;
47 --echo Expected error 'Variable is a GLOBAL variable'
48
49 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
50 SELECT @@SESSION.ssl_session_cache_timeout;
51 --echo Expected error 'Variable is a GLOBAL variable'
52
53 SELECT @@GLOBAL.ssl_session_cache_timeout;
54 --echo 400 Expected
55
56 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
57 SELECT ssl_session_cache_timeout = @@SESSION.ssl_session_cache_timeout;
58
59 --echo # Set value to min
60 SET @@GLOBAL.ssl_session_cache_timeout = 0;
61 # expect success
62
63 --echo # Set value to max
64 SET @@GLOBAL.ssl_session_cache_timeout = 84600;
65 # expect success
66
67 --echo # Set value below min
68 SET @@GLOBAL.ssl_session_cache_timeout = -1;
69 # expect warning
70
71 --echo # Set value above max
72 SET @@GLOBAL.ssl_session_cache_timeout = 84600 + 1;
73 # expect warning
74
75 --echo # expect to be able to set it with step of 1
76 SET @@GLOBAL.ssl_session_cache_timeout = 300;
77 SET @@GLOBAL.ssl_session_cache_timeout = 301;
78 SET @@GLOBAL.ssl_session_cache_timeout = 299;
79
80
81 --echo # Cleanup
82 SET @@GLOBAL.ssl_session_cache_timeout = default;