Debian Codegraph @

mysql-test/suite/sys_vars/t/ssl_session_cache_mode_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_mode;
7 --echo # 1 expected
8
9
10 --echo # Check if value can set
11 SET @@GLOBAL.ssl_session_cache_mode=false;
12 SELECT @@GLOBAL.ssl_session_cache_mode;
13 --echo # 0 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_mode = VARIABLE_VALUE
20 FROM performance_schema.global_variables
21 WHERE VARIABLE_NAME='ssl_session_cache_mode';
22 --enable_warnings
23 --echo 1 Expected
24
25 SELECT @@GLOBAL.ssl_session_cache_mode;
26
27 --disable_warnings
28 SELECT COUNT(VARIABLE_VALUE)
29 FROM performance_schema.global_variables
30 WHERE VARIABLE_NAME='ssl_session_cache_mode';
31 --enable_warnings
32 --echo 1 Expected
33
34
35
36 --echo # Check if accessing variable with and without GLOBAL point to same variable
37 SELECT @@ssl_session_cache_mode = @@GLOBAL.ssl_session_cache_mode;
38 --echo # 1 expected
39
40
41 --echo # Check if ssl_session_cache_mode can be accessed with the @@ sign
42 SELECT @@ssl_session_cache_mode;
43
44 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
45 SELECT @@local.ssl_session_cache_mode;
46 --echo Expected error 'Variable is a GLOBAL variable'
47
48 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
49 SELECT @@SESSION.ssl_session_cache_mode;
50 --echo Expected error 'Variable is a GLOBAL variable'
51
52 SELECT @@GLOBAL.ssl_session_cache_mode;
53 --echo 0 Expected
54
55 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
56 SELECT ssl_session_cache_mode = @@SESSION.ssl_session_cache_mode;
57
58 --echo # Set value to true
59 SET @@GLOBAL.ssl_session_cache_mode = true;
60 # expect success
61
62 --echo # Set value to false
63 SET @@GLOBAL.ssl_session_cache_mode = false;
64 # expect success
65
66 --echo # Set value to default
67 SET @@GLOBAL.ssl_session_cache_mode = default;
68 # expect success
69
70 --echo # Set value to foo
71 --error ER_WRONG_VALUE_FOR_VAR
72 SET @@GLOBAL.ssl_session_cache_mode = 'foo';
73 # expect failure
74
75 --echo # Cleanup
76 SET @@GLOBAL.ssl_session_cache_mode = default;