Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_compression_level;
2 SELECT @start_global_value;
3 @start_global_value
4 6
5 Valid value 0-9
6 select @@global.innodb_compression_level <= 9;
7 @@global.innodb_compression_level <= 9
8 1
9 select @@global.innodb_compression_level;
10 @@global.innodb_compression_level
11 6
12 select @@session.innodb_compression_level;
13 ERROR HY000: Variable 'innodb_compression_level' is a GLOBAL variable
14 show global variables like 'innodb_compression_level';
15 Variable_name Value
16 innodb_compression_level 6
17 show session variables like 'innodb_compression_level';
18 Variable_name Value
19 innodb_compression_level 6
20 select * from performance_schema.global_variables where variable_name='innodb_compression_level';
21 VARIABLE_NAME VARIABLE_VALUE
22 innodb_compression_level 6
23 select * from performance_schema.session_variables where variable_name='innodb_compression_level';
24 VARIABLE_NAME VARIABLE_VALUE
25 innodb_compression_level 6
26 set global innodb_compression_level=2;
27 select @@global.innodb_compression_level;
28 @@global.innodb_compression_level
29 2
30 select * from performance_schema.global_variables where variable_name='innodb_compression_level';
31 VARIABLE_NAME VARIABLE_VALUE
32 innodb_compression_level 2
33 select * from performance_schema.session_variables where variable_name='innodb_compression_level';
34 VARIABLE_NAME VARIABLE_VALUE
35 innodb_compression_level 2
36 set session innodb_compression_level=4;
37 ERROR HY000: Variable 'innodb_compression_level' is a GLOBAL variable and should be set with SET GLOBAL
38 set global innodb_compression_level=1.1;
39 ERROR 42000: Incorrect argument type to variable 'innodb_compression_level'
40 set global innodb_compression_level=1e1;
41 ERROR 42000: Incorrect argument type to variable 'innodb_compression_level'
42 set global innodb_compression_level="foo";
43 ERROR 42000: Incorrect argument type to variable 'innodb_compression_level'
44 set global innodb_compression_level=10;
45 Warnings:
46 Warning 1292 Truncated incorrect innodb_compression_level value: '10'
47 select @@global.innodb_compression_level;
48 @@global.innodb_compression_level
49 9
50 select * from performance_schema.global_variables where variable_name='innodb_compression_level';
51 VARIABLE_NAME VARIABLE_VALUE
52 innodb_compression_level 9
53 set global innodb_compression_level=-7;
54 Warnings:
55 Warning 1292 Truncated incorrect innodb_compression_level value: '-7'
56 select @@global.innodb_compression_level;
57 @@global.innodb_compression_level
58 0
59 select * from performance_schema.global_variables where variable_name='innodb_compression_level';
60 VARIABLE_NAME VARIABLE_VALUE
61 innodb_compression_level 0
62 set global innodb_compression_level=0;
63 select @@global.innodb_compression_level;
64 @@global.innodb_compression_level
65 0
66 set global innodb_compression_level=9;
67 select @@global.innodb_compression_level;
68 @@global.innodb_compression_level
69 9
70 SET @@global.innodb_compression_level = @start_global_value;
71 SELECT @@global.innodb_compression_level;
72 @@global.innodb_compression_level
73 6