Debian Codegraph @

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

raw
1 # Variable Name: binlog_transaction_compression_level_zstd
2 # Scope: Global & Session
3 # Access Type: Static
4 # Data Type: enumeration
5 #
6 # Creation Date: 2019-07-17
7 # Author : Luis Soares
8
9 --let $saved_global_binlog_transaction_compression_level_zstd = `SELECT @@global.binlog_transaction_compression_level_zstd`
10
11 --let $saved_session_binlog_transaction_compression_level_zstd = `SELECT @@session.binlog_transaction_compression_level_zstd`
12
13 ####################################################################
14 # Displaying default value #
15 ####################################################################
16
17 --let $assert_text= Default GLOBAL value is 3
18 --let $assert_cond = [SELECT @@global.binlog_transaction_compression_level_zstd = 3]
19 --source include/assert.inc
20
21 --let $assert_text= Default SESSION value 3
22 --let $assert_cond = [SELECT @@session.binlog_transaction_compression_level_zstd = 3]
23 --source include/assert.inc
24
25 ####################################################################
26 # Check if Value can set and that P_S reports the correct value #
27 ####################################################################
28
29 # GLOBAL, SESSION, PERSIST, PERSIST_ONLY
30 --let $i=4
31
32 # 1, 22, DEFAULT
33 --let $j=3
34
35 while($i>0)
36 {
37 while($j>0)
38 {
39 if ($j == 3)
40 {
41 --let $to_set = DEFAULT
42 --let $expected = 3
43 }
44
45 if ($j == 2)
46 {
47 --let $to_set = 22
48 --let $expected = 22
49 }
50
51 if ($j == 1)
52 {
53 --let $to_set = 1
54 --let $expected = 1
55 }
56
57 # SESSION
58 if ($i == 1)
59 {
60 --let $scope = SESSION
61 --let $ps_table = session_variables
62 }
63
64 # GLOBAL
65 if ($i == 2)
66 {
67 --let $scope = GLOBAL
68 --let $ps_table = global_variables
69 }
70
71 # PERSIST
72 if ($i == 3)
73 {
74 --let $scope = PERSIST
75 --let $ps_table = persisted_variables
76 }
77
78 # PERSIST_ONLY
79 if ($i == 4)
80 {
81 --let $scope = PERSIST_ONLY
82 --let $ps_table = persisted_variables
83 }
84
85 --eval SET @@$scope.binlog_transaction_compression_level_zstd = $to_set
86 --let $reported=`SELECT variable_value FROM performance_schema.$ps_table WHERE variable_name = 'binlog_transaction_compression_level_zstd'`
87
88 --let $assert_text= Reported value matches the one set (set $to_set in $scope scope)
89 --let $assert_cond = "$reported" = "$expected"
90 --source include/assert.inc
91
92 --dec $j
93 }
94 --dec $i
95 }
96
97 ####################################################################
98 # Boundaries #
99 ####################################################################
100 #
101 # assert that one cannot set this to lower than 1
102 SET GLOBAL binlog_transaction_compression_level_zstd = 0;
103 SELECT @@global.binlog_transaction_compression_level_zstd;
104
105 SET SESSION binlog_transaction_compression_level_zstd = 0;
106 SELECT @@session.binlog_transaction_compression_level_zstd;
107
108 # assert that one cannot set this to higher than 23
109 SET GLOBAL binlog_transaction_compression_level_zstd = 23;
110 SELECT @@global.binlog_transaction_compression_level_zstd;
111
112 SET SESSION binlog_transaction_compression_level_zstd = 23;
113 SELECT @@session.binlog_transaction_compression_level_zstd;
114
115 ####################################################################
116 # Privileges #
117 ####################################################################
118
119 CREATE USER user1;
120 --connect(conn_user1,localhost,user1,,)
121
122 # assert that one cannot change the value without privileges
123 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
124 SET GLOBAL binlog_transaction_compression_level_zstd = 10;
125
126 # assert that one can change the value if SYSTEM_VARIABLES_ADMIN is given
127 --connection default
128 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO user1@'%';
129 --connection conn_user1
130 SET GLOBAL binlog_transaction_compression_level_zstd= 10;
131
132 --connection default
133 DROP USER user1;
134
135 ####################################################################
136 # transactional context #
137 ####################################################################
138
139 BEGIN;
140
141 # cannot set variable inside a transaction in session scope
142 --error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
143 SET SESSION binlog_transaction_compression_level_zstd=11;
144
145 # can change the variable's value in global scope while inside a transaction
146 SET GLOBAL binlog_transaction_compression_level_zstd=11;
147
148 # can change the variable's value in persist scope while inside a transaction
149 SET PERSIST binlog_transaction_compression_level_zstd=11;
150
151 # can change the variable's value in persist_only scope while inside transaction
152 SET PERSIST_ONLY binlog_transaction_compression_level_zstd=11;
153
154 ROLLBACK;
155
156 ####################################################################
157 # End of tests #
158 ####################################################################
159
160 RESET PERSIST;
161
162 --eval SET @@session.binlog_transaction_compression_level_zstd = $saved_session_binlog_transaction_compression_level_zstd
163
164 --eval SET @@global.binlog_transaction_compression_level_zstd = $saved_global_binlog_transaction_compression_level_zstd