Debian Codegraph @

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

raw
1 # Variable: mysqlx_zstd_max_client_compression_level
2 # Default : 11
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 ## Valid cases
7 #should pass when zstd library version >= 1.4.0
8 --error 0,ER_WRONG_VALUE_FOR_VAR
9 SET GLOBAL mysqlx_zstd_max_client_compression_level=1;
10
11 #should pass when zstd library version >= 1.4.0
12 --error 0,ER_WRONG_VALUE_FOR_VAR
13 SET @@global.mysqlx_zstd_max_client_compression_level=2;
14
15 SET @@global.mysqlx_zstd_max_client_compression_level=3;
16 show variables like 'mysqlx_zstd_max_client_compression_level';
17
18 #should pass when zstd library version >= 1.4.0
19 --error 0,ER_WRONG_VALUE_FOR_VAR
20 SET GLOBAL mysqlx_zstd_max_client_compression_level=-1;
21
22 #should pass when zstd library version >= 1.4.0
23 --error 0,ER_WRONG_VALUE_FOR_VAR
24 SET @@global.mysqlx_zstd_max_client_compression_level=-2;
25
26
27 ## Invalid cases
28 --error ER_GLOBAL_VARIABLE
29 SET mysqlx_zstd_max_client_compression_level=4;
30
31 --error ER_GLOBAL_VARIABLE
32 SET @@local.mysqlx_zstd_max_client_compression_level=4;
33
34 --error ER_GLOBAL_VARIABLE
35 SET @@mysqlx_zstd_max_client_compression_level=4;
36
37 --error ER_GLOBAL_VARIABLE
38 SET @@session.mysqlx_zstd_max_client_compression_level=4;
39
40 --error ER_GLOBAL_VARIABLE
41 SET SESSION mysqlx_zstd_max_client_compression_level=4;
42
43 --error ER_WRONG_TYPE_FOR_VAR
44 SET GLOBAL mysqlx_zstd_max_client_compression_level='5';
45
46 --error ER_WRONG_VALUE_FOR_VAR
47 SET GLOBAL mysqlx_zstd_max_client_compression_level=0;
48
49 --error ER_WRONG_VALUE_FOR_VAR
50 SET GLOBAL mysqlx_zstd_max_client_compression_level=128;
51
52 --error ER_WRONG_VALUE_FOR_VAR
53 SET GLOBAL mysqlx_zstd_max_client_compression_level=-150000;
54
55
56 SET @@global.mysqlx_zstd_max_client_compression_level= DEFAULT;