Debian Codegraph @

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

raw
1 SET @mysqlx_compression_algorithms_sav= @@global.mysqlx_compression_algorithms;
2 SET GLOBAL mysqlx_compression_algorithms="";
3 show variables like 'mysqlx_compression_algorithms';
4 Variable_name Value
5 mysqlx_compression_algorithms
6 SET @@global.mysqlx_compression_algorithms="LZ4_MESSAGE";
7 show variables like 'mysqlx_compression_algorithms';
8 Variable_name Value
9 mysqlx_compression_algorithms LZ4_MESSAGE
10 SET @@global.mysqlx_compression_algorithms="DEFLATE_STREAM,LZ4_MESSAGE";
11 show variables like 'mysqlx_compression_algorithms';
12 Variable_name Value
13 mysqlx_compression_algorithms DEFLATE_STREAM,LZ4_MESSAGE
14 SET mysqlx_compression_algorithms="LZ4_MESSAGE";
15 ERROR HY000: Variable 'mysqlx_compression_algorithms' is a GLOBAL variable and should be set with SET GLOBAL
16 SET @@local.mysqlx_compression_algorithms="LZ4_MESSAGE";
17 ERROR HY000: Variable 'mysqlx_compression_algorithms' is a GLOBAL variable and should be set with SET GLOBAL
18 SET @@mysqlx_compression_algorithms="LZ4_MESSAGE";
19 ERROR HY000: Variable 'mysqlx_compression_algorithms' is a GLOBAL variable and should be set with SET GLOBAL
20 SET @@session.mysqlx_compression_algorithms="LZ4_MESSAGE";
21 ERROR HY000: Variable 'mysqlx_compression_algorithms' is a GLOBAL variable and should be set with SET GLOBAL
22 SET SESSION mysqlx_compression_algorithms="LZ4_MESSAGE";
23 ERROR HY000: Variable 'mysqlx_compression_algorithms' is a GLOBAL variable and should be set with SET GLOBAL
24 SET GLOBAL mysqlx_compression_algorithms=1;
25 show variables like 'mysqlx_compression_algorithms';
26 Variable_name Value
27 mysqlx_compression_algorithms DEFLATE_STREAM
28 SET GLOBAL mysqlx_compression_algorithms=-848;
29 ERROR 42000: Variable 'mysqlx_compression_algorithms' can't be set to the value of '-848'
30 SET GLOBAL mysqlx_compression_algorithms=848;
31 ERROR 42000: Variable 'mysqlx_compression_algorithms' can't be set to the value of '848'
32 SET GLOBAL mysqlx_compression_algorithms='%45*#in';
33 ERROR 42000: Variable 'mysqlx_compression_algorithms' can't be set to the value of '%45*#in'
34 show variables like 'mysqlx_compression_algorithms';
35 Variable_name Value
36 mysqlx_compression_algorithms DEFLATE_STREAM
37 SET @@global.mysqlx_compression_algorithms= @mysqlx_compression_algorithms_sav;