Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_compression_algorithm;
2 SELECT @start_global_value;
3 @start_global_value
4 zlib
5 select @@global.innodb_compression_algorithm;
6 @@global.innodb_compression_algorithm
7 zlib
8 select @@session.innodb_compression_algorithm;
9 ERROR HY000: Variable 'innodb_compression_algorithm' is a GLOBAL variable
10 show global variables like 'innodb_compression_algorithm';
11 Variable_name Value
12 innodb_compression_algorithm zlib
13 show session variables like 'innodb_compression_algorithm';
14 Variable_name Value
15 innodb_compression_algorithm zlib
16 select * from information_schema.global_variables where variable_name='innodb_compression_algorithm';
17 VARIABLE_NAME VARIABLE_VALUE
18 INNODB_COMPRESSION_ALGORITHM zlib
19 select * from information_schema.session_variables where variable_name='innodb_compression_algorithm';
20 VARIABLE_NAME VARIABLE_VALUE
21 INNODB_COMPRESSION_ALGORITHM zlib
22 set global innodb_compression_algorithm=1;
23 select @@global.innodb_compression_algorithm;
24 @@global.innodb_compression_algorithm
25 zlib
26 select * from information_schema.global_variables where variable_name='innodb_compression_algorithm';
27 VARIABLE_NAME VARIABLE_VALUE
28 INNODB_COMPRESSION_ALGORITHM zlib
29 select * from information_schema.session_variables where variable_name='innodb_compression_algorithm';
30 VARIABLE_NAME VARIABLE_VALUE
31 INNODB_COMPRESSION_ALGORITHM zlib
32 set session innodb_compression_algorithm=0;
33 ERROR HY000: Variable 'innodb_compression_algorithm' is a GLOBAL variable and should be set with SET GLOBAL
34 set global innodb_compression_algorithm=1.1;
35 ERROR 42000: Incorrect argument type to variable 'innodb_compression_algorithm'
36 set global innodb_compression_algorithm=1e1;
37 ERROR 42000: Incorrect argument type to variable 'innodb_compression_algorithm'
38 set global innodb_compression_algorithm="foo";
39 ERROR 42000: Variable 'innodb_compression_algorithm' can't be set to the value of 'foo'
40 set global innodb_compression_algorithm=0;
41 select @@global.innodb_compression_algorithm;
42 @@global.innodb_compression_algorithm
43 none
44 SET @@global.innodb_compression_algorithm = @start_global_value;
45 SELECT @@global.innodb_compression_algorithm;
46 @@global.innodb_compression_algorithm
47 zlib