Debian Codegraph @

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

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