Debian Codegraph @

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

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