summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/r/userstat_basic.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sys_vars/r/userstat_basic.result')
-rw-r--r--mysql-test/suite/sys_vars/r/userstat_basic.result7
1 files changed, 4 insertions, 3 deletions
diff --git a/mysql-test/suite/sys_vars/r/userstat_basic.result b/mysql-test/suite/sys_vars/r/userstat_basic.result
index 2d082cd3a25..9fbb88d5f70 100644
--- a/mysql-test/suite/sys_vars/r/userstat_basic.result
+++ b/mysql-test/suite/sys_vars/r/userstat_basic.result
@@ -1,9 +1,10 @@
SET @start_global_value = @@global.userstat;
-select @@global.userstat;
-@@global.userstat
-0
+select @@global.userstat = 0 or @@global.userstat = 1;
+@@global.userstat = 0 or @@global.userstat = 1
+1
select @@session.userstat;
ERROR HY000: Variable 'userstat' is a GLOBAL variable
+SET @@global.userstat=0;
show global variables like 'userstat';
Variable_name Value
userstat OFF