diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/join_cache_level_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/join_cache_level_basic.test | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/mysql-test/suite/sys_vars/t/join_cache_level_basic.test b/mysql-test/suite/sys_vars/t/join_cache_level_basic.test index 1e0deb9c028..a39ddffeab2 100644 --- a/mysql-test/suite/sys_vars/t/join_cache_level_basic.test +++ b/mysql-test/suite/sys_vars/t/join_cache_level_basic.test @@ -5,11 +5,13 @@ SET @start_global_value = @@global.join_cache_level; # # exists as global only # -select @@global.join_cache_level; -select @@session.join_cache_level; +--replace_column 2 # show global variables like 'join_cache_level'; +--replace_column 2 # show session variables like 'join_cache_level'; +--replace_column 2 # select * from information_schema.global_variables where variable_name='join_cache_level'; +--replace_column 2 # select * from information_schema.session_variables where variable_name='join_cache_level'; # @@ -39,4 +41,3 @@ set session join_cache_level=cast(-1 as unsigned int); select @@session.join_cache_level; SET @@global.join_cache_level = @start_global_value; - |