Debian Codegraph @

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

raw
1 ###############################################################################
2 # Variable Name: binlog_rotate_encryption_master_key_at_startup
3 # Scope: global
4 # Access Type: read only
5 # Data Type: boolean
6 #
7 # Description: Test case for checking the behavior of dynamic system variable
8 # "binlog_rotate_encryption_master_key_at_startup", specifically
9 # regarding:
10 # - Scope & access type
11 #
12 # Reference: WL#10957
13 ###############################################################################
14
15 #
16 # Scope: Global only
17 #
18 SELECT COUNT(@@GLOBAL.binlog_rotate_encryption_master_key_at_startup);
19
20 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
21 SELECT COUNT(@@SESSION.binlog_rotate_encryption_master_key_at_startup);
22
23 --disable_warnings
24 SELECT VARIABLE_NAME FROM performance_schema.global_variables WHERE VARIABLE_NAME='binlog_rotate_encryption_master_key_at_startup';
25 SELECT VARIABLE_NAME FROM performance_schema.session_variables WHERE VARIABLE_NAME='binlog_rotate_encryption_master_key_at_startup';
26 --enable_warnings
27
28 #
29 # Access Type: Read only
30 #
31 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
32 SET GLOBAL binlog_rotate_encryption_master_key_at_startup= ON;
33 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
34 SET GLOBAL binlog_rotate_encryption_master_key_at_startup= OFF;