Debian Codegraph @

mysql-test/suite/sys_vars/r/ssl_session_cache_mode_basic.result

raw
1 #
2 # WL#13075: Support TLS session reuse in the C API
3 #
4 # Check the default value
5 SELECT @@GLOBAL.ssl_session_cache_mode;
6 @@GLOBAL.ssl_session_cache_mode
7 1
8 # 1 expected
9 # Check if value can set
10 SET @@GLOBAL.ssl_session_cache_mode=false;
11 SELECT @@GLOBAL.ssl_session_cache_mode;
12 @@GLOBAL.ssl_session_cache_mode
13 0
14 # 0 expected
15 # Check if the value in GLOBAL Table matches value in variable
16 SELECT @@GLOBAL.ssl_session_cache_mode = VARIABLE_VALUE
17 FROM performance_schema.global_variables
18 WHERE VARIABLE_NAME='ssl_session_cache_mode';
19 @@GLOBAL.ssl_session_cache_mode = VARIABLE_VALUE
20 1
21 1 Expected
22 SELECT @@GLOBAL.ssl_session_cache_mode;
23 @@GLOBAL.ssl_session_cache_mode
24 0
25 SELECT COUNT(VARIABLE_VALUE)
26 FROM performance_schema.global_variables
27 WHERE VARIABLE_NAME='ssl_session_cache_mode';
28 COUNT(VARIABLE_VALUE)
29 1
30 1 Expected
31 # Check if accessing variable with and without GLOBAL point to same variable
32 SELECT @@ssl_session_cache_mode = @@GLOBAL.ssl_session_cache_mode;
33 @@ssl_session_cache_mode = @@GLOBAL.ssl_session_cache_mode
34 1
35 # 1 expected
36 # Check if ssl_session_cache_mode can be accessed with the @@ sign
37 SELECT @@ssl_session_cache_mode;
38 @@ssl_session_cache_mode
39 0
40 SELECT @@local.ssl_session_cache_mode;
41 ERROR HY000: Variable 'ssl_session_cache_mode' is a GLOBAL variable
42 Expected error 'Variable is a GLOBAL variable'
43 SELECT @@SESSION.ssl_session_cache_mode;
44 ERROR HY000: Variable 'ssl_session_cache_mode' is a GLOBAL variable
45 Expected error 'Variable is a GLOBAL variable'
46 SELECT @@GLOBAL.ssl_session_cache_mode;
47 @@GLOBAL.ssl_session_cache_mode
48 0
49 0 Expected
50 SELECT ssl_session_cache_mode = @@SESSION.ssl_session_cache_mode;
51 ERROR HY000: Variable 'ssl_session_cache_mode' is a GLOBAL variable
52 # Set value to true
53 SET @@GLOBAL.ssl_session_cache_mode = true;
54 # Set value to false
55 SET @@GLOBAL.ssl_session_cache_mode = false;
56 # Set value to default
57 SET @@GLOBAL.ssl_session_cache_mode = default;
58 # Set value to foo
59 SET @@GLOBAL.ssl_session_cache_mode = 'foo';
60 ERROR 42000: Variable 'ssl_session_cache_mode' can't be set to the value of 'foo'
61 # Cleanup
62 SET @@GLOBAL.ssl_session_cache_mode = default;