Debian Codegraph @

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

raw
1 # Variable: mysqlx_compression_algorithms
2 # Default : DEFLATE_STREAM,LZ4_MESSAGE
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 SET @mysqlx_compression_algorithms_sav= @@global.mysqlx_compression_algorithms;
7
8 ## Valid cases
9 SET GLOBAL mysqlx_compression_algorithms="";
10 show variables like 'mysqlx_compression_algorithms';
11
12 SET @@global.mysqlx_compression_algorithms="LZ4_MESSAGE";
13 show variables like 'mysqlx_compression_algorithms';
14 SET @@global.mysqlx_compression_algorithms="DEFLATE_STREAM,LZ4_MESSAGE";
15 # assert_variable.inc doesn't work with sets
16 show variables like 'mysqlx_compression_algorithms';
17
18 ## Invalid cases
19 --error ER_GLOBAL_VARIABLE
20 SET mysqlx_compression_algorithms="LZ4_MESSAGE";
21 --error ER_GLOBAL_VARIABLE
22 SET @@local.mysqlx_compression_algorithms="LZ4_MESSAGE";
23 --error ER_GLOBAL_VARIABLE
24 SET @@mysqlx_compression_algorithms="LZ4_MESSAGE";
25 --error ER_GLOBAL_VARIABLE
26 SET @@session.mysqlx_compression_algorithms="LZ4_MESSAGE";
27 --error ER_GLOBAL_VARIABLE
28 SET SESSION mysqlx_compression_algorithms="LZ4_MESSAGE";
29
30 SET GLOBAL mysqlx_compression_algorithms=1;
31 show variables like 'mysqlx_compression_algorithms';
32
33 --error ER_WRONG_VALUE_FOR_VAR
34 SET GLOBAL mysqlx_compression_algorithms=-848;
35
36 --error ER_WRONG_VALUE_FOR_VAR
37 SET GLOBAL mysqlx_compression_algorithms=848;
38
39 --error ER_WRONG_VALUE_FOR_VAR
40 SET GLOBAL mysqlx_compression_algorithms='%45*#in';
41 show variables like 'mysqlx_compression_algorithms';
42
43 SET @@global.mysqlx_compression_algorithms= @mysqlx_compression_algorithms_sav;