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 performance_schema.global_variables where variable_name='flush_time';
14 VARIABLE_NAME VARIABLE_VALUE
15 flush_time 0
16 select * from performance_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 = DEFAULT;
26 SELECT @@global.flush_time;
27 @@global.flush_time
28 0
29 SET @@global.flush_time = -1024;
30 Warnings:
31 Warning 1292 Truncated incorrect flush_time value: '-1024'
32 SELECT @@global.flush_time;
33 @@global.flush_time
34 0
35 set global flush_time=1.1;
36 ERROR 42000: Incorrect argument type to variable 'flush_time'
37 set global flush_time=1e1;
38 ERROR 42000: Incorrect argument type to variable 'flush_time'
39 set global flush_time="foo";
40 ERROR 42000: Incorrect argument type to variable 'flush_time'
41 set global flush_time=" ";
42 ERROR 42000: Incorrect argument type to variable 'flush_time'
43 set global flush_time=0;
44 select @@global.flush_time;
45 @@global.flush_time
46 0
47 set global flush_time=cast(-1 as unsigned int);
48 Warnings:
49 Warning 1292 Truncated incorrect flush_time value: '18446744073709551615'
50 select @@global.flush_time;
51 @@global.flush_time
52 31536000
53 SET @@global.flush_time = @start_global_value;