Debian Codegraph @

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

raw
1 SET GLOBAL mysqlx_deflate_max_client_compression_level=1;
2 show variables like 'mysqlx_deflate_max_client_compression_level';
3 Variable_name Value
4 mysqlx_deflate_max_client_compression_level 1
5 SET @@global.mysqlx_deflate_max_client_compression_level=2;
6 show variables like 'mysqlx_deflate_max_client_compression_level';
7 Variable_name Value
8 mysqlx_deflate_max_client_compression_level 2
9 SET mysqlx_deflate_max_client_compression_level=4;
10 ERROR HY000: Variable 'mysqlx_deflate_max_client_compression_level' is a GLOBAL variable and should be set with SET GLOBAL
11 SET @@local.mysqlx_deflate_max_client_compression_level=4;
12 ERROR HY000: Variable 'mysqlx_deflate_max_client_compression_level' is a GLOBAL variable and should be set with SET GLOBAL
13 SET @@mysqlx_deflate_max_client_compression_level=4;
14 ERROR HY000: Variable 'mysqlx_deflate_max_client_compression_level' is a GLOBAL variable and should be set with SET GLOBAL
15 SET @@session.mysqlx_deflate_max_client_compression_level=4;
16 ERROR HY000: Variable 'mysqlx_deflate_max_client_compression_level' is a GLOBAL variable and should be set with SET GLOBAL
17 SET SESSION mysqlx_deflate_max_client_compression_level=4;
18 ERROR HY000: Variable 'mysqlx_deflate_max_client_compression_level' is a GLOBAL variable and should be set with SET GLOBAL
19 SET GLOBAL mysqlx_deflate_max_client_compression_level='5';
20 ERROR 42000: Incorrect argument type to variable 'mysqlx_deflate_max_client_compression_level'
21 SET GLOBAL mysqlx_deflate_max_client_compression_level=0;
22 ERROR 42000: Variable 'mysqlx_deflate_max_client_compression_level' can't be set to the value of '0'
23 SET GLOBAL mysqlx_deflate_max_client_compression_level=128;
24 ERROR 42000: Variable 'mysqlx_deflate_max_client_compression_level' can't be set to the value of '128'
25 SET GLOBAL mysqlx_deflate_max_client_compression_level=-1;
26 ERROR 42000: Variable 'mysqlx_deflate_max_client_compression_level' can't be set to the value of '-1'
27 SET GLOBAL mysqlx_deflate_max_client_compression_level=-128;
28 ERROR 42000: Variable 'mysqlx_deflate_max_client_compression_level' can't be set to the value of '-128'
29 SET @@global.mysqlx_deflate_max_client_compression_level= DEFAULT;