Debian Codegraph @

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

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