Debian Codegraph @

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

raw
1 # Variable: mysqlx_lz4_max_client_compression_level
2 # Default : 8
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 ## Valid cases
7 SET GLOBAL mysqlx_lz4_max_client_compression_level=0;
8 show variables like 'mysqlx_lz4_max_client_compression_level';
9
10 SET GLOBAL mysqlx_lz4_max_client_compression_level=1;
11 show variables like 'mysqlx_lz4_max_client_compression_level';
12
13 SET @@global.mysqlx_lz4_max_client_compression_level=2;
14 show variables like 'mysqlx_lz4_max_client_compression_level';
15
16
17 ## Invalid cases
18 --error ER_GLOBAL_VARIABLE
19 SET mysqlx_lz4_max_client_compression_level=4;
20
21 --error ER_GLOBAL_VARIABLE
22 SET @@local.mysqlx_lz4_max_client_compression_level=4;
23
24 --error ER_GLOBAL_VARIABLE
25 SET @@mysqlx_lz4_max_client_compression_level=4;
26
27 --error ER_GLOBAL_VARIABLE
28 SET @@session.mysqlx_lz4_max_client_compression_level=4;
29
30 --error ER_GLOBAL_VARIABLE
31 SET SESSION mysqlx_lz4_max_client_compression_level=4;
32
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET GLOBAL mysqlx_lz4_max_client_compression_level='5';
35
36 --error ER_WRONG_VALUE_FOR_VAR
37 SET GLOBAL mysqlx_lz4_max_client_compression_level=128;
38
39 --error ER_WRONG_VALUE_FOR_VAR
40 SET GLOBAL mysqlx_lz4_max_client_compression_level=-1;
41
42 --error ER_WRONG_VALUE_FOR_VAR
43 SET GLOBAL mysqlx_lz4_max_client_compression_level=-128;
44
45
46 SET @@global.mysqlx_lz4_max_client_compression_level= DEFAULT;