Debian Codegraph @

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

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