Debian Codegraph @

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

raw
1 --echo #
2 --echo # Variable name : protocol_compression_algorithms
3 --echo # Scope : Global only
4 --echo #
5
6 --echo # Global - default
7 SELECT @@global.protocol_compression_algorithms;
8
9 --echo # verify all possible values
10 SET GLOBAL protocol_compression_algorithms= "zstd";
11 SELECT @@global.protocol_compression_algorithms;
12 SET GLOBAL protocol_compression_algorithms= "zlib";
13 SELECT @@global.protocol_compression_algorithms;
14 SET GLOBAL protocol_compression_algorithms= "uncompressed";
15 SELECT @@global.protocol_compression_algorithms;
16 SET GLOBAL protocol_compression_algorithms= "zstd,zlib";
17 SELECT @@global.protocol_compression_algorithms;
18 SET GLOBAL protocol_compression_algorithms= "zstd,uncompressed";
19 SELECT @@global.protocol_compression_algorithms;
20 SET GLOBAL protocol_compression_algorithms= "zlib,uncompressed";
21 SELECT @@global.protocol_compression_algorithms;
22 SET GLOBAL protocol_compression_algorithms= "zstd,zlib,uncompressed";
23 SELECT @@global.protocol_compression_algorithms;
24
25 SET PERSIST protocol_compression_algorithms= "zstd";
26 SET PERSIST protocol_compression_algorithms= default;
27
28 --echo # verify scope of variable
29 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
30 SELECT @@local.protocol_compression_algorithms;
31 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
32 SELECT @@session.protocol_compression_algorithms;
33
34 --echo # verify invalid values
35 --Error ER_WRONG_TYPE_FOR_VAR
36 SET GLOBAL protocol_compression_algorithms= 1;
37 --Error ER_WRONG_TYPE_FOR_VAR
38 SET PERSIST protocol_compression_algorithms= 1;
39 --Error ER_WRONG_VALUE_FOR_VAR
40 SET GLOBAL protocol_compression_algorithms= "xyz";
41 --Error ER_WRONG_VALUE_FOR_VAR
42 SET GLOBAL protocol_compression_algorithms= "uncompressed,xyz";
43 --Error ER_WRONG_VALUE_FOR_VAR
44 SET GLOBAL protocol_compression_algorithms= "";
45
46 #cleanup
47 RESET PERSIST;
48
49 --echo # End of tests.