diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/join_cache_level_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/join_cache_level_basic.result | 14 |
1 files changed, 4 insertions, 10 deletions
diff --git a/mysql-test/suite/sys_vars/r/join_cache_level_basic.result b/mysql-test/suite/sys_vars/r/join_cache_level_basic.result index eca823a5d72..63c1d8ba417 100644 --- a/mysql-test/suite/sys_vars/r/join_cache_level_basic.result +++ b/mysql-test/suite/sys_vars/r/join_cache_level_basic.result @@ -1,22 +1,16 @@ SET @start_global_value = @@global.join_cache_level; -select @@global.join_cache_level; -@@global.join_cache_level -2 -select @@session.join_cache_level; -@@session.join_cache_level -2 show global variables like 'join_cache_level'; Variable_name Value -join_cache_level 2 +join_cache_level # show session variables like 'join_cache_level'; Variable_name Value -join_cache_level 2 +join_cache_level # select * from information_schema.global_variables where variable_name='join_cache_level'; VARIABLE_NAME VARIABLE_VALUE -JOIN_CACHE_LEVEL 2 +JOIN_CACHE_LEVEL # select * from information_schema.session_variables where variable_name='join_cache_level'; VARIABLE_NAME VARIABLE_VALUE -JOIN_CACHE_LEVEL 2 +JOIN_CACHE_LEVEL # set global join_cache_level=4; select @@global.join_cache_level; @@global.join_cache_level |