diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/userstat_basic.test')
| -rw-r--r-- | mysql-test/suite/sys_vars/t/userstat_basic.test | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/suite/sys_vars/t/userstat_basic.test b/mysql-test/suite/sys_vars/t/userstat_basic.test index 55aa98c90c7..cd227b7c507 100644 --- a/mysql-test/suite/sys_vars/t/userstat_basic.test +++ b/mysql-test/suite/sys_vars/t/userstat_basic.test @@ -1,13 +1,14 @@ # bool global SET @start_global_value = @@global.userstat; - # # exists as global only # -select @@global.userstat; +select @@global.userstat = 0 or @@global.userstat = 1; --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.userstat; + +SET @@global.userstat=0; show global variables like 'userstat'; show session variables like 'userstat'; select * from information_schema.global_variables where variable_name='userstat'; |