Debian Codegraph @

mysql-test/suite/sys_vars/t/progress_report_time_basic.test

raw
1 # ulong session
2
3 SET @start_global_value = @@global.progress_report_time;
4
5 #
6 # exists as global only
7 #
8 select @@global.progress_report_time;
9 select @@session.progress_report_time;
10 show global variables like 'progress_report_time';
11 show session variables like 'progress_report_time';
12 select * from information_schema.global_variables where variable_name='progress_report_time';
13 select * from information_schema.session_variables where variable_name='progress_report_time';
14
15 #
16 # show that it's writable
17 #
18 set global progress_report_time=10;
19 select @@global.progress_report_time;
20 set session progress_report_time=10;
21 select @@session.progress_report_time;
22
23 #
24 # incorrect types
25 #
26 --error ER_WRONG_TYPE_FOR_VAR
27 set global progress_report_time=1.1;
28 --error ER_WRONG_TYPE_FOR_VAR
29 set session progress_report_time=1e1;
30 --error ER_WRONG_TYPE_FOR_VAR
31 set global progress_report_time="foo";
32
33 #
34 # min/max values, block size
35 #
36 set global progress_report_time=0;
37 select @@global.progress_report_time;
38 set session progress_report_time=cast(-1 as unsigned int);
39 select @@session.progress_report_time;
40
41 SET @@global.progress_report_time = @start_global_value;
42