Debian Codegraph @

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

raw
1 #
2 # Variable name : protocol_compression_algorithms
3 # Scope : Global only
4 #
5 # Global - default
6 SELECT @@global.protocol_compression_algorithms;
7 @@global.protocol_compression_algorithms
8 zlib,zstd,uncompressed
9 # verify all possible values
10 SET GLOBAL protocol_compression_algorithms= "zstd";
11 SELECT @@global.protocol_compression_algorithms;
12 @@global.protocol_compression_algorithms
13 zstd
14 SET GLOBAL protocol_compression_algorithms= "zlib";
15 SELECT @@global.protocol_compression_algorithms;
16 @@global.protocol_compression_algorithms
17 zlib
18 SET GLOBAL protocol_compression_algorithms= "uncompressed";
19 SELECT @@global.protocol_compression_algorithms;
20 @@global.protocol_compression_algorithms
21 uncompressed
22 SET GLOBAL protocol_compression_algorithms= "zstd,zlib";
23 SELECT @@global.protocol_compression_algorithms;
24 @@global.protocol_compression_algorithms
25 zstd,zlib
26 SET GLOBAL protocol_compression_algorithms= "zstd,uncompressed";
27 SELECT @@global.protocol_compression_algorithms;
28 @@global.protocol_compression_algorithms
29 zstd,uncompressed
30 SET GLOBAL protocol_compression_algorithms= "zlib,uncompressed";
31 SELECT @@global.protocol_compression_algorithms;
32 @@global.protocol_compression_algorithms
33 zlib,uncompressed
34 SET GLOBAL protocol_compression_algorithms= "zstd,zlib,uncompressed";
35 SELECT @@global.protocol_compression_algorithms;
36 @@global.protocol_compression_algorithms
37 zstd,zlib,uncompressed
38 SET PERSIST protocol_compression_algorithms= "zstd";
39 SET PERSIST protocol_compression_algorithms= default;
40 # verify scope of variable
41 SELECT @@local.protocol_compression_algorithms;
42 ERROR HY000: Variable 'protocol_compression_algorithms' is a GLOBAL variable
43 SELECT @@session.protocol_compression_algorithms;
44 ERROR HY000: Variable 'protocol_compression_algorithms' is a GLOBAL variable
45 # verify invalid values
46 SET GLOBAL protocol_compression_algorithms= 1;
47 ERROR 42000: Incorrect argument type to variable 'protocol_compression_algorithms'
48 SET PERSIST protocol_compression_algorithms= 1;
49 ERROR 42000: Incorrect argument type to variable 'protocol_compression_algorithms'
50 SET GLOBAL protocol_compression_algorithms= "xyz";
51 ERROR 42000: Variable 'protocol_compression_algorithms' can't be set to the value of 'xyz'
52 SET GLOBAL protocol_compression_algorithms= "uncompressed,xyz";
53 ERROR 42000: Variable 'protocol_compression_algorithms' can't be set to the value of 'uncompressed,xyz'
54 SET GLOBAL protocol_compression_algorithms= "";
55 ERROR 42000: Variable 'protocol_compression_algorithms' can't be set to the value of ''
56 RESET PERSIST;
57 # End of tests.