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