Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.flush_time;
2 select @@global.flush_time;
3 @@global.flush_time
4 0
5 select @@session.flush_time;
6 ERROR HY000: Variable 'flush_time' is a GLOBAL variable
7 show global variables like 'flush_time';
8 Variable_name Value
9 flush_time 0
10 show session variables like 'flush_time';
11 Variable_name Value
12 flush_time 0
13 select * from information_schema.global_variables where variable_name='flush_time';
14 VARIABLE_NAME VARIABLE_VALUE
15 FLUSH_TIME 0
16 select * from information_schema.session_variables where variable_name='flush_time';
17 VARIABLE_NAME VARIABLE_VALUE
18 FLUSH_TIME 0
19 set global flush_time=1;
20 select @@global.flush_time;
21 @@global.flush_time
22 1
23 set session flush_time=1;
24 ERROR HY000: Variable 'flush_time' is a GLOBAL variable and should be set with SET GLOBAL
25 set global flush_time=1.1;
26 ERROR 42000: Incorrect argument type to variable 'flush_time'
27 set global flush_time=1e1;
28 ERROR 42000: Incorrect argument type to variable 'flush_time'
29 set global flush_time="foo";
30 ERROR 42000: Incorrect argument type to variable 'flush_time'
31 set global flush_time=0;
32 select @@global.flush_time;
33 @@global.flush_time
34 0
35 set global flush_time=cast(-1 as unsigned int);
36 Warnings:
37 Note 1105 Cast to unsigned converted negative integer to it's positive complement
38 Warning 1292 Truncated incorrect flush_time value: '18446744073709551615'
39 select @@global.flush_time;
40 @@global.flush_time
41 31536000
42 SET @@global.flush_time = @start_global_value;