summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/r/join_cache_level_basic.result
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2012-01-13 15:50:02 +0100
committerSergei Golubchik <sergii@pisem.net>2012-01-13 15:50:02 +0100
commit4f435bddfd44d40999f88685c61cc04e319d8d6c (patch)
treef9d0655a0d901b87f918a736741144b502cba3f6 /mysql-test/suite/sys_vars/r/join_cache_level_basic.result
parent8c2bcdf85ff753bceeb5b235f3605e348e6f9e1d (diff)
parent6ca4ca7d37fed3b3da18666768de6a2f8c34bc7b (diff)
downloadmariadb-git-4f435bddfd44d40999f88685c61cc04e319d8d6c.tar.gz
5.3 merge
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.result12
1 files changed, 6 insertions, 6 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 871a8a28c39..eca823a5d72 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,22 @@
SET @start_global_value = @@global.join_cache_level;
select @@global.join_cache_level;
@@global.join_cache_level
-1
+2
select @@session.join_cache_level;
@@session.join_cache_level
-1
+2
show global variables like 'join_cache_level';
Variable_name Value
-join_cache_level 1
+join_cache_level 2
show session variables like 'join_cache_level';
Variable_name Value
-join_cache_level 1
+join_cache_level 2
select * from information_schema.global_variables where variable_name='join_cache_level';
VARIABLE_NAME VARIABLE_VALUE
-JOIN_CACHE_LEVEL 1
+JOIN_CACHE_LEVEL 2
select * from information_schema.session_variables where variable_name='join_cache_level';
VARIABLE_NAME VARIABLE_VALUE
-JOIN_CACHE_LEVEL 1
+JOIN_CACHE_LEVEL 2
set global join_cache_level=4;
select @@global.join_cache_level;
@@global.join_cache_level