summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/r/long_query_time_basic.result
diff options
context:
space:
mode:
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.result32
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