diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/long_query_time_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/long_query_time_basic.result | 32 |
1 files changed, 5 insertions, 27 deletions
diff --git a/mysql-test/suite/sys_vars/r/long_query_time_basic.result b/mysql-test/suite/sys_vars/r/long_query_time_basic.result index 2fb9ff143ac..198030e7564 100644 --- a/mysql-test/suite/sys_vars/r/long_query_time_basic.result +++ b/mysql-test/suite/sys_vars/r/long_query_time_basic.result @@ -1,30 +1,15 @@ SET @start_global_value = @@global.long_query_time; -SELECT @start_global_value; -@start_global_value -10 SET @start_session_value = @@session.long_query_time; -SELECT @start_session_value; -@start_session_value -10 '#--------------------FN_DYNVARS_068_01-------------------------#' SET @@global.long_query_time = 100; SET @@global.long_query_time = DEFAULT; -SELECT @@global.long_query_time; -@@global.long_query_time -10.000000 -SET @@session.long_query_time = 200; -SET @@session.long_query_time = DEFAULT; -SELECT @@session.long_query_time; -@@session.long_query_time -10.000000 -'#--------------------FN_DYNVARS_068_02-------------------------#' -SET @@global.long_query_time = DEFAULT; -SELECT @@global.long_query_time = 10; -@@global.long_query_time = 10 +SELECT @@global.long_query_time >= 0; +@@global.long_query_time >= 0 1 +SET @@session.long_query_time = 200; SET @@session.long_query_time = DEFAULT; -SELECT @@session.long_query_time = 10; -@@session.long_query_time = 10 +SELECT @@session.long_query_time >= 0; +@@session.long_query_time >= 0 1 '#--------------------FN_DYNVARS_068_03-------------------------#' SET @@global.long_query_time = 0; @@ -157,10 +142,3 @@ ERROR 42S02: Unknown table 'session' in field list SELECT long_query_time = @@session.long_query_time; ERROR 42S22: Unknown column 'long_query_time' in 'field list' SET @@global.long_query_time = @start_global_value; -SELECT @@global.long_query_time; -@@global.long_query_time -10.000000 -SET @@session.long_query_time = @start_session_value; -SELECT @@session.long_query_time; -@@session.long_query_time -10.000000 |